APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_CARRIER_SERVICES
Line 296: from wsh_carrier_services wcs, wsh_org_carrier_services wocs,
292: AND nvl(end_date_active,sysdate)>=sysdate
293: AND enabled_flag = 'Y'
294: AND meaning like ( p_ship_method_name)
295: AND lookup_code in (select ship_method_code 296: from wsh_carrier_services wcs, wsh_org_carrier_services wocs, 297: wsh_carriers wc
298: where wocs.organization_id = p_organization_id
299: AND wcs.ship_method_code = flv.lookup_code
300: AND wcs.enabled_flag = 'Y'