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.

[Home] [Help]

APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_AE_TMPT_LNES

Line 1253: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;

1249: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1250: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1251: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1252:
1253: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1254: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1255: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1256: l_account_builder_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1257: l_percentage OKL_AE_TMPT_LNES.percentage%TYPE;

Line 1254: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;

1250: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1251: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1252:
1253: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1254: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1255: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1256: l_account_builder_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1257: l_percentage OKL_AE_TMPT_LNES.percentage%TYPE;
1258:

Line 1255: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;

1251: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1252:
1253: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1254: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1255: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1256: l_account_builder_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1257: l_percentage OKL_AE_TMPT_LNES.percentage%TYPE;
1258:
1259: l_okl_application_id NUMBER(3) := 540;

Line 1256: l_account_builder_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;

1252:
1253: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1254: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1255: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1256: l_account_builder_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1257: l_percentage OKL_AE_TMPT_LNES.percentage%TYPE;
1258:
1259: l_okl_application_id NUMBER(3) := 540;
1260: l_document_category VARCHAR2(100):= 'OKL Lease Pay Invoices';

Line 1257: l_percentage OKL_AE_TMPT_LNES.percentage%TYPE;

1253: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1254: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1255: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1256: l_account_builder_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1257: l_percentage OKL_AE_TMPT_LNES.percentage%TYPE;
1258:
1259: l_okl_application_id NUMBER(3) := 540;
1260: l_document_category VARCHAR2(100):= 'OKL Lease Pay Invoices';
1261: lX_dbseqnm VARCHAR2(2000):= '';

Line 1278: OKL_AE_TMPT_LNES C

1274: C.ACCOUNT_BUILDER_YN,
1275: C.PERCENTAGE
1276: FROM OKL_AE_TEMPLATES A,
1277: OKL_PRODUCTS_V B,
1278: OKL_AE_TMPT_LNES C
1279: WHERE A.aes_id = b.aes_id AND
1280: A.start_date <= p_payout_date AND
1281: A.memo_yn = 'N' AND
1282: (A.end_date IS NULL OR