eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EAM_MTL_TXN_PROCESS dependencies on MTL_ITEM_LOCATIONS_KFV

Line 302: from mtl_item_locations_kfv where

298: Begin
299:
300: if(p_locator_ctrl <> 1) then
301: /*select Inventory_Location_ID into p_locator_id
302: from mtl_item_locations_kfv where
303: concatenated_segments = p_locator
304: and subinventory_code = p_subinv_code
305: and organization_id = p_org_id;*/
306:

Line 308: from mtl_item_locations_kfv milk where

304: and subinventory_code = p_subinv_code
305: and organization_id = p_org_id;*/
306:
307: select milk.Inventory_Location_ID into p_locator_id
308: from mtl_item_locations_kfv milk where
309: inv_project.Get_locator(milk.inventory_location_id, milk.organization_id) = p_locator
310: and milk.subinventory_code = p_subinv_code
311: and milk.organization_id = p_org_id;
312:

Line 315: from mtl_item_locations_kfv where

311: and milk.organization_id = p_org_id;
312:
313: elsif(p_locator_ctrl = 1) then
314: /*select Inventory_Location_ID into p_locator_id
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

Line 325: from mtl_item_locations_kfv milk where

321: and organization_id = p_org_id
322: and secondary_locator = inventory_location_id) ;*/
323:
324: select milk.Inventory_Location_ID into p_locator_id
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

Line 1600: from mtl_item_locations_kfv milk

1596: if (p_locator is not null) then
1597:
1598: /*select milk.inventory_location_id
1599: into l_locator
1600: from mtl_item_locations_kfv milk
1601: where milk.organization_id = p_organization_id
1602: and concatenated_segments = p_locator
1603: and subinventory_code = p_supply_subinventory ;*/
1604:

Line 1607: from mtl_item_locations_kfv milk

1603: and subinventory_code = p_supply_subinventory ;*/
1604:
1605: select milk.inventory_location_id
1606: into l_locator
1607: from mtl_item_locations_kfv milk
1608: where milk.organization_id = p_organization_id
1609: and inv_project.Get_locator(milk.inventory_location_id, milk.organization_id) = p_locator
1610: and milk.subinventory_code = p_supply_subinventory ;
1611: