APPS.QP_CATEGORY_MAPPING_RULE dependencies on ENI_DENORM_HIERARCHIES

Line 43: FROM eni_denorm_hierarchies a,

39: AND b.structure_id = d.structure_id;
40:
41: CURSOR l_exploded_category_cursor (org_id_in number, appl_id_in number) is
42: SELECT parent_id
43: FROM eni_denorm_hierarchies a,
44: mtl_item_categories b,
45: mtl_default_category_sets c
46: WHERE inventory_item_id = p_inventory_item_id and
47: organization_id = org_id_in and

Line 55: FROM eni_denorm_hierarchies a,

51: functional_area_id = decode(appl_id_in,201,2,7);
52: CURSOR l_exploded_category_cursor (org_id_in number, appl_id_in number,
53: category_set_id_in number) is
54: SELECT parent_id
55: FROM eni_denorm_hierarchies a,
56: mtl_item_categories b,
57: mtl_default_category_sets c
58: WHERE inventory_item_id = p_inventory_item_id and
59: organization_id = org_id_in and

Line 121: eni_denorm_hierarchies a

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
124: b.category_set_id = c.category_set_id and
125: a.object_type = 'CATEGORY_SET' and

Line 144: select /*+ leading(x,A) no_merge(x) use_nl_with_index(a ENI_DENORM_HIERARCHIES_N2) */ A.PARENT_ID --bug 8924817

140: FNAREA.PTE_SOURCE_SYSTEM_ID
141: and FNAREA.ENABLED_FLAG = 'Y');*/
142:
143: CURSOR l_exploded_category_cursor (org_id_in number, req_type_code_in VARCHAR2) is
144: select /*+ leading(x,A) no_merge(x) use_nl_with_index(a ENI_DENORM_HIERARCHIES_N2) */ A.PARENT_ID --bug 8924817
145: from (select /*+ ordered use_nl(req sou fnarea c d b) */ distinct b.category_id,
146: b.category_set_id
147: from QP_PTE_REQUEST_TYPES_B REQ,
148: QP_PTE_SOURCE_SYSTEMS SOU,

Line 165: ENI_DENORM_HIERARCHIES A

161: d.hierarchy_enabled = 'Y' and
162: b.inventory_item_id = p_inventory_item_id and
163: b.organization_id = org_id_in and
164: b.category_set_id = d.category_set_id) x,
165: ENI_DENORM_HIERARCHIES A
166: WHERE A.OBJECT_TYPE = 'CATEGORY_SET' AND
167: A.OBJECT_ID = x.CATEGORY_SET_ID AND
168: a.child_id = x.category_id ;
169:

Line 386: from eni_denorm_hierarchies eni,

382: and (organization_id = p_org_id or p_org_id is null)
383: UNION
384: -- for Product Catalog 11i10
385: select inventory_item_id
386: from eni_denorm_hierarchies eni,
387: mtl_item_categories mtl,
388: mtl_default_category_sets sets
389: where mtl.category_set_id = eni.object_id
390: and mtl.category_set_id = l_category_set_id