IN_FW_SCTR_1_VW

(SQL View)
 Index Back

Ship Cntr Hdr/Inv/SII Join

Used in shipping/issues for selection of highest level ship containers that match the search criteria entered by the user.

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 WHERE 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 B.SHIP_CNTR_ID = D.SHIP_CNTR_ID AND A.IN_FULFILL_STATE = '50'

# 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