DBA Data[Home] [Help]

APPS.EAM_MTL_TXN_PROCESS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 220: from mtl_item_locations_kfv where

216: Begin
217:
218: if(p_locator_ctrl <> 1) then
219: select Inventory_Location_ID into p_locator_id
220: from mtl_item_locations_kfv where
221: concatenated_segments = p_locator
222: and subinventory_code = p_subinv_code
223: and organization_id = p_org_id;
224:

Line 227: from mtl_item_locations_kfv where

223: and organization_id = p_org_id;
224:
225: elsif(p_locator_ctrl = 1) then
226: select Inventory_Location_ID into p_locator_id
227: from mtl_item_locations_kfv where
228: concatenated_segments = p_locator
229: and subinventory_code = p_subinv_code
230: and organization_id = p_org_id
231: and EXISTS (select '1' from mtl_secondary_locators

Line 1241: from mtl_item_locations_kfv

1237: if (p_locator is not null) then
1238:
1239: select inventory_location_id
1240: into l_locator
1241: from mtl_item_locations_kfv
1242: where organization_id = p_organization_id
1243: and concatenated_segments = p_locator
1244: and subinventory_code = p_supply_subinventory ;
1245: