PO_EXDT_APPL_VW

(SQL View)
Index Back

Planned orders by group

cel 05/01/2002 Sum of planned orders by group code ...by DATE, that are within a capacity range .. used to be able to find the specific date that capacity exceeded. (used to populate po_cap_excd_tmp and then looped through).

SELECT DISTINCT A.OPRID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.INV_ITEM_ID , A.SCHED_GROUP_CD , A.DUE_DT , SUM(A.QTY_STD) FROM PS_PO_BUY_COLL_TMP A GROUP BY A.OPRID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC ,A.INV_ITEM_ID , A.SCHED_GROUP_CD , A.DUE_DT

# 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 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
3 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
4 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 SCHED_GROUP_CD Character(6) VARCHAR2(6) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
7 DUE_DATE Date(10) DATE Delivery Due Date from PO
8 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity