BUSINESS_UNITCONTRACT_NUM_CACA_LINK_ACT_VW(SQL View) |
Index Back |
|---|---|
Link existing contracts view |
| SELECT CA.BUSINESS_UNIT , CA.CONTRACT_NUM , CA.DESCR FROM PS_CA_CONTR_HDR CA WHERE CA.CA_PROC_STATUS='P' AND CA.CONTRACT_NUM NOT IN ( SELECT CA.CONTRACT_NUM FROM PS_PTAI_CONTEXT PT ,PS_PTAI_LIST PL ,PS_CA_CONTR_HDR CA WHERE PT.PTAI_LIST_ID=PL.PTAI_LIST_ID AND PT.FIELDNAME = 'CONTRACT_NUM' AND PT.RECNAME = 'CA_CONTR_HDR' AND PT.PTAI_KEY_VALUE <> ' ' AND PT.PTAI_LIST_ID LIKE 'CA_ENTRYLL%' AND PT.PTAI_KEY_VALUE=CA.CONTRACT_NUM) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CONTRACT_NUM_CA |
Character(25) | VARCHAR2(25) NOT NULL | Contract Number |
| 3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |