IN_WO_DMDRLS_VW (SQL View)	Index Back
Release Instance View 08/11/04 rcw: Created

IN_WO_DMDRLS_VW

(SQL View)

Release Instance View

08/11/04 rcw: Created

SELECT DISTINCT BUSINESS_UNIT , RELEASE_INSTANCE , PICK_BATCH_ID FROM PS_IN_DEMAND WHERE RELEASE_INSTANCE > 0 AND DEMAND_SOURCE = 'WM' AND IN_FULFILL_STATE = '10'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SL_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit selection field

2 RELEASE_INSTANCE Number(10,0) DECIMAL(10) NOT NULL 08/2004 rcw: Order Release Instance

3 PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SL_BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit selection field
2	RELEASE_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	08/2004 rcw: Order Release Instance
3	PICK_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Batch ID