DBA Data[Home] [Help]

APPS.CSP_PART_SEARCH_PVT dependencies on MTL_INTERORG_PARAMETERS

Line 318: where not exists (select 'x' from mtl_interorg_parameters mip

314: if l_search_method = 'SPARES' and
315: l_called_from_charges <> 'Y' then
316: log('update_shipping_info','search method SPARES deleting 1');
317: delete from csp_available_parts_temp capt
318: where not exists (select 'x' from mtl_interorg_parameters mip
319: where mip.from_organization_id = capt.organization_id
320: and mip.to_organization_id = l_organization_id)
321: and capt.organization_id <> l_organization_id
322: and source_type_code not in ('DEDICATED','MYSELF');