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

Line 1183: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;

1179: l_currency_conv_type okl_k_headers_full_v.currency_conversion_type%TYPE;
1180: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1181: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1182:
1183: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1184: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1185: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1186: l_account_builder_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1187: l_percentage OKL_AE_TMPT_LNES.percentage%TYPE;

Line 1184: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;

1180: l_currency_conv_rate okl_k_headers_full_v.currency_conversion_rate%TYPE;
1181: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1182:
1183: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1184: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1185: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1186: l_account_builder_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1187: l_percentage OKL_AE_TMPT_LNES.percentage%TYPE;
1188:

Line 1185: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;

1181: l_currency_conv_date okl_k_headers_full_v.currency_conversion_date%TYPE;
1182:
1183: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1184: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1185: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1186: l_account_builder_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1187: l_percentage OKL_AE_TMPT_LNES.percentage%TYPE;
1188:
1189: l_okl_application_id NUMBER(3) := 540;

Line 1186: l_account_builder_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;

1182:
1183: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1184: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1185: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1186: l_account_builder_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1187: l_percentage OKL_AE_TMPT_LNES.percentage%TYPE;
1188:
1189: l_okl_application_id NUMBER(3) := 540;
1190: l_document_category VARCHAR2(100):= 'OKL Lease Pay Invoices';

Line 1187: l_percentage OKL_AE_TMPT_LNES.percentage%TYPE;

1183: l_code_combination_id OKL_AE_TMPT_LNES.code_combination_id%TYPE;
1184: l_ae_line_type OKL_AE_TMPT_LNES.ae_line_type%TYPE;
1185: l_crd_code OKL_AE_TMPT_LNES.crd_code%TYPE;
1186: l_account_builder_yn OKL_AE_TMPT_LNES.account_builder_yn%TYPE;
1187: l_percentage OKL_AE_TMPT_LNES.percentage%TYPE;
1188:
1189: l_okl_application_id NUMBER(3) := 540;
1190: l_document_category VARCHAR2(100):= 'OKL Lease Pay Invoices';
1191: lX_dbseqnm VARCHAR2(2000):= '';

Line 1208: OKL_AE_TMPT_LNES C

1204: C.ACCOUNT_BUILDER_YN,
1205: C.PERCENTAGE
1206: FROM OKL_AE_TEMPLATES A,
1207: OKL_PRODUCTS_V B,
1208: OKL_AE_TMPT_LNES C
1209: WHERE A.aes_id = b.aes_id AND
1210: A.start_date <= p_payout_date AND
1211: A.memo_yn = 'N' AND
1212: (A.end_date IS NULL OR