SETIDCNTRCT_IDCAT_LINE_NBRA=Active
C=Cancelled
I=Inactive
O=Open
P=Pending
CNTRCT_CAT_CS(SQL View) |
Index Back |
|---|
| SELECT A.SETID , A.CNTRCT_ID , A.CAT_LINE_NBR , A.LINE_STATUS , A.CATEGORY_SETID , A.CATEGORY_ID , C.CATEGORY_CD , C.DESCR60 FROM PS_CNTRCT_CATEGORY A , PS_CNTRCT_HDR H , PS_ITM_CAT_TBL C , PS_INSTALLATION_PO D WHERE H.VERSION_STATUS = 'C' AND A.SETID = H.SETID AND A.CNTRCT_ID = H.CNTRCT_ID AND A.VERSION_NBR = H.VERSION_NBR AND A.LINE_STATUS NOT IN ('C','I') AND A.CATEGORY_SETID = C.SETID AND A.CATEGORY_ID = C.CATEGORY_ID AND C.CATEGORY_TYPE = D.CATEGORY_TYPE AND %EffdtCheck(ITM_CAT_TBL E, C, H.CNTRCT_BEGIN_DT) AND C.EFF_STATUS = 'A' AND EXISTS ( SELECT 'x' FROM PS_CS_CNT_AG B WHERE A.SETID = B.SETID AND A.CNTRCT_ID=B.CNTRCT_ID AND A.CAT_LINE_NBR=B.CAT_LINE_NBR AND B.CNTRCT_LINE_NBR = 0 AND A.VERSION_NBR=B.VERSION_NBR) |
| # | 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 | CAT_LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Contract Category Line Number |
| 4 | LINE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Line Status
A=Active C=Cancelled I=Inactive O=Open P=Pending |
| 5 | CATEGORY_SETID | Character(5) | VARCHAR2(5) NOT NULL | Category SetID |
| 6 | CATEGORY_ID | Character(5) | VARCHAR2(5) NOT NULL | Category ID |
| 7 | CATEGORY_CD | Character(18) | VARCHAR2(18) NOT NULL | Category Code |
| 8 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |