DBA Data[Home] [Help]

APPS.QP_CATEGORY_MAPPING_RULE dependencies on MTL_CATEGORY_SETS_B

Line 29: mtl_category_sets_b d

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
31: AND a.organization_id = org_id_in
32: AND a.category_id = b.category_id
33: AND c.category_set_id = d.category_set_id

Line 67: mtl_category_sets_b d

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
69: AND a.organization_id = org_id_in
70: AND a.category_id = b.category_id
71: AND c.category_set_id = d.category_set_id

Line 86: mtl_category_sets_b d,

82:
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

Line 141: from mtl_category_sets_b

137: --
138: --if l_category_set_id_7 = l_category_set_id_11 then
139: select hierarchy_enabled
140: into l_hierarchy_enabled
141: from mtl_category_sets_b
142: where category_set_id = l_category_set_id_11 and
143: hierarchy_enabled = 'Y';
144: --
145: OPEN l_exploded_category_cursor(l_org_id,l_appl_id,