APPS.PO_CATEGORIES_SV1 dependencies on MTL_CATEGORIES

Line 27: mtl_categories mcs

23:
24: SELECT count(*)
25: INTO x_temp
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*/)

Line 76: get the category_id from mtl_categories_kfv based on x_category

72: /*Bug1730946
73: Bcos of a performance issue splitting the below query
74: and calling the BOM api to achieve the same functionality.
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

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 191: FROM mtl_categories_vl mcs,

187: IF x_validate_flag = 'Y' then
188:
189: SELECT count(*)
190: INTO x_temp
191: FROM mtl_categories_vl mcs,
192: mtl_category_set_valid_cats mcsvc
193: WHERE mcs.category_id = x_category_id
194: AND mcs.category_id = mcsvc.category_id
195: AND mcsvc.category_set_id =

Line 213: FROM mtl_categories_vl mcs

209: ELSE
210:
211: SELECT count(*)
212: INTO x_temp
213: FROM mtl_categories_vl mcs
214: WHERE mcs.category_id = x_category_id
215: AND sysdate < nvl(mcs.disable_date, sysdate+1)
216: AND mcs.enabled_flag = 'Y';
217: