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

Line 199: FROM MTL_ITEM_LOCATIONS_KFV

195: -- Added by rbhavsar on Nov 27, 2007 for ER 5854712
196: CURSOR get_inv_loc_id(C_ORGANIZATION_ID NUMBER, C_SUBINVENTORY VARCHAR2, C_LOCATOR_SEGMENTS VARCHAR2)
197: IS
198: SELECT INVENTORY_LOCATION_ID
199: FROM MTL_ITEM_LOCATIONS_KFV
200: WHERE ORGANIZATION_ID = C_ORGANIZATION_ID
201: AND SUBINVENTORY_CODE = C_SUBINVENTORY
202: AND CONCATENATED_SEGMENTS = C_LOCATOR_SEGMENTS;
203: -- End Changes by rbhavsar on Nov 27, 2007 for ER 5854712

Line 426: FROM MTL_ITEM_LOCATIONS

422: AND secondary_inventory_name = C_SUBINVENTORY;
423:
424: CURSOR validate_inv_loc_id(C_ORGANIZATION_ID NUMBER, C_SUBINVENTORY VARCHAR2, C_INVENTORY_LOCATION_ID NUMBER) IS
425: SELECT 1
426: FROM MTL_ITEM_LOCATIONS
427: WHERE ORGANIZATION_ID = C_ORGANIZATION_ID
428: AND SUBINVENTORY_CODE = C_SUBINVENTORY
429: AND INVENTORY_LOCATION_ID = C_INVENTORY_LOCATION_ID
430: AND SEGMENT19 IS NULL