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 31: mtl_categories_b b,

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

Line 72: mtl_categories_b b,

68: --Rewriting cursor query for better performance.
69: /*CURSOR l_category_cursor (org_id_in number,req_type_code_in VARCHAR2) is
70: SELECT distinct /*+ ordered use_nl(b c d) */ /*a.category_id
71: FROM mtl_item_categories a,
72: mtl_categories_b b,
73: mtl_default_category_sets c,
74: mtl_category_sets_b d
75: WHERE a.inventory_item_id = p_inventory_item_id
76: AND a.organization_id = org_id_in

Line 94: MTL_CATEGORIES_B B,

90:
91: CURSOR l_category_cursor (org_id_in number,req_type_code_in VARCHAR2) IS
92: SELECT /*+ leading(a,b,d,c) use_nl(b c d) */ DISTINCT A.CATEGORY_ID
93: FROM MTL_ITEM_CATEGORIES A,
94: MTL_CATEGORIES_B B,
95: MTL_DEFAULT_CATEGORY_SETS C,
96: MTL_CATEGORY_SETS_B D
97: WHERE A.INVENTORY_ITEM_ID = p_inventory_item_id
98: AND A.ORGANIZATION_ID = org_id_in