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_TPL_BUS dependencies on OTA_PRICE_LIST_ENTRIES

Line 304: from ota_price_list_entries

300: return boolean is
301: ----------------------------
302: cursor csr_children_ple is
303: select 1
304: from ota_price_list_entries
305: where price_list_id = p_tpl_id;
306:
307: l_ple_exists boolean;
308:

Line 462: from ota_price_list_entries

458: --*** Start_dates are mandatory in price lists and price list entries
459: ----------------
460: cursor csr_ple_min_startdate is
461: select min(start_date)
462: from ota_price_list_entries
463: where price_list_id = p_tpl_id;
464:
465: mindate date;
466:

Line 554: from ota_price_list_entries

550: --*** end dates may be null
551: --
552: cursor csr_ple_max_enddate is
553: select max(nvl(end_date,g_end_of_time))
554: from ota_price_list_entries
555: where price_list_id = p_tpl_id;
556: --
557: maxdate date;
558: --