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_TDB_BUS dependencies on OTA_ACTIVITY_VERSIONS

Line 4013: l_new_inv_id ota_activity_versions.inventory_item_id%type;

4009: --
4010: l_event_record_use varchar2(10);
4011: --
4012: /* bug no 4509873 */
4013: l_new_inv_id ota_activity_versions.inventory_item_id%type;
4014: l_old_inv_id ota_activity_versions.inventory_item_id%type;
4015:
4016: CURSOR get_inv_id (p_event_id in number) is
4017: SELECT nvl(avt.inventory_item_id,1)

Line 4014: l_old_inv_id ota_activity_versions.inventory_item_id%type;

4010: l_event_record_use varchar2(10);
4011: --
4012: /* bug no 4509873 */
4013: l_new_inv_id ota_activity_versions.inventory_item_id%type;
4014: l_old_inv_id ota_activity_versions.inventory_item_id%type;
4015:
4016: CURSOR get_inv_id (p_event_id in number) is
4017: SELECT nvl(avt.inventory_item_id,1)
4018: FROM ota_events evt, ota_activity_versions avt

Line 4018: FROM ota_events evt, ota_activity_versions avt

4014: l_old_inv_id ota_activity_versions.inventory_item_id%type;
4015:
4016: CURSOR get_inv_id (p_event_id in number) is
4017: SELECT nvl(avt.inventory_item_id,1)
4018: FROM ota_events evt, ota_activity_versions avt
4019: WHERE evt.activity_version_id = avt.activity_version_id
4020: AND evt.event_id = p_event_id ;
4021:
4022: /* bug no 4509873 */