IN_SDWC_SCH_VW

(SQL View)
 Index Back

SupDmdWC OM Schedule view

view of OM order schedule data by demand line

SELECT D.BUSINESS_UNIT , D.DEMAND_SOURCE , D.SOURCE_BUS_UNIT , D.ORDER_NO , D.ORDER_INT_LINE_NO , D.SCHED_LINE_NBR , SUM(CASE D.QTY_CODE WHEN 'ORD' THEN 0 ELSE D.QTY_REQUESTED - D.QTY_BACKORDER END) , SUM(CASE D.QTY_CODE WHEN 'ORD' THEN 0 ELSE D.QTY_SHIPPED_CONV END) , CASE WHEN S.NET_UNIT_PRICE IS NULL THEN 0 ELSE %Round(%DecMult(S.NET_UNIT_PRICE, S.QTY_SCHEDULED), 0) END , CASE WHEN S.CURRENCY_CD IS NULL THEN ' ' ELSE S.CURRENCY_CD END , CASE WHEN S.CUST_PICKUP IS NULL THEN 'N' ELSE S.CUST_PICKUP END , %CurrentDateIn FROM PS_IN_DEMAND D LEFT OUTER JOIN PS_ORD_SCHEDULE S ON D.DEMAND_SOURCE = 'OM' AND D.SOURCE_BUS_UNIT = S.BUSINESS_UNIT AND D.ORDER_NO = S.ORDER_NO AND D.ORDER_INT_LINE_NO = S.ORDER_INT_LINE_NO AND D.SCHED_LINE_NBR = S.SCHED_LINE_NBR WHERE D.IN_FULFILL_STATE < '90' GROUP BY D.BUSINESS_UNIT , D.DEMAND_SOURCE , D.SOURCE_BUS_UNIT , D.ORDER_NO , D.ORDER_INT_LINE_NO , D.SCHED_LINE_NBR , S.NET_UNIT_PRICE, S.QTY_SCHEDULED, S.CURRENCY_CD, S.CUST_PICKUP

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 DEMAND_SOURCE Character(2) VARCHAR2(2) NOT NULL Demand Source
IN=Material Request
OM=Sales Order
PL=Planning Requisition
PO=Purchase Order
PR=Purchasing Requisition
RT=Material Return
SF=Production Request
WM=Work Order
3 SOURCE_BUS_UNIT Character(5) VARCHAR2(5) NOT NULL Source Bus Unit
4 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
5 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
6 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
7 TOTAL_QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Total Quantity
8 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped
9 EXTENDED_NET_PRICE Signed Number(29,4) DECIMAL(27,4) NOT NULL Ext Net Amount
10 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
11 CUST_PICKUP Character(1) VARCHAR2(1) NOT NULL Counter sale customer pickup flag
N=No
Y=Yes
12 IN_PROCESS_DATE Date(10) DATE Process Date