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.CE_ZBA_DEAL_GENERATION dependencies on CE_STATEMENT_LINES

Line 26: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;

22: --
23: -- Statement Lines
24: --
25: csl_rowid VARCHAR2(100);
26: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
27: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;

Line 27: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;

23: -- Statement Lines
24: --
25: csl_rowid VARCHAR2(100);
26: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
27: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;

Line 28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;

24: --
25: csl_rowid VARCHAR2(100);
26: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
27: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;

Line 29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;

25: csl_rowid VARCHAR2(100);
26: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
27: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;

Line 30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;

26: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
27: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;

Line 31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;

27: csl_line_number CE_STATEMENT_LINES.line_number%TYPE;
28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;

Line 32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;

28: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
36: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;

Line 33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;

29: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
36: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
37: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;

Line 34: csl_amount CE_STATEMENT_LINES.amount%TYPE;

30: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
36: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
37: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
38: csl_receivables_trx_id CE_TRANSACTION_CODES.receivables_trx_id%TYPE;

Line 35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;

31: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
36: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
37: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
38: csl_receivables_trx_id CE_TRANSACTION_CODES.receivables_trx_id%TYPE;
39: csl_receipt_method_id CE_TRANSACTION_CODES.receipt_method_id%TYPE;

Line 36: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;

32: csl_invoice_text CE_STATEMENT_LINES.invoice_text%TYPE;
33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
36: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
37: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
38: csl_receivables_trx_id CE_TRANSACTION_CODES.receivables_trx_id%TYPE;
39: csl_receipt_method_id CE_TRANSACTION_CODES.receipt_method_id%TYPE;
40: csl_create_misc_trx_flag CE_TRANSACTION_CODES.create_misc_trx_flag%TYPE;

Line 37: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;

33: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
34: csl_amount CE_STATEMENT_LINES.amount%TYPE;
35: csl_charges_amount CE_STATEMENT_LINES.charges_amount%TYPE;
36: corr_csl_amount CE_STATEMENT_LINES.amount%TYPE;
37: calc_csl_amount CE_STATEMENT_LINES.amount%TYPE;
38: csl_receivables_trx_id CE_TRANSACTION_CODES.receivables_trx_id%TYPE;
39: csl_receipt_method_id CE_TRANSACTION_CODES.receipt_method_id%TYPE;
40: csl_create_misc_trx_flag CE_TRANSACTION_CODES.create_misc_trx_flag%TYPE;
41: csl_matching_against CE_TRANSACTION_CODES.matching_against%TYPE;

Line 46: csl_line_trx_type CE_STATEMENT_LINES.trx_type%TYPE;

42: csl_correction_method CE_TRANSACTION_CODES.correction_method%TYPE;
43: csl_reconcile_flag CE_TRANSACTION_CODES.reconcile_flag%TYPE;
44: csl_receipt_method_name AR_RECEIPT_METHODS.name%TYPE;
45: csl_currency_code FND_CURRENCIES.currency_code%TYPE;
46: csl_line_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
47: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
48: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
49: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
50: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;

Line 51: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;

47: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
48: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
49: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
50: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
51: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
52: csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;
53: csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%TYPE;
54: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
55: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;

Line 54: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;

50: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
51: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
52: csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;
53: csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%TYPE;
54: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
55: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
56: reconcile_to_statement_flag CE_STATEMENT_LINES.reconcile_to_statement_flag%TYPE;
57: csl_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
58: --

Line 55: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;

51: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
52: csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;
53: csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%TYPE;
54: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
55: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
56: reconcile_to_statement_flag CE_STATEMENT_LINES.reconcile_to_statement_flag%TYPE;
57: csl_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
58: --
59: -- Passed as parameters

Line 56: reconcile_to_statement_flag CE_STATEMENT_LINES.reconcile_to_statement_flag%TYPE;

52: csl_payroll_payment_format PAY_PAYMENT_TYPES.payment_type_name%TYPE;
53: csl_clearing_trx_type FND_LOOKUP_VALUES.lookup_code%TYPE;
54: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
55: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
56: reconcile_to_statement_flag CE_STATEMENT_LINES.reconcile_to_statement_flag%TYPE;
57: csl_match_type FND_LOOKUP_VALUES.lookup_code%TYPE;
58: --
59: -- Passed as parameters
60: --