|
SELECT DISTINCT A.BUSINESS_UNIT , A.SHIP_ID FROM PS_IN_DEMAND A WHERE (IN_FULFILL_STATE BETWEEN '60' AND '70' AND DEMAND_SOURCE = 'OM') OR SHIP_ID IN ( SELECT SHIP_ID FROM PS_IN_DEMAND A2 , PS_DMD_IU_DEF_INV B , PS_INSTALLATION_IN IIN WHERE A2.BUSINESS_UNIT = B.BUSINESS_UNIT AND A2.DESTIN_BU = B.DESTIN_BU AND B.INTERCOMPANY_FLG = 'Y' AND A2.INTERUNIT_FLG = 'Y' AND A2.IN_FULFILL_STATE BETWEEN '60' AND '70' AND A2.BUSINESS_UNIT = A.BUSINESS_UNIT AND IIN.IUNIT_VALUES IN ('2','3')) OR SHIP_ID IN ( SELECT SHIP_ID FROM PS_IN_DEMAND A3 , PS_INIU_TRANOPT_VW B , PS_INSTALLATION_IN IIN , PS_INSTALLATION_FS IFS WHERE A3.BUSINESS_UNIT = B.SOURCE_BUS_UNIT AND A3.DESTIN_BU = B.DESTIN_BU AND B.INTERCOMPANY_FLG = 'Y' AND A3.INTERUNIT_FLG = 'Y' AND A3.IN_FULFILL_STATE BETWEEN '60' AND '70' AND A3.BUSINESS_UNIT = A.BUSINESS_UNIT AND IIN.IUNIT_VALUES IN ('1','3') AND IFS.IU_METHOD IN ('D','I')) OR SHIP_ID IN ( SELECT SHIP_ID FROM PS_IN_DEMAND A4 , PS_INIU_TRANPR_VW B , PS_INSTALLATION_IN IIN , PS_INSTALLATION_FS IFS WHERE A4.BUSINESS_UNIT = B.SOURCE_BUS_UNIT AND A4.DESTIN_BU = B.DESTIN_BU AND B.INTERCOMPANY_FLG = 'Y' AND A4.INTERUNIT_FLG = 'Y' AND A4.IN_FULFILL_STATE BETWEEN '60' AND '70' AND A4.BUSINESS_UNIT = A.BUSINESS_UNIT AND IIN.IUNIT_VALUES IN ('1','3') AND IFS.IU_METHOD = 'P')
|
BUSINESS_UNIT