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_TAV_BUS dependencies on OTA_ACTIVITY_DEFINITIONS

Line 1384: ota_activity_definitions oad,

1380:
1381: cursor csr_is_root_category is
1382: select cat.parent_cat_usage_id
1383: from
1384: ota_activity_definitions oad,
1385: ota_category_usages cat
1386: where
1387: oad.category_usage_id=cat.category_usage_id
1388: and oad.activity_id=p_activity_id;

Line 1897: ota_activity_definitions oad

1893: cursor csr_leg_code is
1894: select legislation_code
1895: from per_business_groups pbg,
1896: ota_activity_versions oav,
1897: ota_activity_definitions oad
1898: where pbg.business_group_id = oad.business_group_id
1899: and oad.activity_id = oav.activity_id
1900: and oav.activity_version_id = p_activity_version_id;
1901: