APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on MTL_CATEGORY_SET_VALID_CATS

Line 3705: -- MTL_CATEGORY_SET_VALID_CATS.

3701: l_progress := '090';
3702: IF l_validate_flag = 'Y' THEN
3703: l_progress := '100';
3704: -- SQL What: Bulk validate category. Validate category_id against
3705: -- MTL_CATEGORY_SET_VALID_CATS.
3706: -- Insert the error rows into GT table.
3707: -- SQL Why : It will be used to mark the record in plsql table as error.
3708: -- SQL Join: category_id
3709: FORALL i IN 1 .. p_lines_rec.item_id.COUNT

Line 3731: MTL_CATEGORY_SET_VALID_CATS MCSVC

3727: AND p_lines_rec.category_id(i) <> g_NULL_COLUMN_VALUE -- -2
3728: AND NOT EXISTS
3729: (SELECT 'Y'
3730: FROM MTL_CATEGORIES_VL MCS,
3731: MTL_CATEGORY_SET_VALID_CATS MCSVC
3732: WHERE MCS.category_id = p_lines_rec.category_id(i)
3733: AND MCS.category_id = MCSVC.category_id
3734: AND MCSVC.category_set_id = l_category_set_id
3735: AND sysdate < nvl(MCS.disable_date, sysdate+1)