[Home] [Help]
35: AND b.structure_id = d.structure_id;
36:
37: CURSOR l_exploded_category_cursor (org_id_in number, appl_id_in number) is
38: SELECT parent_id
39: FROM eni_denorm_hierarchies a,
40: mtl_item_categories b,
41: mtl_default_category_sets c
42: WHERE inventory_item_id = p_inventory_item_id and
43: organization_id = org_id_in and
47: functional_area_id = decode(appl_id_in,201,2,7);
48: CURSOR l_exploded_category_cursor (org_id_in number, appl_id_in number,
49: category_set_id_in number) is
50: SELECT parent_id
51: FROM eni_denorm_hierarchies a,
52: mtl_item_categories b,
53: mtl_default_category_sets c
54: WHERE inventory_item_id = p_inventory_item_id and
55: organization_id = org_id_in and
84: SELECT distinct /*+ ORDERED USE_NL(c d b a) */ a.parent_id
85: FROM mtl_default_category_sets c,
86: mtl_category_sets_b d,
87: mtl_item_categories b,
88: eni_denorm_hierarchies a
89: WHERE b.inventory_item_id = p_inventory_item_id and
90: b.organization_id = org_id_in and
91: b.category_set_id = c.category_set_id and
92: a.object_type = 'CATEGORY_SET' and
283: and (organization_id = p_org_id or p_org_id is null)
284: UNION
285: -- for Product Catalog 11i10
286: select inventory_item_id
287: from eni_denorm_hierarchies eni,
288: mtl_item_categories mtl,
289: mtl_default_category_sets sets
290: where mtl.category_set_id = eni.object_id
291: and mtl.category_set_id = l_category_set_id