APPS.QP_CATEGORY_MAPPING_RULE dependencies on MTL_ITEM_CATEGORIES

Line 26: FROM mtl_item_categories a,

22: /*
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

Line 40: mtl_item_categories b,

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
44: a.object_type = 'CATEGORY_SET' and

Line 52: mtl_item_categories b,

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
56: b.category_set_id = category_set_id_in and

Line 64: FROM mtl_item_categories a,

60: functional_area_id = decode(appl_id_in,201,2,11);
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

Line 87: mtl_item_categories b,

83: CURSOR l_exploded_category_cursor (org_id_in number, req_type_code_in VARCHAR2) is
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

Line 281: from mtl_item_categories

277: AND (MTLITM1.organization_id = p_org_id or p_org_id is null)
278: AND MTLUOM2.uom_code = p_product_uom_code
279: AND MTLUCV.inventory_item_id in
280: (select inventory_item_id
281: from mtl_item_categories
282: where category_id = p_category_id
283: and (organization_id = p_org_id or p_org_id is null)
284: UNION
285: -- for Product Catalog 11i10

Line 288: mtl_item_categories mtl,

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
292: and eni.object_type = 'CATEGORY_SET'