ORD_SCH_PNDK_VW

(SQL View)
Index Back

Order Kit Sched w/ Pnd Fulfill

SQL View of kit order schedules in Inventory (IN_DEMAND) with a fulfillment state of 'Pending'. Date Init. Issue # Description 052504 twh F-KNANN-V59N4 Fulfillment Redesign

SELECT DISTINCT OS.BUSINESS_UNIT , OS.ORDER_NO , OS.ORDER_INT_LINE_NO , OS.SCHED_LINE_NBR , DM.INV_ITEM_ID , OS.ORD_SCH_STATUS , OS.DEMAND_SENT , OS.SHIP_FROM_BU , OS.DROP_SHIP_FLAG , MI.INVENTORY_ITEM FROM PS_IN_DEMAND DM , PS_ORD_SCHEDULE OS , PS_ORD_LINE OL , PS_PROD_ITEM PI , PS_PRODKIT_COMPS PK , PS_MASTER_ITEM_TBL MI , PS_SET_CNTRL_REC SC WHERE DM.BUSINESS_UNIT = OS.SHIP_FROM_BU AND DM.DEMAND_SOURCE = 'OM' AND DM.SOURCE_BUS_UNIT = OS.BUSINESS_UNIT AND DM.ORDER_NO = OS.ORDER_NO AND DM.ORDER_INT_LINE_NO = OS.ORDER_INT_LINE_NO AND DM.SCHED_LINE_NBR = OS.SCHED_LINE_NBR AND DM.INV_ITEM_ID = PK.PROD_COMPONENT_ID AND %Join(COMMON_KEYS, ORD_SCHEDULE OS, ORD_LINE OL) AND SC.SETCNTRLVALUE = OL.BUSINESS_UNIT AND SC.RECNAME = 'PROD_ITEM' AND PI.SETID = SC.SETID AND PI.PRODUCT_ID = OL.PRODUCT_ID AND PI.SETID = PK.SETID AND PI.PRODUCT_ID = PK.PRODUCT_ID AND PK.SETID = MI.SETID AND PK.PROD_COMPONENT_ID = MI.INV_ITEM_ID AND DM.IN_FULFILL_STATE = '10'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: BUS_UNIT_TBL_OM

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

Default Value: 1

4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
5 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
6 ORD_SCH_STATUS Character(1) VARCHAR2(1) NOT NULL Schedule Status
C=Closed
O=Open
P=Pending
X=Canceled

Default Value: O

7 DEMAND_SENT Character(1) VARCHAR2(1) NOT NULL Demand Sent to INV

Y/N Table Edit

Default Value: N

8 SHIP_FROM_BU Character(5) VARCHAR2(5) NOT NULL Ship from INV BU
9 DROP_SHIP_FLAG Character(1) VARCHAR2(1) NOT NULL Drop Ship
N=No
Y=Yes

Y/N Table Edit

Default Value: N

10 INVENTORY_ITEM Character(1) VARCHAR2(1) NOT NULL Inventory Item
N=No
Y=Yes