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.OTA_UTILITY dependencies on OTA_ACT_CAT_INCLUSIONS

Line 1338: FROM ota_act_cat_inclusions actcat,

1334:
1335: CURSOR get_primary_dm_cr IS
1336: SELECT lookup.meaning Dm_Name,
1337: catusg.category Dm_Code
1338: FROM ota_act_cat_inclusions actcat,
1339: ota_category_usages catusg,
1340: hr_lookups lookup
1341: WHERE actcat.category_usage_id= catusg.category_usage_id
1342: AND actcat.primary_flag='Y'

Line 1351: FROM ota_act_cat_inclusions actcat,

1347:
1348: CURSOR get_first_dm_cr IS
1349: SELECT lookup.meaning dm_name,
1350: catusg.category dm_code
1351: FROM ota_act_cat_inclusions actcat,
1352: ota_category_usages catusg,
1353: hr_lookups lookup
1354: WHERE actcat.category_usage_id= catusg.category_usage_id
1355: AND catusg.category = lookup.lookup_code

Line 1937: FROM ota_act_cat_inclusions actcat,

1933:
1934: CURSOR get_primary_dm_cr IS
1935: SELECT lookup.meaning Dm_Name,
1936: catusg.category Dm_Code
1937: FROM ota_act_cat_inclusions actcat,
1938: ota_category_usages catusg,
1939: hr_lookups lookup
1940: WHERE actcat.category_usage_id= catusg.category_usage_id
1941: AND actcat.primary_flag='Y'

Line 1950: FROM ota_act_cat_inclusions actcat,

1946:
1947: CURSOR get_first_dm_cr IS
1948: SELECT lookup.meaning dm_name,
1949: catusg.category dm_code
1950: FROM ota_act_cat_inclusions actcat,
1951: ota_category_usages catusg,
1952: hr_lookups lookup
1953: WHERE actcat.category_usage_id= catusg.category_usage_id
1954: AND catusg.category = lookup.lookup_code