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_PRICE_LISTS

Line 164: , ota_price_lists tpl

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;
168: --

Line 255: , ota_price_lists tpl

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
259: and evt.event_id = p_event_id

Line 337: , ota_price_lists tpl

333: ,tpe.price)
334: , evt.standard_price
335: from ota_events evt
336: , ota_price_list_entries tpe
337: , ota_price_lists tpl
338: where evt.event_id = p_event_id
339: and evt.currency_code = p_currency_code
340: and tpe.price_basis = p_price_basis
341: and tpe.price_list_id = p_price_list_id