DBA Data[Home] [Help]

APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_ORG_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'