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 GL_DAILY_RATES

Line 31: csl_exchange_rate_type GL_DAILY_RATES.conversion_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;
34: csl_match_found FND_LOOKUP_VALUES.lookup_code%TYPE;
35: csl_original_amount CE_STATEMENT_LINES.original_amount%TYPE;

Line 32: csl_exchange_rate_date GL_DAILY_RATES.conversion_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;
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;

Line 33: csl_exchange_rate GL_DAILY_RATES.conversion_rate%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;
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;

Line 56: jem_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;

52: jem_trx_code_id CE_TRANSACTION_CODES.transaction_code_id%TYPE;
53: jem_search_string_txt CE_JE_MAPPINGS.search_string_txt%TYPE;
54: jem_gl_account_ccid CE_JE_MAPPINGS.gl_account_ccid%TYPE;
55: jem_reference_txt CE_JE_MAPPINGS.REFERENCE_TXT%TYPE;
56: jem_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
57: jem_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
58:
59: -- added for R12
60: jem_trxn_subtype_code_id CE_JE_MAPPINGS.trxn_subtype_code_id%TYPE;

Line 57: jem_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;

53: jem_search_string_txt CE_JE_MAPPINGS.search_string_txt%TYPE;
54: jem_gl_account_ccid CE_JE_MAPPINGS.gl_account_ccid%TYPE;
55: jem_reference_txt CE_JE_MAPPINGS.REFERENCE_TXT%TYPE;
56: jem_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
57: jem_exchange_rate_date GL_DAILY_RATES.conversion_date%TYPE;
58:
59: -- added for R12
60: jem_trxn_subtype_code_id CE_JE_MAPPINGS.trxn_subtype_code_id%TYPE;
61:

Line 71: sys_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;

67: --
68: -- CE system parameters variables
69: --
70: sys_currency_code FND_CURRENCIES.currency_code%TYPE;
71: sys_exchange_rate_type GL_DAILY_RATES.conversion_type%TYPE;
72: sys_exchange_rate_date VARCHAR2(10); --CE_SYSTEM_PARAMETERS.exchange_rate_date%TYPE;
73: sys_sob_id GL_SETS_OF_BOOKS.set_of_books_id%TYPE;
74:
75: --

Line 115: je_user_curr_conversion_type GL_DAILY_RATES.conversion_type%TYPE;

111: je_currency_code FND_CURRENCIES.currency_code%TYPE;
112: je_date_created DATE;
113: je_created_by NUMBER;
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;

Line 116: je_curr_conversion_date GL_DAILY_RATES.conversion_date%TYPE;

112: je_date_created DATE;
113: je_created_by NUMBER;
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;

Line 117: je_curr_conversion_rate GL_DAILY_RATES.conversion_rate%TYPE;

113: je_created_by NUMBER;
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;