OM_SCH_QTY_VW

(SQL View)
 Index Back

Claimback Total Sch Quantity

092304 sfc Created

SELECT OH.BUSINESS_UNIT , OL.PRODUCT_ID , OS.CB_CONTRACT_ID , OL.UNIT_OF_MEASURE , SUM(OS.QTY_SCHEDULED) FROM PS_ORD_HEADER OH , PS_ORD_LINE OL , PS_ORD_SCHEDULE OS WHERE OH.BUSINESS_UNIT = OL.BUSINESS_UNIT AND OH.ORDER_NO = OL.ORDER_NO AND OS.BUSINESS_UNIT = OL.BUSINESS_UNIT AND OS.ORDER_NO = OL.ORDER_NO AND OS.ORDER_INT_LINE_NO = OL.ORDER_INT_LINE_NO AND OH.ORDER_TYPE_CD = 'SO' AND OS.ORD_SCH_STATUS IN ('C', 'O', 'P') GROUP BY OH.BUSINESS_UNIT, OL.PRODUCT_ID, OS.CB_CONTRACT_ID, OL.UNIT_OF_MEASURE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
3 CB_CONTRACT_ID Character(25) VARCHAR2(25) NOT NULL Claimback Contract ID
4 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
5 QTY_SCHEDULED Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity Scheduled