INV_PICKSHPL_VW

(SQL View)
Index Back

Pick Plan Locations Prompt Vw


SELECT DISTINCT BUSINESS_UNIT , BUSINESS_UNIT , PICK_BATCH_ID , PICKLIST_LINE_NO FROM PS_IN_DEMAND WHERE IN_FULFILL_STATE = '50' AND PICK_BATCH_ID <> 0

# 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 TO_BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit selection field
3 SL_PICK_BATCH_ID Number(10,0) DECIMAL(10) NOT NULL Pick Batch ID selection
4 SL_PICKLIST_LINE Number(7,0) INTEGER NOT NULL Pick List Line Number selection