PO_CAPPRP_GP_VW

(SQL View)
 Index Back

Sum of PL/by group code

cel 05/01/2002 Sum of planned orders by group code ... that are within predefined capacity date ranges for each group.

SELECT DISTINCT A.OPRID , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.ITM_SETID , ' ' , A.SCHED_GROUP_CD , A.UNIT_MEASURE_STD , A.FROM_DT , A.TO_DT , %subrec(PO_CAP_FLEX_SBR,A) , A.QTY_MAX , 0 , SUM(D.QTY_STD) FROM PS_PO_CAP_SUM_VW A , PS_PO_BUY_COLL_TMP D WHERE A.INV_ITEM_ID = ' ' AND A.OPRID = D.OPRID AND D.CALC_DT >= A.FROM_DT AND D.CALC_DT <= A.TO_DT GROUP BY A.OPRID, A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , A.ITM_SETID ,A.SCHED_GROUP_CD , A.BUSINESS_UNIT_IN , A.UNIT_MEASURE_STD, A.FROM_DT , A.TO_DT, %subrec(PO_CAP_FLEX_SBR,A) ,A.QTY_MAX

# 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 ITM_SETID Character(5) VARCHAR2(5) NOT NULL Item SetID
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 SCHED_GROUP_CD Character(6) VARCHAR2(6) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
8 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
9 FROM_DT Date(10) DATE From Date
10 TO_DT Date(10) DATE To Date
11 COLLAB_SCH_STATUS Character(2) VARCHAR2(2) NOT NULL 02/2001 cel WV-802-1.0 - Status of the supplier schedule
01=New
10=Current
20=Dispatched
30=Supplier Approved
40=Previous
50=History
12 DATETIME_COLLAB DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0. Datetime of when the line was approved by the supplier.
13 DATETIME_DISPATCH DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0
14 DATETIME_CREATE DateTime(26) TIMESTAMP 02/2001 cel WV-802-1.0.
15 SCHEDULE_START_DT Date(10) DATE 02/2001 cel WV-802-1.0
16 SCHEDULE_END_DT Date(10) DATE 02/2001 cel WV-802-1.0
17 UNIT_MEASURE_VNDR Character(3) VARCHAR2(3) NOT NULL Vendor Unit of Measure
18 DATETIME_APPLY DateTime(26) TIMESTAMP 08/27/01 SCC CN#WV840-1.0: Supplier Collaboration - New Field
19 INCLUDE_PO Character(1) VARCHAR2(1) NOT NULL Include PO Data
N=No
Y=Yes
20 DAYOFTHEWEEK Character(2) VARCHAR2(2) NOT NULL Day of the Week
1=Sunday
2=Monday
3=Tuesday
4=Wednesday
5=Thursday
6=Friday
7=Saturday
21 BUYER_ID_SEL Character(30) VARCHAR2(30) NOT NULL Buyer
22 QTY_MAX Number(16,4) DECIMAL(15,4) NOT NULL Maximum Quantity
23 CURRENT_QTY_VND Number(16,4) DECIMAL(15,4) NOT NULL 02/2001 cel WV-802-1.0. Holds the build/snapshot current requested qty on the Supplier and Schedulers Schedule Workbench. (in vendor's default uom
24 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity