IN_DLV_FBOL_VW

(SQL View)
Index Back

Delivery ID view

7/31/07 mmt Creating view to use as prompt table view in fulfillment pages

SELECT A.BUSINESS_UNIT , A.BUSINESS_UNIT , A.DELIVERY_ID FROM PS_IN_DEMAND A WHERE IN_FULFILL_STATE IN ('60', '70') AND DELIVERY_ID <> ' ' AND EXISTS ( SELECT 'x' FROM ps_df_setup_inv WHERE business_unit = a.business_unit AND delivery_opt <> '3')

# 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 DELIVERY_ID Character(10) VARCHAR2(10) NOT NULL Delivery ID