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 251: 197 TABLE ACCESS HINT: ANALYZED (BY ROWID) OF 'GL_BC_PACKETS'

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

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

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

Line 272: gl_bc_packets pac, gl_bc_packet_arrival_order arr

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

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

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

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

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

Line 558: gl_bc_packets pac, gl_bc_packet_arrival_order arr

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