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_PRICE_LISTS

Line 574: , ota_price_lists tpl

570: cursor sel_pricelist_type is
571: select tbd.type
572: , tpl.price_list_type
573: from ota_booking_deals tbd
574: , ota_price_lists tpl
575: where tbd.booking_deal_id = p_booking_deal_id
576: and tpl.price_list_id (+) = tbd.price_list_id;
577: --
578: Begin

Line 1082: , ota_price_lists tpl

1078: --
1079: cursor sel_price_list_currency is
1080: select tpl.currency_code
1081: from ota_booking_deals tbd
1082: , ota_price_lists tpl
1083: where tbd.booking_deal_id = p_booking_deal_id
1084: and tpl.price_list_id = tbd.price_list_id;
1085: --
1086: cursor sel_resource_alloc_currency is

Line 1249: , ota_price_lists tpl

1245: --
1246: cursor sel_price_list_currency is
1247: select tpl.currency_code
1248: from ota_booking_deals tbd
1249: , ota_price_lists tpl
1250: where tbd.booking_deal_id = p_booking_deal_id
1251: and tpl.price_list_id = tbd.price_list_id;
1252: --
1253: cursor sel_resource_alloc_currency is