eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_R12_CAT_UPG_VAL_PVT dependencies on MTL_CATEGORIES_VL

Line 3730: FROM MTL_CATEGORIES_VL MCS,

3726: AND p_lines_rec.category_id(i) is not null
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

Line 3793: -- MTL_CATEGORIES_VL.

3789: ELSE -- IF l_validate_flag <> 'Y' THEN
3790:
3791: l_progress := '140';
3792: -- SQL What: Bulk validate category. Validate category_id against
3793: -- MTL_CATEGORIES_VL.
3794: -- Insert the error rows into GT table.
3795: -- SQL Why : It will be used to mark the record in plsql table as error.
3796: -- SQL Join: category_id
3797: FORALL i IN 1 .. p_lines_rec.item_id.COUNT

Line 3818: FROM MTL_CATEGORIES_VL MCS

3814: AND p_lines_rec.category_id(i) is not null
3815: AND p_lines_rec.category_id(i) <> g_NULL_COLUMN_VALUE -- -2
3816: AND NOT EXISTS
3817: (SELECT 1
3818: FROM MTL_CATEGORIES_VL MCS
3819: WHERE MCS.category_id = p_lines_rec.category_id(i)
3820: AND sysdate < nvl(MCS.disable_date, sysdate+1)
3821: AND MCS.enabled_flag = 'Y');
3822: