INV_EXTL_FUL_VW

(SQL View)
Index Back

Pick Plan Locations Prompt Vw

08/04/04 PWF Data Model Change: Change to IN_DEMAND

SELECT DISTINCT BUSINESS_UNIT , BUSINESS_UNIT , EXT_REF_NBR , EXT_REF_LN_NBR FROM PS_IN_DEMAND WHERE IN_FULFILL_STATE='50' AND EXT_REF_NBR <> 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 EXT_REF_NBR Number(10,0) DECIMAL(10) NOT NULL External Reference Number
4 EXT_REF_LN_NBR Number(5,0) INTEGER NOT NULL External Reference Line Number