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.OCM_DATA_POINTS_PUB dependencies on AR_LOOKUPS

Line 106: FROM ar_lookups

102: IF p_data_point_sub_category IS NOT NULL
103: THEN
104: BEGIN
105: SELECT 'x' INTO l_check_flag
106: FROM ar_lookups
107: WHERE lookup_type = 'OCM_USER_DATA_POINT_CATEGORIES'
108: AND lookup_code = p_data_point_sub_category
109: AND enabled_flag = 'Y'
110: AND trunc(sysdate) between trunc(start_date_active)

Line 132: FROM ar_lookups

128: IF p_data_point_category IS NOT NULL
129: THEN
130: BEGIN
131: SELECT 'x' INTO l_check_flag
132: FROM ar_lookups
133: WHERE lookup_type = 'AR_CMGT_DATA_POINT_CATEGORY'
134: AND lookup_code = p_data_point_category
135: AND enabled_flag = 'Y'
136: AND trunc(sysdate) between trunc(start_date_active)