ORDENT_QALLCKTS

(SQL View)
 Index Back

SELECT DPI.SOURCE_BUS_UNIT , DPI.ORDER_NO , DPI.ORDER_INT_LINE_NO , DPI.SCHED_LINE_NBR , DPI.BUSINESS_UNIT , DPI.INV_ITEM_ID , %Round(SUM(%DecDiv(DPI.QTY_PICKED,IND.QTY_PER)),4) FROM PS_IN_DEMAND IND , PS_DEMAND_PHYS_INV DPI WHERE IND.BUSINESS_UNIT = DPI.BUSINESS_UNIT AND IND.DEMAND_SOURCE = DPI.DEMAND_SOURCE AND IND.SOURCE_BUS_UNIT = DPI.SOURCE_BUS_UNIT AND IND.ORDER_NO = DPI.ORDER_NO AND IND.ORDER_INT_LINE_NO = DPI.ORDER_INT_LINE_NO AND IND.SCHED_LINE_NBR = DPI.SCHED_LINE_NBR AND IND.DEMAND_LINE_NO = DPI.DEMAND_LINE_NO AND IND.INV_ITEM_ID = DPI.INV_ITEM_ID AND DPI.DEMAND_SOURCE = 'OM' AND IND.QTY_PER > 0 AND IND.QTY_CODE = 'ASY' AND IND.OPTIONAL_SHIP = 'N' GROUP BY DPI.SOURCE_BUS_UNIT, DPI.ORDER_NO, DPI.ORDER_INT_LINE_NO, DPI.SCHED_LINE_NBR, DPI.BUSINESS_UNIT, DPI.INV_ITEM_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
7 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity