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.QP_CATEGORY_MAPPING_RULE dependencies on MTL_CATEGORIES_B

Line 27: mtl_categories_b b,

23: -- Changed cursor for 3125141
24: CURSOR l_category_cursor (org_id_in number,appl_id_in number) is
25: SELECT a.category_id
26: FROM mtl_item_categories a,
27: mtl_categories_b b,
28: mtl_default_category_sets c,
29: mtl_category_sets_b d
30: WHERE a.inventory_item_id = p_inventory_item_id
31: AND a.organization_id = org_id_in

Line 65: mtl_categories_b b,

61: */
62: CURSOR l_category_cursor (org_id_in number,req_type_code_in VARCHAR2) is
63: SELECT distinct /*+ ordered use_nl(b c d) */ a.category_id
64: FROM mtl_item_categories a,
65: mtl_categories_b b,
66: mtl_default_category_sets c,
67: mtl_category_sets_b d
68: WHERE a.inventory_item_id = p_inventory_item_id
69: AND a.organization_id = org_id_in