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_GENERATE_ACCRUALS_PVT dependencies on OKL_PRODUCTS

Line 352: OKL_PRODUCTS C

348: SELECT a.contract_number,
349: nvl(b.multi_gaap_yn, 'N') multi_gaap_yn,
350: c.reporting_pdt_id -- MGAAP 7263041
351: FROM OKC_K_HEADERS_B a, OKL_K_HEADERS B,
352: OKL_PRODUCTS C
353: WHERE A.id = p_chr_id
354: AND A.id = B.id
355: AND B.PDT_ID = C.ID;
356:

Line 357: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE := null;

353: WHERE A.id = p_chr_id
354: AND A.id = B.id
355: AND B.PDT_ID = C.ID;
356:
357: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE := null;
358: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
359:
360: -- bug 7577628
361: cursor get_sec_rep_method IS

Line 381: OKL_PRODUCTS pdt

377: OKL_STREAMS_REP_V stm, -- MGAAP 7263041
378: OKL_STRM_ELEMENTS ste,
379: OKL_PROD_STRM_TYPES psty,
380: OKL_K_HEADERS khr,
381: OKL_PRODUCTS pdt
382: WHERE khr.id = p_chr_id
383: AND stm.khr_id = khr.id
384: AND stm.say_code = 'CURR'
385: AND stm.active_yn = 'Y'

Line 887: ,p_product_id IN OKL_PRODUCTS_V.ID%TYPE

883: -- Procedure to select streams that need to be accrued
884: PROCEDURE GET_ACCRUAL_STREAMS(x_return_status OUT NOCOPY VARCHAR2
885: ,x_stream_tbl OUT NOCOPY stream_tbl_type
886: ,p_khr_id IN OKL_K_HEADERS.ID%TYPE
887: ,p_product_id IN OKL_PRODUCTS_V.ID%TYPE
888: ,p_ctr_start_date IN DATE
889: ,p_period_end_date IN DATE
890: ,p_accrual_rule_yn IN VARCHAR2) IS
891:

Line 2214: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;

2210: l_sob_id NUMBER;
2211: l_accrual_rec accrual_rec_type;
2212: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2213: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
2214: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
2215: l_total1 NUMBER := 0;
2216: l_total2 NUMBER := 0;
2217: l_try_id NUMBER;
2218: l_currency_conversion_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;

Line 2259: OKL_PRODUCTS pdt

2255: khr.generate_accrual_override_yn,
2256: khr.deal_type,
2257: pdt.reporting_pdt_id -- MGAAP 7263014
2258: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,
2259: OKL_PRODUCTS pdt
2260: WHERE chr.id = p_ctr_id
2261: AND chr.id = khr.id
2262: AND khr.pdt_id = pdt.id;
2263:

Line 2782: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE; --MGAAP 7263041

2778: l_stream_tbl stream_tbl_type;
2779: l_accrual_rec accrual_rec_type;
2780: l_contract_number OKL_K_HEADERS_FULL_V.contract_number%TYPE;
2781: l_product_id OKL_K_HEADERS_FULL_V.pdt_id%TYPE;
2782: l_reporting_pdt_id OKL_PRODUCTS.reporting_pdt_id%TYPE; --MGAAP 7263041
2783: l_apply_accrual_rule VARCHAR2(1) := '?';
2784: l_rule_result VARCHAR2(1);
2785: l_override_status VARCHAR2(1);
2786: l_total NUMBER := 0;

Line 2819: OKL_PRODUCTS pdt --MGAAP 7263041

2815: ,khr.currency_conversion_rate
2816: ,khr.currency_conversion_date
2817: ,pdt.reporting_pdt_id
2818: FROM OKC_K_HEADERS_B chr, OKL_K_HEADERS khr,
2819: OKL_PRODUCTS pdt --MGAAP 7263041
2820: WHERE chr.id = p_khr_id
2821: AND chr.id = khr.id
2822: AND khr.pdt_id = pdt.id;
2823:

Line 2900: OKL_PRODUCTS pdt

2896: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2897: OKL_STRM_ELEMENTS ste,
2898: OKL_PROD_STRM_TYPES psty,
2899: OKL_K_HEADERS khr,
2900: OKL_PRODUCTS pdt
2901: WHERE sty.id = p_acceleration_rec.sty_id
2902: AND stm.khr_id = p_acceleration_rec.khr_id
2903: AND stm.kle_id = p_acceleration_rec.kle_id
2904: AND khr.id = stm.khr_id

Line 2936: OKL_PRODUCTS pdt

2932: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2933: OKL_STRM_ELEMENTS ste,
2934: OKL_PROD_STRM_TYPES psty,
2935: OKL_K_HEADERS khr,
2936: OKL_PRODUCTS pdt
2937: WHERE sty.id = p_acceleration_rec.sty_id
2938: AND stm.khr_id = p_acceleration_rec.khr_id
2939: AND stm.kle_id = p_acceleration_rec.kle_id
2940: AND khr.id = stm.khr_id

Line 2973: OKL_PRODUCTS pdt

2969: OKL_STREAMS_REP_V stm, --MGAAP 7263041
2970: OKL_STRM_ELEMENTS ste,
2971: OKL_PROD_STRM_TYPES psty,
2972: OKL_K_HEADERS khr,
2973: OKL_PRODUCTS pdt
2974: WHERE stm.khr_id = p_acceleration_rec.khr_id
2975: AND khr.id = stm.khr_id
2976: AND sty.id = p_acceleration_rec.sty_id
2977: AND stm.sty_id = sty.id

Line 3010: OKL_PRODUCTS pdt

3006: OKL_STREAMS_REP_V stm, --MGAAP 7263041
3007: OKL_STRM_ELEMENTS ste,
3008: OKL_PROD_STRM_TYPES psty,
3009: OKL_K_HEADERS khr,
3010: OKL_PRODUCTS pdt
3011: WHERE stm.khr_id = p_acceleration_rec.khr_id
3012: AND khr.id = stm.khr_id
3013: AND sty.id = p_acceleration_rec.sty_id
3014: AND stm.sty_id = sty.id

Line 5399: OKL_PRODUCTS b

5395: CURSOR contract_multigaap_csr (p_contract_id NUMBER) IS
5396: SELECT NVL(a.multi_gaap_yn,'N') multi_gaap_yn,
5397: b.reporting_pdt_id
5398: FROM OKL_K_HEADERS a,
5399: OKL_PRODUCTS b
5400: WHERE a.ID = p_contract_id
5401: AND a.PDT_ID = b.ID;
5402:
5403: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;

Line 5404: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;

5400: WHERE a.ID = p_contract_id
5401: AND a.PDT_ID = b.ID;
5402:
5403: l_multi_gaap_yn OKL_K_HEADERS.MULTI_GAAP_YN%TYPE;
5404: l_reporting_pdt_id OKL_PRODUCTS.REPORTING_PDT_ID%TYPE;
5405: l_tcnv_tbl_cnt NUMBER;
5406: l_sty_id_rep OKL_STRM_TYPE_V.id%TYPE;
5407: -- MGAAP end 7263041
5408: