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_STREAM_BILLING_PVT dependencies on OKL_AE_TMPT_LNES

Line 1441: l_esd_acc_cc_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;

1437: FROM okl_k_headers_full_v
1438: WHERE id = p_khr_id;
1439: -- Variables for XTD Accounting Distributions
1440:
1441: l_esd_acc_cc_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1442: l_esd_ae_ln_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1443: l_esd_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1444: l_esd_acc_bldr_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1445: l_esd_percentage OKL_AE_TMPT_LNES.percentage%TYPE;

Line 1442: l_esd_ae_ln_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;

1438: WHERE id = p_khr_id;
1439: -- Variables for XTD Accounting Distributions
1440:
1441: l_esd_acc_cc_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1442: l_esd_ae_ln_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1443: l_esd_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1444: l_esd_acc_bldr_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1445: l_esd_percentage OKL_AE_TMPT_LNES.percentage%TYPE;
1446: l_esd_amount OKL_XTD_SELL_INVS_V.amount%TYPE;

Line 1443: l_esd_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;

1439: -- Variables for XTD Accounting Distributions
1440:
1441: l_esd_acc_cc_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1442: l_esd_ae_ln_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1443: l_esd_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1444: l_esd_acc_bldr_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1445: l_esd_percentage OKL_AE_TMPT_LNES.percentage%TYPE;
1446: l_esd_amount OKL_XTD_SELL_INVS_V.amount%TYPE;
1447:

Line 1444: l_esd_acc_bldr_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;

1440:
1441: l_esd_acc_cc_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1442: l_esd_ae_ln_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1443: l_esd_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1444: l_esd_acc_bldr_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1445: l_esd_percentage OKL_AE_TMPT_LNES.percentage%TYPE;
1446: l_esd_amount OKL_XTD_SELL_INVS_V.amount%TYPE;
1447:
1448: -- Create Distributions

Line 1445: l_esd_percentage OKL_AE_TMPT_LNES.percentage%TYPE;

1441: l_esd_acc_cc_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1442: l_esd_ae_ln_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1443: l_esd_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1444: l_esd_acc_bldr_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1445: l_esd_percentage OKL_AE_TMPT_LNES.percentage%TYPE;
1446: l_esd_amount OKL_XTD_SELL_INVS_V.amount%TYPE;
1447:
1448: -- Create Distributions
1449: CURSOR dstrs_csr( p_pdt_id NUMBER, p_try_id NUMBER, p_sty_id NUMBER, p_date DATE) IS

Line 1458: OKL_AE_TMPT_LNES C

1454: C.ACCOUNT_BUILDER_YN,
1455: C.PERCENTAGE
1456: FROM OKL_AE_TEMPLATES A,
1457: OKL_PRODUCTS_V B,
1458: OKL_AE_TMPT_LNES C
1459: WHERE A.aes_id = b.aes_id AND
1460: A.start_date <= p_date AND
1461: (A.end_date IS NULL OR A.end_date >= p_date) AND
1462: A.memo_yn = 'N' AND