SHIP_CNTR_VW2

(SQL View)
 Index Back

Outer Most Cntr Not on ShipID


SELECT DISTINCT D.BUSINESS_UNIT , D.OUTER_MOST_CNTR_ID FROM PS_SHIP_CNTR_INV B , PS_SHIP_CNTR_HDR D , PS_IN_DEMAND A , PS_ISSUE_HDR_INV E WHERE A.IN_FULFILL_STATE >= '50' AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.DEMAND_SOURCE = A.DEMAND_SOURCE AND B.SOURCE_BUS_UNIT = A.SOURCE_BUS_UNIT AND B.ORDER_NO = A.ORDER_NO AND B.ORDER_INT_LINE_NO = A.ORDER_INT_LINE_NO AND B.SCHED_LINE_NBR = A.SCHED_LINE_NBR AND B.INV_ITEM_ID = A.INV_ITEM_ID AND B.DEMAND_LINE_NO = A.DEMAND_LINE_NO AND B.BUSINESS_UNIT = D.BUSINESS_UNIT AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.SHIP_ID = ' ' AND B.SHIP_CNTR_ID = D.SHIP_CNTR_ID AND A.BUSINESS_UNIT = E.BUSINESS_UNIT AND A.DEMAND_SOURCE = E.DEMAND_SOURCE AND A.SOURCE_BUS_UNIT = E.SOURCE_BUS_UNIT AND A.ORDER_NO = E.ORDER_NO AND E.FULFILL_FLAG = 'Y'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 SHIP_CNTR_ID Character(20) VARCHAR2(20) NOT NULL Shipping Container ID