IN_SHP_DELIV_VW

(SQL View)
 Index Back

SELECT D.BUSINESS_UNIT , D.DELIVERY_ID FROM PS_IN_DELIVERY D WHERE EXISTS ( SELECT 'X' FROM PS_DF_SETUP_INV WHERE BUSINESS_UNIT = D.BUSINESS_UNIT AND DELIVERY_OPT <> '3') AND EXISTS ( SELECT 'X' FROM PS_IN_DEMAND WHERE BUSINESS_UNIT = D.BUSINESS_UNIT AND DELIVERY_ID = D.DELIVERY_ID AND SHIP_ID = ' ')

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