OMCLS_PRDK_P_VW (SQL View)	Index Back
OM Order Close Kits Ship/Order This view is used during the Order Close background process to determine whick kits are shipped complete by looking at the required components list and checking the backorder cancel flags. Date Initials Issue Description 062504 twh F-KNANN-V59N4 Replace demand table references with IN_DEMAND

OMCLS_PRDK_P_VW

(SQL View)

OM Order Close Kits Ship/Order

This view is used during the Order Close background process to determine whick kits are shipped complete by looking at the required components list and checking the backorder cancel flags. Date Initials Issue Description 062504 twh F-KNANN-V59N4 Replace demand table references with IN_DEMAND

SELECT SH.SOURCE_BUS_UNIT , SH.ORDER_NO , SH.ORDER_INT_LINE_NO , SH.SCHED_LINE_NBR , SH.PARENT_PROD_ID , SH.PRODUCT_ID , PK.DATE_IN_EFFECT , SUM(QTY_SHIPPED) , SH.IN_FULFILL_STATE , SH.QTY_BACKORDER FROM PS_IN_DEMAND SH , PS_SET_CNTRL_REC S , PS_PRODKIT_COMPS PK , PS_ORD_LINE OL WHERE S.SETCNTRLVALUE = OL.BUSINESS_UNIT AND S.RECNAME = 'PRODKIT_COMPS' AND S.SETID = PK.SETID AND PK.PRODUCT_ID = OL.PRODUCT_ID AND SH.SOURCE_BUS_UNIT = OL.BUSINESS_UNIT AND SH.ORDER_NO = OL.ORDER_NO AND SH.ORDER_INT_LINE_NO = OL.ORDER_INT_LINE_NO AND SH.DEMAND_SOURCE = 'OM' AND SH.PARENT_PROD_ID = PK.PRODUCT_ID AND SH.PRODUCT_ID = PK.PROD_COMPONENT_ID AND PK.QTY_CODE = 'ORD' GROUP BY SH.SOURCE_BUS_UNIT, SH.ORDER_NO, SH.ORDER_INT_LINE_NO, SH.SCHED_LINE_NBR, SH.PARENT_PROD_ID, SH.PRODUCT_ID, PK.DATE_IN_EFFECT, SH.IN_FULFILL_STATE, SH.QTY_BACKORDER

# 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 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

7 DATE_IN_EFFECT Date(10) DATE 01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label

8 QTY_SHIPPED Signed Number(17,4) DECIMAL(15,4) NOT NULL Qty Shipped

9 IN_FULFILL_STATE Character(2) VARCHAR2(2) NOT NULL Inventory Fulfillment State
10=Pending
20=Unfulfilled
30=Releasable
40=Released
50=Confirmed
60=Shipped
70=Depleted
90=Canceled

10 QTY_BACKORDER Signed Number(17,4) DECIMAL(15,4) NOT NULL Backorder Qty

#	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	PRODUCT_ID	Character(18)	VARCHAR2(18) NOT NULL	Product ID
7	DATE_IN_EFFECT	Date(10)	DATE	01/27/2000 RML Added "As of date" label 03/23/2004 SFC Added PRICE_LIST_DATE label 06/04/2004 SFC Added PRODUCT_PRICE_DAT label
8	QTY_SHIPPED	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Qty Shipped
9	IN_FULFILL_STATE	Character(2)	VARCHAR2(2) NOT NULL	Inventory Fulfillment State 10=Pending 20=Unfulfilled 30=Releasable 40=Released 50=Confirmed 60=Shipped 70=Depleted 90=Canceled
10	QTY_BACKORDER	Signed Number(17,4)	DECIMAL(15,4) NOT NULL	Backorder Qty