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_JE_CREATION dependencies on CE_STATEMENT_LINES

Line 24: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;

20: -- Statement Lines
21: --
22:
23: csl_rowid VARCHAR2(100);
24: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
25: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
26: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
27: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
28: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;

Line 25: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;

21: --
22:
23: csl_rowid VARCHAR2(100);
24: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
25: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
26: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
27: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
28: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
29: csl_amount CE_STATEMENT_LINES.amount%TYPE;

Line 26: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;

22:
23: csl_rowid VARCHAR2(100);
24: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
25: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
26: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
27: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
28: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
29: csl_amount CE_STATEMENT_LINES.amount%TYPE;
30: csl_currency_code FND_CURRENCIES.currency_code%TYPE;

Line 27: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;

23: csl_rowid VARCHAR2(100);
24: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
25: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
26: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
27: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
28: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
29: csl_amount CE_STATEMENT_LINES.amount%TYPE;
30: csl_currency_code FND_CURRENCIES.currency_code%TYPE;
31: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;

Line 28: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;

24: csl_statement_line_id CE_STATEMENT_LINES.statement_line_id%TYPE;
25: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
26: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
27: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
28: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
29: csl_amount CE_STATEMENT_LINES.amount%TYPE;
30: csl_currency_code FND_CURRENCIES.currency_code%TYPE;
31: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
32: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;

Line 29: csl_amount CE_STATEMENT_LINES.amount%TYPE;

25: csl_trx_date CE_STATEMENT_LINES.trx_date%TYPE;
26: csl_trx_type CE_STATEMENT_LINES.trx_type%TYPE;
27: csl_effective_date CE_STATEMENT_LINES.effective_date%TYPE;
28: csl_trx_code_id CE_STATEMENT_LINES.trx_code_id%TYPE;
29: csl_amount CE_STATEMENT_LINES.amount%TYPE;
30: csl_currency_code FND_CURRENCIES.currency_code%TYPE;
31: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
32: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
33: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;

Line 35: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;

31: csl_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
32: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
33: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
34: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
35: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
36: csl_status CE_STATEMENT_LINES.status%TYPE;
37: csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;
38: csl_trx_text CE_STATEMENT_LINES.trx_text%TYPE;
39: csl_accounting_date DATE;

Line 36: csl_status CE_STATEMENT_LINES.status%TYPE;

32: csl_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
33: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
34: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
35: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
36: csl_status CE_STATEMENT_LINES.status%TYPE;
37: csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;
38: csl_trx_text CE_STATEMENT_LINES.trx_text%TYPE;
39: csl_accounting_date DATE;
40:

Line 37: csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;

33: csl_exchange_rate GL_DAILY_RATES.conversion_rate%TYPE;
34: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
35: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
36: csl_status CE_STATEMENT_LINES.status%TYPE;
37: csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;
38: csl_trx_text CE_STATEMENT_LINES.trx_text%TYPE;
39: csl_accounting_date DATE;
40:
41: -- added for R12

Line 38: csl_trx_text CE_STATEMENT_LINES.trx_text%TYPE;

34: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
35: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;
36: csl_status CE_STATEMENT_LINES.status%TYPE;
37: csl_je_status_flag CE_STATEMENT_LINES.je_status_flag%TYPE;
38: csl_trx_text CE_STATEMENT_LINES.trx_text%TYPE;
39: csl_accounting_date DATE;
40:
41: -- added for R12
42: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;

Line 42: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;

38: csl_trx_text CE_STATEMENT_LINES.trx_text%TYPE;
39: csl_accounting_date DATE;
40:
41: -- added for R12
42: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
43: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
44: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
45: csl_cashflow_id NUMBER(15);
46:

Line 43: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;

39: csl_accounting_date DATE;
40:
41: -- added for R12
42: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
43: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
44: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
45: csl_cashflow_id NUMBER(15);
46:
47:

Line 44: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;

40:
41: -- added for R12
42: csl_bank_trx_number CE_STATEMENT_LINES.bank_trx_number%TYPE;
43: csl_bank_account_text CE_STATEMENT_LINES.bank_account_text%TYPE;
44: csl_customer_text CE_STATEMENT_LINES.customer_text%TYPE;
45: csl_cashflow_id NUMBER(15);
46:
47:
48: --

Line 118: je_entered_cr CE_STATEMENT_LINES.amount%TYPE;

