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.WMS_ZONES_PVT dependencies on MTL_ITEM_LOCATIONS_KFV

Line 224: mtl_item_locations_kfv milk,

220: g_subinventory_types(1)
221: )
222: , p_org_id
223: FROM wms_zone_locators wzl,
224: mtl_item_locations_kfv milk,
225: mtl_secondary_inventories msi,
226: mtl_material_statuses mms1,
227: mtl_material_statuses mms2
228: WHERE wzl.zone_id = p_zone_id

Line 365: l_fm_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

361: l_jtf_message wms_zone_locators_temp.MESSAGE%TYPE;
362: l_jtf_message_id VARCHAR2(4) := 'NULL';
363:
364: -- bug 3659062
365: l_fm_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
366: l_to_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
367:
368: BEGIN
369:

Line 366: l_to_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;

362: l_jtf_message_id VARCHAR2(4) := 'NULL';
363:
364: -- bug 3659062
365: l_fm_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
366: l_to_loc_name mtl_item_locations_kfv.concatenated_segments%TYPE;
367:
368: BEGIN
369:
370: DEBUG('In procedure :', l_module_name,0);

Line 452: FROM mtl_item_locations_kfv

448:
449: IF(p_fm_loc_id IS NOT NULL AND p_fm_loc_id <> -999) THEN
450: SELECT concatenated_segments
451: INTO l_fm_loc_name
452: FROM mtl_item_locations_kfv
453: WHERE inventory_location_id = p_fm_loc_id
454: AND organization_id = p_organization_id;
455: END IF;
456:

Line 460: FROM mtl_item_locations_kfv

456:
457: IF(p_to_loc_id IS NOT NULL AND p_to_loc_id <> -999) THEN
458: SELECT concatenated_segments
459: INTO l_to_loc_name
460: FROM mtl_item_locations_kfv
461: WHERE inventory_location_id = p_to_loc_id
462: AND organization_id = p_organization_id;
463: END IF;
464:

Line 784: ' from mtl_item_locations_kfv milk, mtl_secondary_inventories msi,

780: || ''') , '||p_organization_id;
781: DEBUG ('40 l_select_str is ' || l_select_str, ' add_locators_grid',
782: 9);
783: l_from_str :=
784: ' from mtl_item_locations_kfv milk, mtl_secondary_inventories msi,
785: mtl_material_statuses mms1,mtl_material_statuses mms2 ';
786: DEBUG ('10 l_from_str is ' || l_from_str, ' add_locators_grid', 9);
787: l_where_str := ' where 1=1 ';
788: DEBUG ('10 l_where_str is ' || l_where_str, ' add_locators_grid', 9);