BCT_PCK_BTCH_VW (SQL View)	Index Back
PROMPT TABLE FOR PICK BATCH SELECT DISTINCT BUSINESS_UNIT, PICK_BATCH_ID FROM PS_DEMAND_INV

BCT_PCK_BTCH_VW

(SQL View)

PROMPT TABLE FOR PICK BATCH

SELECT DISTINCT BUSINESS_UNIT, PICK_BATCH_ID FROM PS_DEMAND_INV

SELECT DISTINCT BUSINESS_UNIT , PICK_BATCH_ID FROM PS_IN_DEMAND WHERE IN_FULFILL_STATE BETWEEN '30' AND '40' AND PICK_BATCH_ID <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PICK_BATCH_ID	Number(10,0)	DECIMAL(10) NOT NULL	Pick Batch ID