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 1149: validating on MTL_CATEGORY_SET_VALID_CATS only when the 'Enforce list of valid

1145:
1146: -- Start Bug # 3222657
1147: /*
1148: Bug# 3222657, Commented out the following piece of code and fixed the Issue by
1149: validating on MTL_CATEGORY_SET_VALID_CATS only when the 'Enforce list of valid
1150: Categories' (validate_flag) is set to 'Y' for the Category Set.
1151:
1152: SELECT distinct 'Y'
1153: INTO x_valid_flag

Line 1154: FROM MTL_CATEGORY_SET_VALID_CATS MCSVC,

1150: Categories' (validate_flag) is set to 'Y' for the Category Set.
1151:
1152: SELECT distinct 'Y'
1153: INTO x_valid_flag
1154: FROM MTL_CATEGORY_SET_VALID_CATS MCSVC,
1155: MTL_DEFAULT_SETS_VIEW MDSV
1156: WHERE MCSVC.category_id = x_category_id
1157: AND MCSVC.category_set_id = MDSV.category_set_id
1158: AND MDSV.functional_area_id = 2;

Line 1176: FROM MTL_CATEGORY_SET_VALID_CATS MCSVC,

1172: IF l_validate_flag = 'Y' then
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