DBA Data[Home] [Help]

APPS.PO_COPYDOC_S3 dependencies on MTL_CATEGORIES_VL

Line 245: MTL_CATEGORIES_VL MCV

241: IF l_validate_flag = 'Y' THEN
242: SELECT distinct 'Y'
243: INTO x_valid_flag
244: FROM MTL_CATEGORY_SET_VALID_CATS MCSVC,
245: MTL_CATEGORIES_VL MCV
246: WHERE MCSVC.category_id = x_po_line_record.category_id
247: AND MCSVC.category_set_id = l_category_set_id
248: AND MCV.category_id = MCSVC.category_id
249: AND sysdate < nvl(MCV.disable_date, sysdate+1)

Line 254: FROM MTL_CATEGORIES_VL MCV

250: AND MCV.enabled_flag = 'Y';
251: ELSE
252: SELECT distinct 'Y'
253: INTO x_valid_flag
254: FROM MTL_CATEGORIES_VL MCV
255: WHERE MCV.category_id = x_po_line_record.category_id
256: AND sysdate < nvl(MCV.disable_date, sysdate+1)
257: AND MCV.enabled_flag = 'Y';
258: END IF;