114: je_code_combination_id GL_CODE_COMBINATIONS.code_combination_id%TYPE;
115: je_user_curr_conversion_type GL_DAILY_RATES.conversion_type%TYPE;
116: je_curr_conversion_date GL_DAILY_RATES.conversion_date%TYPE;
117: je_curr_conversion_rate GL_DAILY_RATES.conversion_rate%TYPE;
118: je_entered_cr CE_STATEMENT_LINES.amount%TYPE;
119: je_entered_dr CE_STATEMENT_LINES.amount%TYPE;
120: je_accounted_cr CE_STATEMENT_LINES.amount%TYPE;
121: je_accounted_dr CE_STATEMENT_LINES.amount%TYPE;
122: je_reference6 GL_INTERFACE.reference6%TYPE;

Line 119: je_entered_dr CE_STATEMENT_LINES.amount%TYPE;

115: je_user_curr_conversion_type GL_DAILY_RATES.conversion_type%TYPE;
116: je_curr_conversion_date GL_DAILY_RATES.conversion_date%TYPE;
117: je_curr_conversion_rate GL_DAILY_RATES.conversion_rate%TYPE;
118: je_entered_cr CE_STATEMENT_LINES.amount%TYPE;
119: je_entered_dr CE_STATEMENT_LINES.amount%TYPE;
120: je_accounted_cr CE_STATEMENT_LINES.amount%TYPE;
121: je_accounted_dr CE_STATEMENT_LINES.amount%TYPE;
122: je_reference6 GL_INTERFACE.reference6%TYPE;
123: je_reference10 GL_INTERFACE.reference10%TYPE;

Line 120: je_accounted_cr CE_STATEMENT_LINES.amount%TYPE;

116: je_curr_conversion_date GL_DAILY_RATES.conversion_date%TYPE;
117: je_curr_conversion_rate GL_DAILY_RATES.conversion_rate%TYPE;
118: je_entered_cr CE_STATEMENT_LINES.amount%TYPE;
119: je_entered_dr CE_STATEMENT_LINES.amount%TYPE;
120: je_accounted_cr CE_STATEMENT_LINES.amount%TYPE;
121: je_accounted_dr CE_STATEMENT_LINES.amount%TYPE;
122: je_reference6 GL_INTERFACE.reference6%TYPE;
123: je_reference10 GL_INTERFACE.reference10%TYPE;
124: je_reference21 GL_INTERFACE.reference21%TYPE;

Line 121: je_accounted_dr CE_STATEMENT_LINES.amount%TYPE;

117: je_curr_conversion_rate GL_DAILY_RATES.conversion_rate%TYPE;
118: je_entered_cr CE_STATEMENT_LINES.amount%TYPE;
119: je_entered_dr CE_STATEMENT_LINES.amount%TYPE;
120: je_accounted_cr CE_STATEMENT_LINES.amount%TYPE;
121: je_accounted_dr CE_STATEMENT_LINES.amount%TYPE;
122: je_reference6 GL_INTERFACE.reference6%TYPE;
123: je_reference10 GL_INTERFACE.reference10%TYPE;
124: je_reference21 GL_INTERFACE.reference21%TYPE;
125: je_accounted_amt CE_STATEMENT_LINES.amount%TYPE;

Line 125: je_accounted_amt CE_STATEMENT_LINES.amount%TYPE;

121: je_accounted_dr CE_STATEMENT_LINES.amount%TYPE;
122: je_reference6 GL_INTERFACE.reference6%TYPE;
123: je_reference10 GL_INTERFACE.reference10%TYPE;
124: je_reference21 GL_INTERFACE.reference21%TYPE;
125: je_accounted_amt CE_STATEMENT_LINES.amount%TYPE;
126: je_entered_amt CE_STATEMENT_LINES.amount%TYPE;
127: */
128:
129: procedure create_journal( errbuf OUT NOCOPY VARCHAR2,

Line 126: je_entered_amt CE_STATEMENT_LINES.amount%TYPE;

122: je_reference6 GL_INTERFACE.reference6%TYPE;
123: je_reference10 GL_INTERFACE.reference10%TYPE;
124: je_reference21 GL_INTERFACE.reference21%TYPE;
125: je_accounted_amt CE_STATEMENT_LINES.amount%TYPE;
126: je_entered_amt CE_STATEMENT_LINES.amount%TYPE;
127: */
128:
129: procedure create_journal( errbuf OUT NOCOPY VARCHAR2,
130: retcode OUT NOCOPY NUMBER,