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

Line 284: CURSOR get_locator (v_locator_id mtl_item_locations.inventory_location_id%TYPE) IS

280:
281:
282: -- JD Added cursor to get location for display.
283:
284: CURSOR get_locator (v_locator_id mtl_item_locations.inventory_location_id%TYPE) IS
285: SELECT segment1
286: FROM mtl_item_locations
287: WHERE inventory_location_id = v_locator_id;
288:

Line 286: FROM mtl_item_locations

282: -- JD Added cursor to get location for display.
283:
284: CURSOR get_locator (v_locator_id mtl_item_locations.inventory_location_id%TYPE) IS
285: SELECT segment1
286: FROM mtl_item_locations
287: WHERE inventory_location_id = v_locator_id;
288:
289: l_segment1 mtl_item_locations.segment1%TYPE;
290: l_store_segment1 mtl_item_locations.segment1%TYPE;

Line 289: l_segment1 mtl_item_locations.segment1%TYPE;

285: SELECT segment1
286: FROM mtl_item_locations
287: WHERE inventory_location_id = v_locator_id;
288:
289: l_segment1 mtl_item_locations.segment1%TYPE;
290: l_store_segment1 mtl_item_locations.segment1%TYPE;
291:
292:
293: NO_PARAMETERS_DEFINED EXCEPTION;

Line 290: l_store_segment1 mtl_item_locations.segment1%TYPE;

286: FROM mtl_item_locations
287: WHERE inventory_location_id = v_locator_id;
288:
289: l_segment1 mtl_item_locations.segment1%TYPE;
290: l_store_segment1 mtl_item_locations.segment1%TYPE;
291:
292:
293: NO_PARAMETERS_DEFINED EXCEPTION;
294: NO_SAMPLES_FOUND EXCEPTION;