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.INV_EBI_ITEM_HELPER dependencies on MTL_ITEM_TEMPLATES

Line 97: SELECT template_id INTO l_id FROM mtl_item_templates

93: THEN
94: CASE p_entity_name
95: WHEN G_TEMPLATE THEN
96: l_pk1 := ID_COL_VALUE('template_name',p_pk_col_name_val_pairs);
97: SELECT template_id INTO l_id FROM mtl_item_templates
98: WHERE template_name =l_pk1;
99: WHEN G_INVENTORY_ITEM THEN
100: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
101: l_pk2 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);

Line 180: FROM mtl_item_templates

176: CASE p_entity_name
177: WHEN G_TEMPLATE THEN
178: l_pk1 := ID_COL_VALUE('template_id',p_pk_col_name_val_pairs);
179: SELECT template_name INTO l_code
180: FROM mtl_item_templates
181: WHERE template_id = l_pk1;
182: WHEN G_ORGANIZATION THEN
183: l_pk1 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);
184: SELECT organization_code INTO l_code