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 137: SELECT category_id INTO l_id FROM fa_categories_b_kfv

133: SELECT hazard_class_id INTO l_id from po_hazard_classes_vl
134: WHERE hazard_class = l_pk1;
135: WHEN G_ASSET_CATEGORY THEN
136: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
137: SELECT category_id INTO l_id FROM fa_categories_b_kfv
138: WHERE concatenated_segments = l_pk1;
139: WHEN G_MANUFACTURER THEN
140: l_pk1 := ID_COL_VALUE('manufacturer_name',p_pk_col_name_val_pairs);
141: SELECT manufacturer_id INTO l_id FROM mtl_manufacturers

Line 215: FROM fa_categories_b_kfv

211: WHERE hazard_class_id = l_pk1;
212: WHEN G_ASSET_CATEGORY THEN
213: l_pk1 := ID_COL_VALUE('category_id',p_pk_col_name_val_pairs);
214: SELECT concatenated_segments INTO l_code
215: FROM fa_categories_b_kfv
216: WHERE category_id = l_pk1 ;
217: WHEN G_MANUFACTURER THEN
218: l_pk1 := ID_COL_VALUE('manufacturer_id',p_pk_col_name_val_pairs);
219: SELECT manufacturer_name INTO l_code