EOPM_SUPD_SCTVW (SQL View)	Index Back
Update Autom Script Union PUM Security Atuomation collect data for exp/imp script generation

EOPM_SUPD_SCTVW

(SQL View)

Update Autom Script Union

PUM Security Atuomation collect data for exp/imp script generation

SELECT ptiasprptno FROM ps_eopm_supd_mnu WHERE eopm_selected = 'Y' UNION SELECT ptiasprptno FROM ps_eopm_supd_dtl WHERE eopm_selected = 'Y' UNION SELECT ptiasprptno FROM PS_EOPM_SUPD_RLE WHERE eopm_selected = 'Y' GROUP BY ptiasprptno

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number