DBA Data[Home] [Help]

APPS.EAM_WORKORDERS_JSP dependencies on MTL_SECONDARY_LOCATORS

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

709: from mtl_item_locations_kfv where
710: concatenated_segments = p_locator
711: and subinventory_code = p_subinventory
712: and organization_id = p_org_id
713: and EXISTS (select '1' from mtl_secondary_locators
714: where inventory_item_id = p_item_id
715: and organization_id = p_org_id
716: and secondary_locator = inventory_location_id) ;*/
717:

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

719: from mtl_item_locations_kfv milk where
720: inv_project.Get_locator(milk.inventory_location_id, milk.organization_id) = p_locator
721: and milk.subinventory_code = p_subinventory
722: and milk.organization_id = p_org_id
723: and EXISTS (select '1' from mtl_secondary_locators
724: where inventory_item_id = p_item_id
725: and organization_id = p_org_id
726: and secondary_locator = inventory_location_id);
727: