EOPM_UPDSCR_SRC

(SQL View)
 Index Back

EOPM Update Descr Lookup view

Lookup view for Security Deployment - Update Description page

SELECT PTIASPRPTNO ,PTIASPSPVERS ,PTIASPRPTSUBJECT FROM PS_PTIASPRPTHEAD PT WHERE PTIASPRPTNO IN ( SELECT ptiasprptno FROM ps_eopm_supd_mnu ) UNION SELECT PTIASPRPTNO ,PTIASPSPVERS ,PTIASPRPTSUBJECT FROM PS_PTIASPRPTHEAD PT WHERE PTIASPRPTNO IN ( SELECT ptiasprptno FROM ps_eopm_supd_dtl ) UNION SELECT PTIASPRPTNO ,PTIASPSPVERS ,PTIASPRPTSUBJECT FROM PS_PTIASPRPTHEAD PT WHERE PTIASPRPTNO IN ( SELECT ptiasprptno FROM PS_EOPM_SUPD_RLE ) UNION SELECT DISTINCT ptiasprptno ,0 ,' ' FROM PS_EOPM_SUPD_DTL dtl WHERE NOT EXISTS ( SELECT 1 FROM ps_ptiasprpthead pt WHERE dtl.ptiasprptno = pt.ptiasprptno) UNION SELECT DISTINCT ptiasprptno ,0 ,' ' FROM PS_EOPM_SUPD_MNU dtl WHERE NOT EXISTS ( SELECT 1 FROM ps_ptiasprpthead pt WHERE dtl.ptiasprptno = pt.ptiasprptno) UNION SELECT DISTINCT ptiasprptno ,0 ,' ' FROM PS_EOPM_SUPD_RLE dtl WHERE NOT EXISTS ( SELECT 1 FROM ps_ptiasprpthead pt WHERE dtl.ptiasprptno = pt.ptiasprptno)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PTIASPRPTNO Number(10,0) DECIMAL(10) NOT NULL BUG Number

Prompt Table: PTIASPRPTHEAD

2 PTIASPSPVERS Number(5,0) INTEGER NOT NULL Numeric value for Patch Database Version Number
3 PTIASPRPTSUBJECT Character(240) VARCHAR2(240) NOT NULL Bug Subject