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_BC_PACKETS

Line 250: 197 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BC_PACKETS'

246: 0 SELECT STATEMENT HINT: RULE
247: 165 SORT (AGGREGATE)
248: 165 NESTED LOOPS
249: 139 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BC_PACKET_ARRIVAL_ORDER_U3' (UNIQUE)
250: 197 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BC_PACKETS'
251: 335 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BC_PACKETS_N2' (NON-UNIQUE)
252: */
253:
254: CURSOR c_packets IS

Line 251: 335 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BC_PACKETS_N2' (NON-UNIQUE)

247: 165 SORT (AGGREGATE)
248: 165 NESTED LOOPS
249: 139 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BC_PACKET_ARRIVAL_ORDER_U3' (UNIQUE)
250: 197 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BC_PACKETS'
251: 335 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BC_PACKETS_N2' (NON-UNIQUE)
252: */
253:
254: CURSOR c_packets IS
255: SELECT

Line 271: gl_bc_packets pac, gl_bc_packet_arrival_order arr

267: decode(encumbrance_type_id,
268: nvl(x_po_encumbrance_id,-2),
269: nvl(accounted_dr,0) - nvl(accounted_cr,0),0),0)),0)
270: FROM
271: gl_bc_packets pac, gl_bc_packet_arrival_order arr
272: WHERE
273: pac.code_combination_id = x_code_combination_id
274: and pac.currency_code = decode(pac.actual_flag, 'B', x_currency_code, pac.currency_code)
275: and pac.currency_code <> 'STAT'

Line 536: 197 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BC_PACKETS'

532: 0 SELECT STATEMENT HINT: RULE
533: 165 SORT (AGGREGATE)
534: 165 NESTED LOOPS
535: 139 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BC_PACKET_ARRIVAL_ORDER_U3' (UNIQUE)
536: 197 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BC_PACKETS'
537: 335 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BC_PACKETS_N2' (NON-UNIQUE)
538: */
539:
540: CURSOR c_packets IS

Line 537: 335 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BC_PACKETS_N2' (NON-UNIQUE)

533: 165 SORT (AGGREGATE)
534: 165 NESTED LOOPS
535: 139 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BC_PACKET_ARRIVAL_ORDER_U3' (UNIQUE)
536: 197 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BC_PACKETS'
537: 335 INDEX HINT: ANALYZED (RANGE SCAN) OF 'GL_BC_PACKETS_N2' (NON-UNIQUE)
538: */
539:
540: CURSOR c_packets IS
541: SELECT

Line 557: gl_bc_packets pac, gl_bc_packet_arrival_order arr

553: decode(encumbrance_type_id,
554: nvl(x_po_encumbrance_id,-2),
555: nvl(accounted_dr,0) - nvl(accounted_cr,0),0),0)),0)
556: FROM
557: gl_bc_packets pac, gl_bc_packet_arrival_order arr
558: WHERE
559: pac.code_combination_id = x_code_combination_id
560: and pac.currency_code = decode(pac.actual_flag, 'B', x_currency_code, pac.currency_code)
561: and pac.currency_code <> 'STAT'