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_CATEGORY_SETS_VL

Line 164: SELECT category_set_id INTO l_id FROM mtl_category_sets_vl

160: SELECT manufacturer_id INTO l_id FROM mtl_manufacturers
161: WHERE manufacturer_name = l_pk1;
162: WHEN G_CATEGORY_SET THEN
163: l_pk1 := ID_COL_VALUE('category_set_name',p_pk_col_name_val_pairs);
164: SELECT category_set_id INTO l_id FROM mtl_category_sets_vl
165: WHERE category_set_name = l_pk1;
166: WHEN G_CATEGORY THEN
167: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
168: l_pk2 := ID_COL_VALUE('category_set_name',p_pk_col_name_val_pairs);

Line 169: SELECT category_id INTO l_id FROM mtl_categories_kfv mck,mtl_category_sets_vl mcs

165: WHERE category_set_name = l_pk1;
166: WHEN G_CATEGORY THEN
167: l_pk1 := ID_COL_VALUE('concatenated_segments',p_pk_col_name_val_pairs);
168: l_pk2 := ID_COL_VALUE('category_set_name',p_pk_col_name_val_pairs);
169: SELECT category_id INTO l_id FROM mtl_categories_kfv mck,mtl_category_sets_vl mcs
170: where mcs.category_set_name = l_pk2
171: and mcs.structure_id = mck.structure_id
172: and mck.concatenated_segments = l_pk1;
173: END CASE;

Line 247: FROM mtl_category_sets_vl

243: WHERE manufacturer_id = l_pk1;
244: WHEN G_CATEGORY_SET THEN
245: l_pk1 := ID_COL_VALUE('cat_set_id',p_pk_col_name_val_pairs);
246: SELECT category_set_name INTO l_code
247: FROM mtl_category_sets_vl
248: WHERE CATEGORY_SET_ID = l_pk1;
249: WHEN G_CATEGORY THEN
250: l_pk1 := ID_COL_VALUE('cat_id',p_pk_col_name_val_pairs);
251: SELECT concatenated_segments INTO l_code