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_RULES2 dependencies on OTA_BOOKING_DEALS

Line 163: from ota_booking_deals tbd

159: cursor sel_type_P_amounts is
160: select nvl( tbd.discount_percentage, 0)
161: , tpl.price_list_type
162: , tpl.single_unit_price
163: from ota_booking_deals tbd
164: , ota_price_lists tpl
165: where tbd.booking_deal_id = p_booking_deal_id
166: and tbd.type = 'P'
167: and tpl.price_list_id = tbd.price_list_id;

Line 254: from ota_booking_deals tbd

250: , tbd.activity_version_id
251: , tbd.category
252: , tpl.price_list_type
253: , nvl( tpl.single_unit_price, 0)
254: from ota_booking_deals tbd
255: , ota_price_lists tpl
256: , ota_events evt
257: where tbd.booking_deal_id = p_booking_deal_id
258: and tpl.price_list_id (+) = tbd.price_list_id