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.AMS_ACTPRODUCT_PVT dependencies on MTL_CATEGORIES_V

Line 2226: FROM mtl_categories_v

2222: IS
2223:
2224: CURSOR get_cat_name IS
2225: SELECT CATEGORY_CONCAT_SEGS
2226: FROM mtl_categories_v
2227: WHERE category_id = p_category_id;
2228:
2229: CURSOR get_cat_name2 IS
2230: SELECT

Line 2235: mtl_categories_v c ,

2231: NVL(d.category_desc, category_concat_segs) categoryName
2232: FROM
2233: mtl_default_category_sets a ,
2234: mtl_category_sets_b b ,
2235: mtl_categories_v c ,
2236: ENI_PROD_DEN_HRCHY_PARENTS_V d
2237: WHERE
2238: a.functional_area_id in (7,11)
2239: AND a.category_set_id = b.category_set_id

Line 2246: FROM mtl_categories_v c

2242: AND c.category_id = p_category_id;
2243:
2244: CURSOR get_cat_name3 IS
2245: SELECT c.category_concat_segs
2246: FROM mtl_categories_v c
2247: WHERE c.category_id = p_category_id;
2248:
2249: --inanaiah Bug 4956134 fix - sql id 14423554, 14423628
2250: --inanaiah - Bug 5025294 fix - removed XXXIFC_region_items reference

Line 2329: mtl_categories_v c ,

2325: NVL(d.concat_cat_parentage, c.description) categoryDescr
2326: FROM
2327: mtl_default_category_sets a ,
2328: mtl_category_sets_b b ,
2329: mtl_categories_v c ,
2330: ENI_PROD_DEN_HRCHY_PARENTS_V d
2331: WHERE
2332: a.functional_area_id in (7,11)
2333: AND a.category_set_id = b.category_set_id

Line 2340: FROM mtl_categories_v c

2336: AND c.category_id = p_category_id;
2337:
2338: CURSOR get_cat_Desc3 IS
2339: SELECT c.description
2340: FROM mtl_categories_v c
2341: WHERE c.category_id = p_category_id;
2342:
2343: --inanaiah Bug 4956134 fix - sql id 14423554, 14423628
2344: --inanaiah - Bug 5025294 fix - removed XXXIFC_region_items reference