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 FA_CATEGORIES_B_KFV

Line 156: SELECT category_id INTO l_id FROM fa_categories_b_kfv

152: SELECT hazard_class_id INTO l_id from po_hazard_classes_vl
153: WHERE hazard_class = l_pk1;
154: WHEN G_ASSET_CATEGORY THEN
155: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
156: SELECT category_id INTO l_id FROM fa_categories_b_kfv
157: WHERE concatenated_segments = l_pk1;
158: WHEN G_MANUFACTURER THEN
159: l_pk1 := ID_COL_VALUE('manufacturer_name',p_pk_col_name_val_pairs);
160: SELECT manufacturer_id INTO l_id FROM mtl_manufacturers

Line 237: FROM fa_categories_b_kfv

233: WHERE hazard_class_id = l_pk1;
234: WHEN G_ASSET_CATEGORY THEN
235: l_pk1 := ID_COL_VALUE('category_id',p_pk_col_name_val_pairs);
236: SELECT concatenated_segments INTO l_code
237: FROM fa_categories_b_kfv
238: WHERE category_id = l_pk1 ;
239: WHEN G_MANUFACTURER THEN
240: l_pk1 := ID_COL_VALUE('manufacturer_id',p_pk_col_name_val_pairs);
241: SELECT manufacturer_name INTO l_code