APPS.PO_CATEGORIES_SV1 dependencies on MTL_CATEGORY_SETS

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 133: FROM mtl_category_sets mcs,

129: /* get the default category_id */
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:

Line 161: x_validate_flag mtl_category_sets_v.validate_flag%TYPE;

157:
158: x_progress varchar2(3) := null;
159: x_temp binary_integer := 0;
160: -- Bug# 3129778
161: x_validate_flag mtl_category_sets_v.validate_flag%TYPE;
162:
163: BEGIN
164: x_progress := '010';
165:

Line 176: FROM mtl_category_sets_v

172:
173: BEGIN
174: SELECT validate_flag
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 ***/