CS_CWB_SECURITY

(SQL View)
 Index Back

SCMT Document Security

<* ******************************************************************* ********************************* Date Initials Reference # Description 03/11/2015 JOHAN SCMT009 Adding PTSF indexing to Supplier Contract Workbench ******************************************************************* ********************************* *>

SELECT HDR.SETID , HDR.CNTRCT_ID , SEC.SETID_SECURITY_SES FROM PS_CNTRCT_HDR HDR , PS_CS_SECSES_VW SEC WHERE NOT EXISTS( SELECT 'X' FROM PS_CS_DOC_PO_KEYS KEYS WHERE KEYS.SETID = HDR.SETID AND KEYS.CNTRCT_ID = HDR.CNTRCT_ID) AND HDR.SETID = SEC.SETID UNION ALL SELECT KEYS.SETID , KEYS.CNTRCT_ID , DOC.CS_DOC_SECURITY FROM PS_CS_DOC_SES_VW DOC , PS_CS_DOC_PO_KEYS KEYS WHERE KEYS.CS_DOC_ID = DOC.CS_DOC_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
2 CNTRCT_ID Character(25) VARCHAR2(25) NOT NULL Buying Agreement ID
3 CS_DOC_SECURITY Character(75) VARCHAR2(75) NOT NULL Document Security