OPRIDBUSINESS_UNIT_POPO_IDDefault Value: NEXT
Default Value: %date
ORDTRK_PO_SS_VW(SQL View) |
Index Back |
|---|---|
Order Track Vw - Purch (SS)Order Track View- Purchased (SS) Date Initials Issue Description 052704 twh F-KNANN-V59N4 Replace demand table references with IN_DEMAND |
| SELECT DISTINCT C.OPRID , P.BUSINESS_UNIT , P.PO_ID , P.PO_DT , P.PO_REF FROM PS_PO_HDR P , PS_CUST_SSSHIP_VW C , PS_ORD_SCHEDULE S , PS_SET_CNTRL_REC R , PS_IN_PEG_DMD_POVW D WHERE D.BUSINESS_UNIT_IN = S.SHIP_FROM_BU AND D.DEMAND_SOURCE = 'OM' AND D.SOURCE_BUS_UNIT = S.BUSINESS_UNIT AND D.ORDER_INT_LINE_NO = S.ORDER_INT_LINE_NO AND D.SCHED_LINE_NBR = S.SCHED_LINE_NBR AND P.BUSINESS_UNIT = D.BUSINESS_UNIT AND P.PO_ID = D.PO_ID AND R.RECNAME = 'CUSTOMER' AND R.SETCNTRLVALUE = S.BUSINESS_UNIT AND R.SETID = C.SETID AND C.SHIP_TO_CUST_ID = S.SHIP_TO_CUST_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | BUSINESS_UNIT_PO |
Character(5) | VARCHAR2(5) NOT NULL | PO Business Unit |
| 3 | PO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Purchase Order
Default Value: NEXT |
| 4 | PO_DT | Date(10) | DATE NOT NULL |
Date
Default Value: %date |
| 5 | PO_REF | Character(30) | VARCHAR2(30) NOT NULL | Specifies the purchase order number associated with a receivables item. |