VIEW: APPS.OKL_TMPT_SET_COPY_UV

Source

View Text - Preformatted

SELECT aes.ID ID, aes.name NAME, aes.description DESCRIPTION, aes.start_date START_DATE, aes.end_date END_DATE FROM OKL_AE_TMPT_SETS AES WHERE aes.id in (select aes_id from okl_ae_templates_all avl where avl.set_of_books_id = okl_Accounting_util.get_set_of_books_id) order by aes.name

View Text - HTML Formatted

SELECT AES.ID ID
, AES.NAME NAME
, AES.DESCRIPTION DESCRIPTION
, AES.START_DATE START_DATE
, AES.END_DATE END_DATE
FROM OKL_AE_TMPT_SETS AES
WHERE AES.ID IN (SELECT AES_ID
FROM OKL_AE_TEMPLATES_ALL AVL
WHERE AVL.SET_OF_BOOKS_ID = OKL_ACCOUNTING_UTIL.GET_SET_OF_BOOKS_ID) ORDER BY AES.NAME