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 496: 6 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BALANCES'

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

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

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

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

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

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

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

Line 513: gl_balances bal

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