DBA Data[Home] [Help]

APPS.EAM_MTL_TXN_PROCESS dependencies on MTL_SECONDARY_LOCATORS

Line 319: and EXISTS (select '1' from mtl_secondary_locators

315: from mtl_item_locations_kfv where
316: concatenated_segments = p_locator
317: and subinventory_code = p_subinv_code
318: and organization_id = p_org_id
319: and EXISTS (select '1' from mtl_secondary_locators
320: where inventory_item_id = p_item_id
321: and organization_id = p_org_id
322: and secondary_locator = inventory_location_id) ;*/
323:

Line 329: and EXISTS (select '1' from mtl_secondary_locators

325: from mtl_item_locations_kfv milk where
326: inv_project.Get_locator(milk.inventory_location_id, milk.organization_id) = p_locator
327: and milk.subinventory_code = p_subinv_code
328: and milk.organization_id = p_org_id
329: and EXISTS (select '1' from mtl_secondary_locators
330: where inventory_item_id = p_item_id
331: and organization_id = p_org_id
332: and secondary_locator = inventory_location_id) ;
333: