APPS.OKL_MULTI_GAAP_PVT dependencies on OKL_PRODUCTS

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 322: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr, OKL_PRODUCTS pdt

318: pdt.name pdt_name,
319: pdt.reporting_pdt_id,
320: khr.deal_type,
321: chr.currency_code
322: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr, OKL_PRODUCTS pdt
323: WHERE chr.id = khr.id
324: AND chr.scs_code = 'LEASE'
325: AND chr.sts_code IN ('BOOKED','EVERGREEN') -- Bug 3448049. removed approved and under revision statuses
326: AND khr.pdt_id = pdt.id

Line 414: OKL_PRODUCTS pdt

410: OKL_STRM_ELEMENTS ste,
411: OKL_PROD_STRM_TYPES psty,
412: OKL_K_HEADERS khr,
413: OKC_K_HEADERS_B chr,
414: OKL_PRODUCTS pdt
415: WHERE stm.khr_id = p_khr_id
416: AND khr.id = chr.id
417: AND khr.id = stm.khr_id
418: AND stm.active_yn = 'N'

Line 481: OKL_PRODUCTS pdt,

477: SUM(txl.amount) total_amount
478: FROM OKL_STRM_TYPE_TL stytl,
479: OKL_K_HEADERS khr,
480: OKC_K_HEADERS_B chr,
481: OKL_PRODUCTS pdt,
482: OKL_TRX_CONTRACTS trx,
483: OKL_TXL_CNTRCT_LNS txl
484: WHERE chr.id = khr.id
485: AND pdt.id = khr.pdt_id

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: