DBA Data[Home] [Help]

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: elsif(p_locator_ctrl = 1) then

Line 701: from mtl_item_locations_kfv where

697: and subinventory_code = p_subinventory
698: and organization_id = p_org_id;
699: elsif(p_locator_ctrl = 1) then
700: select Inventory_Location_ID into l_locator_id
701: from mtl_item_locations_kfv where
702: concatenated_segments = p_locator
703: and subinventory_code = p_subinventory
704: and organization_id = p_org_id
705: and EXISTS (select '1' from mtl_secondary_locators