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_TEA_BUS dependencies on OTA_FINANCE_LINES

Line 353: from ota_finance_lines

349: where booking_deal_id = p_booking_deal_id;
350: --
351: cursor c_amount_so_far is
352: select sum(nvl(money_amount,0))
353: from ota_finance_lines
354: where finance_header_id = p_finance_header_id
355: and booking_id is not null
356: and cancelled_flag <> 'Y'
357: and booking_deal_id <> p_booking_deal_id;

Line 361: from ota_finance_lines

357: and booking_deal_id <> p_booking_deal_id;
358: --
359: cursor c_pre_purchase_limit is
360: select sum(nvl(money_amount,0))
361: from ota_finance_lines
362: where booking_deal_id = p_booking_deal_id
363: and booking_id is null
364: and cancelled_flag <> 'Y';
365: --