PL_BW_CPITS_VW

(SQL View)
 Index Back

Capacity, Plan PO, Group/Item

Planned PO Capacity by Schedule Group/Item

SELECT A.PROBINST , B.SCHED_GROUP_CD , A.BUSINESS_UNIT , A.INV_ITEM_ID , A.CONFIG_CODE , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , %Dttm(B.FROM_DT , %TimeIn('00.00.00.000000')) , 'EX' , %Dttm(B.TO_DT , %TimeIn('23.59.59.000000')) , B.QTY_MAX , SUM(A.QTY_PO) FROM PS_PL_BW_PLNPO_VW A , PS_ITM_CAP_GRP_RNG B , PS_ITM_VND_BU_ATTR C , PS_SET_CNTRL_REC D WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT_IN AND A.INV_ITEM_ID = C.INV_ITEM_ID AND B.SCHED_GROUP_CD = C.SCHED_GROUP_CD AND A.BUSINESS_UNIT = D.SETCNTRLVALUE AND D.RECNAME = 'MASTER_ITEM_TBL' AND D.SETID = C.SETID AND A.VENDOR_SETID = B.VENDOR_SETID AND A.VENDOR_ID = B.VENDOR_ID AND A.VNDR_LOC = B.VNDR_LOC AND A.VENDOR_SETID = C.VENDOR_SETID AND A.VENDOR_ID = C.VENDOR_ID AND A.VNDR_LOC = C.VNDR_LOC AND A.DUE_DTTM >= %Dttm(B.FROM_DT , %TimeIn('00.00.00.000000')) AND A.DUE_DTTM <= %Dttm(B.TO_DT , %TimeIn('23.59.59.000000')) GROUP BY A.PROBINST , B.SCHED_GROUP_CD , A.BUSINESS_UNIT , A.INV_ITEM_ID , A.CONFIG_CODE , A.VENDOR_SETID , A.VENDOR_ID , A.VNDR_LOC , B.FROM_DT , B.TO_DT , B.QTY_MAX

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROBINST Character(20) VARCHAR2(20) NOT NULL Optimization Problem Instance
2 SCHED_GROUP_CD Character(6) VARCHAR2(6) NOT NULL 04/01/02 SCC CN#WV900-1.0: Supplier Collaboration - New Field
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: %EDITTABLE

4 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: %EDITTABLE2

5 CONFIG_CODE Character(50) VARCHAR2(50) NOT NULL Product Configurator

Prompt Table: %EDITTABLE5

6 VENDOR_SETID Character(5) VARCHAR2(5) NOT NULL Vendor SetID
7 VENDOR_ID Character(10) VARCHAR2(10) NOT NULL Vendor Identifier
8 VNDR_LOC Character(10) VARCHAR2(10) NOT NULL Vendor Location
9 FROM_DTTM DateTime(26) TIMESTAMP From Date/Time
10 ROW_TYPE Character(2) VARCHAR2(2) NOT NULL 01/23/01 SCC CN#WV802-1.0: New Field
11 TO_DTTM DateTime(26) TIMESTAMP Ending Number in Range
12 QTY_MAX Number(16,4) DECIMAL(15,4) NOT NULL Maximum Quantity
13 QTY_PO Number(16,4) DECIMAL(15,4) NOT NULL Purchase Order Quantity