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_COPYDOC_SUB dependencies on MTL_CATEGORY_SET_VALID_CATS

Line 1102: validating on MTL_CATEGORY_SET_VALID_CATS only when the 'Enforce list of valid

1098:
1099: -- Start Bug # 3222657
1100: /*
1101: Bug# 3222657, Commented out the following piece of code and fixed the Issue by
1102: validating on MTL_CATEGORY_SET_VALID_CATS only when the 'Enforce list of valid
1103: Categories' (validate_flag) is set to 'Y' for the Category Set.
1104:
1105: SELECT distinct 'Y'
1106: INTO x_valid_flag

Line 1107: FROM MTL_CATEGORY_SET_VALID_CATS MCSVC,

1103: Categories' (validate_flag) is set to 'Y' for the Category Set.
1104:
1105: SELECT distinct 'Y'
1106: INTO x_valid_flag
1107: FROM MTL_CATEGORY_SET_VALID_CATS MCSVC,
1108: MTL_DEFAULT_SETS_VIEW MDSV
1109: WHERE MCSVC.category_id = x_category_id
1110: AND MCSVC.category_set_id = MDSV.category_set_id
1111: AND MDSV.functional_area_id = 2;

Line 1129: FROM MTL_CATEGORY_SET_VALID_CATS MCSVC,

1125: IF l_validate_flag = 'Y' then
1126:
1127: SELECT distinct 'Y'
1128: INTO x_valid_flag
1129: FROM MTL_CATEGORY_SET_VALID_CATS MCSVC,
1130: MTL_CATEGORIES_VL MCV
1131: WHERE MCSVC.category_id = x_category_id
1132: AND MCSVC.category_set_id = l_category_set_id
1133: AND MCV.category_id = MCSVC.category_id