DBA Data[Home] [Help]

APPS.PO_CATEGORIES_SV1 dependencies on MTL_CATEGORIES_VL

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: