APPS.EAM_WORKORDERS_JSP dependencies on MTL_ITEM_LOCATIONS_KFV

Line 695: from mtl_item_locations_kfv where

691: Begin
692:
693: if(p_locator_ctrl is null or p_locator_ctrl <> 1) then
694: /*select Inventory_Location_ID into l_locator_id
695: from mtl_item_locations_kfv where
696: concatenated_segments = p_locator
697: and subinventory_code = p_subinventory
698: and organization_id = p_org_id;*/
699:

Line 701: from mtl_item_locations_kfv milk where

697: and subinventory_code = p_subinventory
698: and organization_id = p_org_id;*/
699:
700: select milk.Inventory_Location_ID into l_locator_id
701: from mtl_item_locations_kfv milk where
702: inv_project.Get_locator(milk.inventory_location_id, milk.organization_id) = p_locator
703: and milk.subinventory_code = p_subinventory
704: and milk.organization_id = p_org_id;
705:

Line 709: from mtl_item_locations_kfv where

705:
706: elsif(p_locator_ctrl = 1) then
707:
708: /*select Inventory_Location_ID into l_locator_id
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

Line 719: from mtl_item_locations_kfv milk where

715: and organization_id = p_org_id
716: and secondary_locator = inventory_location_id) ;*/
717:
718: select milk.Inventory_Location_ID into l_locator_id
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