05/07/04 MEG CN#IN890: Replaced demand_inv with in_demand and cancel_flag with in_fulfill_state.

DEMAND_CNFMT_VW

(SQL View)
 Index Back

SELECT DISTINCT BUSINESS_UNIT , TMS_EXT_REF_ID FROM PS_IN_DEMAND WHERE PICK_BATCH_ID > 0 AND IN_FULFILL_STATE = '40' AND CONFIRMED_FLAG = 'Y' AND TMS_EXT_REF_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 TMS_EXT_REF_ID Character(10) VARCHAR2(10) NOT NULL TMS Reference ID