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.JG_JOURNAL_ALLOCATIONS_PKG dependencies on JG_ZZ_TA_CC_RANGES

Line 210: , jg_zz_ta_cc_ranges ccr

206: , COUNT(*) total_num_of_lines
207: , SUM(DECODE(rl.offset_account, NULL, 0, 1)) total_num_of_offsets
208: FROM jg_zz_ta_rule_lines rl
209: , jg_zz_ta_account_ranges acr
210: , jg_zz_ta_cc_ranges ccr
211: , jg_zz_ta_rule_sets rs
212: WHERE rs.rule_set_id = ccr.rule_set_id
213: AND ccr.cc_range_id = acr.cc_range_id
214: AND acr.account_range_id = rl.account_range_id (+)

Line 223: TYPE ACCOUNT_RANGE_LINE IS RECORD(cc_range_low jg_zz_ta_cc_ranges.cc_range_low%TYPE

219: , acr.account_range_low
220: , acr.account_range_high
221: , acr.offset_account
222: , acr.account_range_id;
223: TYPE ACCOUNT_RANGE_LINE IS RECORD(cc_range_low jg_zz_ta_cc_ranges.cc_range_low%TYPE
224: ,cc_range_high jg_zz_ta_cc_ranges.cc_range_high%TYPE
225: ,account_range_low jg_zz_ta_account_ranges.account_range_low%TYPE
226: ,account_range_high jg_zz_ta_account_ranges.account_range_high%TYPE);
227: TYPE ACCOUNT_RANGE_TABLE IS TABLE OF ACCOUNT_RANGE_LINE INDEX BY BINARY_INTEGER;

Line 224: ,cc_range_high jg_zz_ta_cc_ranges.cc_range_high%TYPE

220: , acr.account_range_high
221: , acr.offset_account
222: , acr.account_range_id;
223: TYPE ACCOUNT_RANGE_LINE IS RECORD(cc_range_low jg_zz_ta_cc_ranges.cc_range_low%TYPE
224: ,cc_range_high jg_zz_ta_cc_ranges.cc_range_high%TYPE
225: ,account_range_low jg_zz_ta_account_ranges.account_range_low%TYPE
226: ,account_range_high jg_zz_ta_account_ranges.account_range_high%TYPE);
227: TYPE ACCOUNT_RANGE_TABLE IS TABLE OF ACCOUNT_RANGE_LINE INDEX BY BINARY_INTEGER;
228: l_acct_range_arr ACCOUNT_RANGE_TABLE;