DBA Data[Home] [Help]

APPS.PO_COPYDOC_SUB dependencies on MTL_CATEGORIES_VL

Line 1177: MTL_CATEGORIES_VL MCV

1173:
1174: SELECT distinct 'Y'
1175: INTO x_valid_flag
1176: FROM MTL_CATEGORY_SET_VALID_CATS MCSVC,
1177: MTL_CATEGORIES_VL MCV
1178: WHERE MCSVC.category_id = x_category_id
1179: AND MCSVC.category_set_id = l_category_set_id
1180: AND MCV.category_id = MCSVC.category_id
1181: AND sysdate < nvl(mcv.disable_date, sysdate+1)

Line 1188: FROM MTL_CATEGORIES_VL MCV

1184: ELSE
1185:
1186: SELECT distinct 'Y'
1187: INTO x_valid_flag
1188: FROM MTL_CATEGORIES_VL MCV
1189: WHERE MCV.category_id = x_category_id
1190: AND sysdate < nvl(mcv.disable_date, sysdate+1)
1191: AND mcv.enabled_flag = 'Y';
1192: