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 116: SELECT template_id INTO l_id FROM mtl_item_templates

112: THEN
113: CASE p_entity_name
114: WHEN G_TEMPLATE THEN
115: l_pk1 := ID_COL_VALUE('template_name',p_pk_col_name_val_pairs);
116: SELECT template_id INTO l_id FROM mtl_item_templates
117: WHERE template_name =l_pk1;
118: WHEN G_INVENTORY_ITEM THEN
119: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
120: l_pk2 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);

Line 202: FROM mtl_item_templates_vl

198: CASE p_entity_name
199: WHEN G_TEMPLATE THEN
200: l_pk1 := ID_COL_VALUE('template_id',p_pk_col_name_val_pairs);
201: SELECT template_name INTO l_code
202: FROM mtl_item_templates_vl
203: WHERE template_id = l_pk1;
204: WHEN G_ORGANIZATION THEN
205: l_pk1 := ID_COL_VALUE('organization_id',p_pk_col_name_val_pairs);
206: SELECT organization_code INTO l_code