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 1274: FROM ota_act_cat_inclusions actcat,

1270:
1271: CURSOR get_primary_dm_cr IS
1272: SELECT lookup.meaning Dm_Name,
1273: catusg.category Dm_Code
1274: FROM ota_act_cat_inclusions actcat,
1275: ota_category_usages catusg,
1276: hr_lookups lookup
1277: WHERE actcat.category_usage_id= catusg.category_usage_id
1278: AND actcat.primary_flag='Y'

Line 1287: FROM ota_act_cat_inclusions actcat,

1283:
1284: CURSOR get_first_dm_cr IS
1285: SELECT lookup.meaning dm_name,
1286: catusg.category dm_code
1287: FROM ota_act_cat_inclusions actcat,
1288: ota_category_usages catusg,
1289: hr_lookups lookup
1290: WHERE actcat.category_usage_id= catusg.category_usage_id
1291: AND catusg.category = lookup.lookup_code

Line 1873: FROM ota_act_cat_inclusions actcat,

1869:
1870: CURSOR get_primary_dm_cr IS
1871: SELECT lookup.meaning Dm_Name,
1872: catusg.category Dm_Code
1873: FROM ota_act_cat_inclusions actcat,
1874: ota_category_usages catusg,
1875: hr_lookups lookup
1876: WHERE actcat.category_usage_id= catusg.category_usage_id
1877: AND actcat.primary_flag='Y'

Line 1886: FROM ota_act_cat_inclusions actcat,

1882:
1883: CURSOR get_first_dm_cr IS
1884: SELECT lookup.meaning dm_name,
1885: catusg.category dm_code
1886: FROM ota_act_cat_inclusions actcat,
1887: ota_category_usages catusg,
1888: hr_lookups lookup
1889: WHERE actcat.category_usage_id= catusg.category_usage_id
1890: AND catusg.category = lookup.lookup_code