PV_CHNG_APPV_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT B.BUSINESS_UNIT , B.PO_ID , B.OPRID , B.PROCESS_INSTANCE , PO.BUYER_ID FROM PS_CHNG_RQST B , PS_PO_HDR PO WHERE B.BUSINESS_UNIT = PO.BUSINESS_UNIT AND B.PO_ID = PO.PO_ID AND EXISTS ( SELECT DISTINCT APPROVED_FLG FROM PS_CHNG_RQST_DTL A WHERE B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.PO_ID = A.PO_ID AND B.CHNG_SOURCE = A.CHNG_SOURCE AND B.PROCESS_INSTANCE = A.PROCESS_INSTANCE AND APPROVED_FLG = 'N') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PO_ID | Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 3 | REQUESTOR_ID | Character(30) | VARCHAR2(30) NOT NULL | Requestor id |
| 4 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 5 | BUYER_ID | Character(30) | VARCHAR2(30) NOT NULL | Buyer |