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_TFL_API_BUSINESS_RULES dependencies on OTA_RESOURCE_ALLOCATIONS

Line 377: from ota_resource_allocations tra

373: --
374: cursor sel_booking_customer is
375: select tdb.customer_id
376: , tdb.source_of_booking
377: from ota_resource_allocations tra
378: , ota_delegate_bookings tdb
379: where tra.resource_allocation_id = p_resource_allocation_id
380: and tdb.booking_id = tra.booking_id;
381: --

Line 1088: from ota_resource_allocations tra

1084: and tpl.price_list_id = tbd.price_list_id;
1085: --
1086: cursor sel_resource_alloc_currency is
1087: select evt.currency_code
1088: from ota_resource_allocations tra
1089: , ota_delegate_bookings tdb
1090: , ota_events evt
1091: where tra.resource_allocation_id = p_resource_allocation_id
1092: and tdb.booking_id = tra.booking_id

Line 1255: from ota_resource_allocations tra

1251: and tpl.price_list_id = tbd.price_list_id;
1252: --
1253: cursor sel_resource_alloc_currency is
1254: select evt.currency_code
1255: from ota_resource_allocations tra
1256: , ota_delegate_bookings tdb
1257: , ota_events evt
1258: where tra.resource_allocation_id = p_resource_allocation_id
1259: and tdb.booking_id = tra.booking_id