AND F.PARTNER_NUM = A.PARTNER_NUM AND F.FACTORY_NUM = A.FACTORY_NUM AND F.STATUS = 'A' AND FP.FCTRY_NUM = F.FACTORY_NUM AND FP.SHIP_MODE_CD = A.SHIP_MODE_CD AND S.SHIP_PORT_NUM = FP.SHIP_PORT_NUM AND PP.SHIP_PORT_NUM = S.SHIP_PORT_NUM AND PP.FRGHT_FWD_P_NUM = :W3-FF-TYPE AND PP.PRTNR_TYP_ID = A.PRTNR_BILLTO_TYPE AND PP.PRTNR_NUM = A.PRTNR_BILLTO_NUM