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_DEPLOY dependencies on MTL_SYSTEM_ITEMS_B_KFV

Line 233: l_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;

229: RETURN VARCHAR2
230: as
231: l_delimiter VARCHAR2(1);
232: l_client_code mtl_client_parameters.client_code%TYPE := NULL;
233: l_item_name mtl_system_items_b_kfv.concatenated_segments%TYPE;
234: begin
235: IF wms_deployment_mode = 'L' THEN
236: IF g_item_id = p_item_id THEN
237: -- returned the cached value

Line 244: from mtl_system_items_b_kfv

240:
241: Begin
242: select concatenated_segments
243: into l_item_name
244: from mtl_system_items_b_kfv
245: where inventory_item_id=p_item_id
246: and rownum < 2;
247: Exception
248: when others then

Line 347: FROM mtl_system_items_b_kfv

343: BEGIN
344: BEGIN
345: SELECT concatenated_segments
346: INTO l_item_name
347: FROM mtl_system_items_b_kfv
348: WHERE inventory_item_id = p_item_id
349: AND organization_id = p_org_id;
350: EXCEPTION
351: WHEN OTHERS THEN