DBA Data[Home] [Help]

APPS.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_ORG_CARRIER_SERVICES

Line 297: from wsh_carrier_services wcs, wsh_org_carrier_services wocs,

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