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.GL_FUNDS_AVAILABLE_PKG dependencies on GL_BALANCES

Line 144: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'

140: ------- ---------------------------------------------------
141: 0 SELECT STATEMENT HINT: RULE
142: 2 SORT (AGGREGATE)
143: 0 CONCATENATION
144: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
145: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
146: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
147: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
148: */

Line 145: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)

141: 0 SELECT STATEMENT HINT: RULE
142: 2 SORT (AGGREGATE)
143: 0 CONCATENATION
144: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
145: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
146: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
147: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
148: */
149:

Line 146: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'

142: 2 SORT (AGGREGATE)
143: 0 CONCATENATION
144: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
145: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
146: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
147: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
148: */
149:
150:

Line 147: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)

143: 0 CONCATENATION
144: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
145: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
146: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
147: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
148: */
149:
150:
151: CURSOR c_balances IS

Line 223: gl_balances bal

219: 'PJTD',
220: nvl(project_to_date_dr,0) - nvl(project_to_date_cr,0),
221: 0),0),0),0)),0)
222: FROM
223: gl_balances bal
224: WHERE
225: bal.ledger_id = x_ledger_id
226: and bal.code_combination_id = x_code_combination_id
227: --and bal.currency_code = decode(actual_flag, 'B', x_currency_code, bal.currency_code)

Line 497: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'

493: ------- ---------------------------------------------------
494: 0 SELECT STATEMENT HINT: RULE
495: 2 SORT (AGGREGATE)
496: 0 CONCATENATION
497: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
498: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
499: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
500: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
501: */

Line 498: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)

494: 0 SELECT STATEMENT HINT: RULE
495: 2 SORT (AGGREGATE)
496: 0 CONCATENATION
497: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
498: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
499: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
500: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
501: */
502:

Line 499: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'

495: 2 SORT (AGGREGATE)
496: 0 CONCATENATION
497: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
498: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
499: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
500: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
501: */
502:
503:

Line 500: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)

496: 0 CONCATENATION
497: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
498: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
499: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'
500: 7 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BALANCES_N1' (NON-UNIQUE)
501: */
502:
503:
504: CURSOR c_balances IS

Line 514: gl_balances bal

510: nvl(x_req_encumbrance_id,-2), nvl(period_net_dr,0) - nvl(period_net_cr,0)))),0),
511: nvl(sum(decode(actual_flag, 'E', decode(encumbrance_type_id,
512: nvl(x_po_encumbrance_id,-2), nvl(period_net_dr,0) - nvl(period_net_cr,0)))),0)
513: FROM
514: gl_balances bal
515: WHERE
516: bal.ledger_id = x_ledger_id
517: and bal.code_combination_id = x_code_combination_id
518: --and bal.currency_code = decode(actual_flag, 'B', x_currency_code, bal.currency_code)