APPS.PO_CATEGORIES_SV1 dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 30: FROM mtl_default_category_sets

26: FROM mtl_item_categories mic,
27: mtl_categories mcs
28: WHERE mic.category_id = mcs.category_id
29: AND mic.category_set_id = (SELECT category_set_id
30: FROM mtl_default_category_sets
31: WHERE functional_area_id = 2 /* 2=purchasing*/)
32: AND mic.category_id = x_category_id
33: AND mic.inventory_item_id = x_item_id
34: AND mic.organization_id = x_organization_id

Line 79: FROM mtl_categories_kfv mck, mtl_category_sets mcs, mtl_default_category_sets mdcs

75:
76: get the category_id from mtl_categories_kfv based on x_category
77: SELECT category_id
78: INTO X_category_id_v
79: FROM mtl_categories_kfv mck, mtl_category_sets mcs, mtl_default_category_sets mdcs
80: WHERE concatenated_segments = X_category
81: AND mck.structure_id = mcs.structure_id
82: AND mcs.category_set_id = mdcs.category_set_id
83: AND mdcs.functional_area_id = 2;

Line 92: from mtl_default_category_sets mdcs,mtl_category_sets_b mcsb

88:
89: */
90: select structure_id
91: into x_structure_id
92: from mtl_default_category_sets mdcs,mtl_category_sets_b mcsb
93: where mdcs.functional_area_id = 2 /* 2 = Purchasing */
94: and mdcs.category_set_id = mcsb.category_set_id;
95:
96: ret_code := FND_FLEX_EXT.GET_CCID('INV', 'MCAT', x_structure_id, to_char(sysdate,'YYYY/MM/DD HH24:MI:SS'),x_category);

Line 134: mtl_default_category_sets mdcs

130:
131: SELECT mcs.default_category_id
132: INTO X_category_id
133: FROM mtl_category_sets mcs,
134: mtl_default_category_sets mdcs
135: WHERE mdcs.functional_area_id = 2 /* 2= purchasing */
136: AND mdcs.category_set_id = mcs.category_set_id;
137:
138: RETURN X_category_id;

Line 179: FROM mtl_default_category_sets

175: INTO x_validate_flag
176: FROM mtl_category_sets_v
177: WHERE category_set_id=
178: (SELECT category_set_id
179: FROM mtl_default_category_sets
180: WHERE functional_area_id = 2 /*** purchasing ***/
181: ) ;
182: EXCEPTION
183: when others then

Line 197: FROM mtl_default_category_sets

193: WHERE mcs.category_id = x_category_id
194: AND mcs.category_id = mcsvc.category_id
195: AND mcsvc.category_set_id =
196: (SELECT category_set_id
197: FROM mtl_default_category_sets
198: WHERE functional_area_id = 2 /*** purchasing ***/
199: )
200: AND sysdate < nvl(mcs.disable_date, sysdate+1)
201: AND mcs.enabled_flag = 'Y';