PV_REQ_PO_XREF(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.PO_ID , B.PO_STATUS , B.RECV_STATUS , A.LINE_NBR , A.SCHED_NBR , A.REQ_ID , A.REQ_LINE_NBR , C.CANCEL_STATUS , A.DISTRIB_LN_STATUS FROM PS_PO_LINE_DISTRIB A , PS_PO_HDR B , PS_PO_LINE C WHERE B.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.PO_ID = C.PO_ID AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PO_ID = C.PO_ID AND A.LINE_NBR = C.LINE_NBR AND A.REQ_ID <> ' ' GROUP BY A.BUSINESS_UNIT, A.PO_ID, B.PO_STATUS, B.RECV_STATUS, A.LINE_NBR, A.SCHED_NBR, A.REQ_ID, A.REQ_LINE_NBR, C.CANCEL_STATUS, A. DISTRIB_LN_STATUS |
| # | 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 | PO_STATUS | Character(2) | VARCHAR2(2) NOT NULL |
PO Status
A=Approved C=Complete D=Dispatched DA=Denied I=Initial LD=Line Denied O=Open PA=Pending Approval/Approved PX=Pending Cancel X=Canceled |
| 4 | RECV_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Receipt Status
C=Closed Receipt H=Hold Receipt M=Moved to Destination N=PO Not Received O=Open P=PO Partially Received R=Fully Received X=Canceled |
| 5 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 6 | SCHED_NBR | Number(3,0) | SMALLINT NOT NULL | Schedule Number |
| 7 | REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 8 | REQ_LINE_NBR | Number(5,0) | INTEGER NOT NULL | Requisition Line Number |
| 9 | CANCEL_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Cancel Status
A=Active C=Closed D=Denied H=Hold O=Open P=Pending Approval X=Canceled |
| 10 | DISTRIB_LN_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Distribution Line Status
C=Closed M=Mass Liquidated O=Open P=Unavailable for Sourcing X=Canceled |