OM_SCHED_SI2_VW

(SQL View)
 Index Back

Order Schedule Ship View

Order Schedule Ship View Date Initials Issue Description 052704 twh F-KNANN-V59N4 Replace demand table references with IN_DEMAND

SELECT D.SOURCE_BUS_UNIT , D.ORDER_NO , D.ORDER_INT_LINE_NO , D.SCHED_LINE_NBR , MAX(D.PARENT_PROD_ID ) , MAX(D.INV_ITEM_ID ) , SUM(D.QTY_REQUESTED) , SUM(D.QTY_ALLOCATED ) , SUM(D.QTY_PICKED ) , SUM(D.QTY_SHIPPED ) , SUM(D.QTY_BACKORDER ) , MAX(B.INVOICE ) FROM PS_IN_DEMAND D , PS_IN_DEMAND_BI B WHERE D.BUSINESS_UNIT = B.BUSINESS_UNIT(+) AND D.DEMAND_SOURCE = B.DEMAND_SOURCE(+) AND D.SOURCE_BUS_UNIT = B.SOURCE_BUS_UNIT(+) AND D.ORDER_NO = B.ORDER_NO(+) AND D.ORDER_INT_LINE_NO = B.ORDER_INT_LINE_NO(+) AND D.SCHED_LINE_NBR = B.SCHED_LINE_NBR(+) AND D.INV_ITEM_ID = B.INV_ITEM_ID(+) AND D.DEMAND_LINE_NO = B.DEMAND_LINE_NO(+) AND D.DEMAND_SOURCE = 'OM' AND D.IN_FULFILL_STATE IN ('50','60', '70') GROUP BY D.SOURCE_BUS_UNIT , D.ORDER_NO , D.ORDER_INT_LINE_NO , D.SCHED_LINE_NBR

# 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 PARENT_PROD_ID Character(18) VARCHAR2(18) NOT NULL Parent Product Id
6 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID

Prompt Table: BU_ITM_INV_VW2

7 QTY_REQUESTED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Requested
8 QTY_ALLOCATED Signed Number(17,4) DECIMAL(15,4) NOT NULL Allocated quantity
9 QTY_PICKED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Picked
10 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
11 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty
12 INVOICE_ID_FROM Character(30) VARCHAR2(30) NOT NULL Invoice Number