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.GME_POST_MIGRATION dependencies on MTL_ITEM_LOCATIONS

Line 2046: FROM ic_loct_mst i, mtl_item_locations m

2042: x_locator_id OUT NOCOPY NUMBER,
2043: x_subinventory OUT NOCOPY VARCHAR2) IS
2044: CURSOR Cur_ic_loct_mst IS
2045: SELECT i.locator_id, m.organization_id, m.subinventory_code
2046: FROM ic_loct_mst i, mtl_item_locations m
2047: WHERE i.location = p_location
2048: AND i.whse_code = p_whse_code
2049: AND m.inventory_location_id = i.locator_id;
2050: CURSOR Cur_mtl_locs IS

Line 2052: FROM mtl_item_locations m

2048: AND i.whse_code = p_whse_code
2049: AND m.inventory_location_id = i.locator_id;
2050: CURSOR Cur_mtl_locs IS
2051: SELECT m.inventory_location_id locator_id, m.organization_id, m.subinventory_code
2052: FROM mtl_item_locations m
2053: WHERE m.segment1 = p_location
2054: AND m.subinventory_code = x_subinventory;
2055: l_api_name VARCHAR2(30) := 'get_locator';
2056: BEGIN

Line 3299: FROM mtl_item_locations m

3295: WHERE i.organization_id = v_organization_id
3296: AND i.inventory_item_id = v_inventory_item_id;
3297: CURSOR Cur_new_loc(v_organization_id NUMBER, v_subinventory VARCHAR2, v_location VARCHAR2) IS
3298: SELECT m.inventory_location_id locator_id
3299: FROM mtl_item_locations m
3300: WHERE m.segment1 = v_location
3301: AND m.organization_id = v_organization_id
3302: AND m.subinventory_code = v_subinventory;
3303: CURSOR Cur_get_org_params(v_org_id NUMBER) IS