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.OKL_MULTI_GAAP_PVT dependencies on OKL_PRODUCTS_V

Line 100: (SELECT avl.aes_id FROM okl_products_v WHERE avl.name = p_product)

96: FROM OKL_AE_TMPT_LNES
97: WHERE avl_id IN (SELECT avl.id
98: FROM okl_ae_templates avl,okl_trx_types_v try,okl_strm_type_v sty
99: WHERE aes_id IN
100: (SELECT avl.aes_id FROM okl_products_v WHERE avl.name = p_product)
101: AND try.name = 'Accrual'
102: AND sty.name= p_stream_type
103: AND avl.sty_id = sty.id
104: AND avl.try_id = try.id

Line 116: (SELECT aes_id FROM okl_products_v WHERE name = p_product)

112: FROM OKL_AE_TMPT_LNES
113: WHERE avl_id IN (SELECT id
114: FROM okl_Ae_templates_uv
115: WHERE aes_id IN
116: (SELECT aes_id FROM okl_products_v WHERE name = p_product)
117: AND try_name = 'Accrual'
118: AND sty_name = p_stream_type
119: AND memo_yn = p_memo_yn
120: AND prior_year_yn is NULL

Line 276: l_product_name OKL_PRODUCTS_V.name%TYPE;

272: -- declare local variables
273: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
274: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
275: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
276: l_product_name OKL_PRODUCTS_V.name%TYPE;
277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;
278: l_rep_product_name OKL_PRODUCTS_V.name%TYPE;
279: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
280: l_rep_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;

Line 277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;

273: l_contract_id OKL_K_HEADERS_FULL_V.id%TYPE;
274: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
275: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
276: l_product_name OKL_PRODUCTS_V.name%TYPE;
277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;
278: l_rep_product_name OKL_PRODUCTS_V.name%TYPE;
279: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
280: l_rep_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
281: l_currency_code OKL_TRX_CONTRACTS.currency_code%TYPE;

Line 278: l_rep_product_name OKL_PRODUCTS_V.name%TYPE;

274: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
275: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
276: l_product_name OKL_PRODUCTS_V.name%TYPE;
277: l_rep_product_id OKL_PRODUCTS_V.reporting_pdt_id%TYPE;
278: l_rep_product_name OKL_PRODUCTS_V.name%TYPE;
279: l_deal_type OKL_K_HEADERS.DEAL_TYPE%TYPE;
280: l_rep_deal_type OKL_K_HEADERS_FULL_V.deal_type%TYPE;
281: l_currency_code OKL_TRX_CONTRACTS.currency_code%TYPE;
282: l_sob_id OKL_SYS_ACCT_OPTS.set_of_books_id%TYPE;

Line 520: product_name OKL_PRODUCTS_V.NAME%TYPE,

516: TYPE gaap_contracts_rec_type IS RECORD(
517: contract_id OKL_K_HEADERS_FULL_V.ID%TYPE,
518: contract_number OKL_K_HEADERS_FULL_V.CONTRACT_NUMBER%TYPE,
519: product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
520: product_name OKL_PRODUCTS_V.NAME%TYPE,
521: rep_product_id OKL_K_HEADERS_FULL_V.PDT_ID%TYPE,
522: deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE,
523: khr_currency_code OKL_K_HEADERS_FULL_V.CURRENCY_CODE%TYPE);
524: