BUSINESS_UNITREQ_IDDefault Value: NEXT
LINE_NBRDefault Value: 1
Prompt Table: %EDITTABLE30
Prompt Table: PO_CNTRCT_VER
Prompt Table: %EDIT_CNTRCT_LN
PV_REQ_CNTRC_VW(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.REQ_ID , A.LINE_NBR , B.SETID , B.CNTRCT_ID , B.VERSION_NBR , B.CNTRCT_LINE_NBR , B.CAT_LINE_NBR FROM PS_REQ_LINE A , PS_CNTRCT_EVT_REQ B WHERE A.BUSINESS_UNIT=B.BUSINESS_UNIT AND A.REQ_ID = B.REQ_ID AND A.LINE_NBR = B.LINE_NBR AND B.EVENT_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Requisition ID
Default Value: NEXT |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL |
Line Number:
11/24/08 - Added TARGET label [PC product]
Default Value: 1 |
| 4 | CNTRCT_SETID | Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 5 | CNTRCT_ID | Character(25) | VARCHAR2(25) NOT NULL |
Buying Agreement ID
Prompt Table: %EDITTABLE30 |
| 6 | VERSION_NBR | Number(5,0) | INTEGER NOT NULL |
Contract Version number
Prompt Table: PO_CNTRCT_VER |
| 7 | CNTRCT_LINE_NBR | Number(5,0) | INTEGER NOT NULL |
Buying Agreement Line Nbr
Prompt Table: %EDIT_CNTRCT_LN |
| 8 | CAT_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Contract Category Line Number |