APPS.QP_CATEGORY_MAPPING_RULE dependencies on MTL_CATEGORY_SETS_B

Line 33: mtl_category_sets_b d

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
36: AND a.category_id = b.category_id
37: AND c.category_set_id = d.category_set_id

Line 74: mtl_category_sets_b d

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
77: AND a.category_id = b.category_id
78: AND c.category_set_id = d.category_set_id

Line 96: MTL_CATEGORY_SETS_B D

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
99: AND A.CATEGORY_ID = B.CATEGORY_ID
100: AND A.CATEGORY_SET_ID = D.CATEGORY_SET_ID --Bug#11719249

Line 119: mtl_category_sets_b d,

115: -- Changed cursor definition
116: /* CURSOR l_exploded_category_cursor (org_id_in number, req_type_code_in VARCHAR2) is
117: SELECT distinct /*+ ORDERED USE_NL(c d b a) */ /*a.parent_id
118: FROM mtl_default_category_sets c,
119: mtl_category_sets_b d,
120: mtl_item_categories b,
121: eni_denorm_hierarchies a
122: WHERE b.inventory_item_id = p_inventory_item_id and
123: b.organization_id = org_id_in and

Line 151: mtl_category_sets_b d,

147: from QP_PTE_REQUEST_TYPES_B REQ,
148: QP_PTE_SOURCE_SYSTEMS SOU,
149: QP_SOURCESYSTEM_FNAREA_MAP FNAREA,
150: MTL_DEFAULT_CATEGORY_SETS C,
151: mtl_category_sets_b d,
152: mtl_item_categories b
153: WHERE REQ.REQUEST_TYPE_CODE = req_type_code_in AND
154: REQ.ENABLED_FLAG = 'Y' AND
155: REQ.PTE_CODE = SOU.PTE_CODE AND

Line 203: from mtl_category_sets_b

199: --
200: --if l_category_set_id_7 = l_category_set_id_11 then
201: select hierarchy_enabled
202: into l_hierarchy_enabled
203: from mtl_category_sets_b
204: where category_set_id = l_category_set_id_11 and
205: hierarchy_enabled = 'Y';
206: --
207: OPEN l_exploded_category_cursor(l_org_id,l_appl_id,