SETIDMSTR_CNTRCT_IDCS_POCOPYMST_VW(SQL View) |
Index Back |
|---|---|
Contract Search for PO's |
| SELECT DISTINCT B.SETID , H.MSTR_CNTRCT_ID FROM PS_CS_DOC_HDR A , PS_CS_DOC_PO_KEYS B , PS_CNTRCT_HDR H WHERE A.CS_SOURCE_TRANS = '02' AND A.CS_IMPORT_CODE = '1' AND A.CS_DOC_BLD_STATUS = '1' AND B.CS_DOC_ID = A.CS_DOC_ID AND H.SETID = B.SETID AND H.CNTRCT_ID = B.CNTRCT_ID AND H.VERSION_NBR = B.VERSION_NBR AND H.MSTR_CNTRCT_ID <> ' ' AND EXISTS( SELECT 'X' FROM PS_CS_DOC_FILES F WHERE F.CS_DOC_ID = A.CS_DOC_ID AND F.CS_DOC_TYPE = '001') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 2 | MSTR_CNTRCT_ID |
Character(10) | VARCHAR2(10) NOT NULL | Master Contract ID |