BUSINESS_UNITRECEIVER_IDBUSINESS_UNIT_POPO_IDBUSINESS_UNIT_REQREQ_IDPV_RECV_REQ_UP1(SQL View) |
Index Back |
|---|
| SELECT DISTINCT A.BUSINESS_UNIT , A.RECEIVER_ID , A.BUSINESS_UNIT_PO , A.PO_ID , A.BUSINESS_UNIT_REQ , A.REQ_ID , B.REQ_NAME FROM PS_PV_RECV_REQ_UP2 A , PS_REQ_HDR B WHERE A.REQ_ID = B.REQ_ID (+) AND A.BUSINESS_UNIT=B.BUSINESS_UNIT (+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | RECEIVER_ID |
Character(10) | VARCHAR2(10) NOT NULL | Receiver number |
| 3 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 4 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Purchase Order |
| 5 | BUSINESS_UNIT_REQ |
Character(5) | VARCHAR2(5) NOT NULL | Requesting Business Unit |
| 6 | REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Requisition ID |
| 7 | REQ_NAME | Character(30) | VARCHAR2(30) NOT NULL | Requisition Name |