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.XLA_BALANCES_CALC_PKG dependencies on XLA_AE_LINES

Line 228: , xla_ae_lines xal

224: g_ledger_array
225: , g_application_array
226: , g_accounting_batch_array
227: FROM xla_ae_headers xah
228: , xla_ae_lines xal
229: , gl_period_statuses gps
230: , xla_ledger_relationships_v xlr
231: WHERE xah.application_id = p_application_id
232: AND xah.ledger_id = p_ledger_id

Line 531: , xla_ae_lines ael

527: , $period_balance_dr$
528: , $period_balance_cr$
529: , SUBSTR (gps.effective_period_num, 1, 4) period_year
530: FROM xla_ae_headers aeh
531: , xla_ae_lines ael
532: , xla_ae_line_acs acs
533: , xla_analytical_hdrs_b xbh
534: , gl_period_statuses gps
535: , xla_ledger_options xlo

Line 1359: --update records being processed to 'y' in xla_ae_lines

1355: );
1356: END IF;
1357:
1358: --
1359: --update records being processed to 'y' in xla_ae_lines
1360: --
1361:
1362: l_update_processed := 'UPDATE /*+ use_nl(ael) */xla_ae_lines ael
1363: SET analytical_balance_flag = '''||g_postupdate_flag||'''

Line 1362: l_update_processed := 'UPDATE /+ use_nl(ael) /xla_ae_lines ael

1358: --
1359: --update records being processed to 'y' in xla_ae_lines
1360: --
1361:
1362: l_update_processed := 'UPDATE /*+ use_nl(ael) */xla_ae_lines ael
1363: SET analytical_balance_flag = '''||g_postupdate_flag||'''
1364: WHERE application_id = :'||l_processed_bind_count||'
1365: AND analytical_balance_flag = '''||g_preupdate_flag||'''
1366: AND (ae_header_id,ae_line_num) IN

Line 1371: , xla_ae_lines ael

1367: ( SELECT /*+ $parallel$ leading(aeh) */
1368: ael.ae_header_id
1369: ,ael.ae_line_num
1370: FROM xla_ae_headers aeh
1371: , xla_ae_lines ael
1372: , gl_period_statuses gps
1373: , xla_ledger_options xlo
1374: , xla_ledger_relationships_v xlr
1375: $bal_concurrency$

Line 1543: , p_msg => '# Rows update in xla_ae_lines' || l_update2_count

1539:
1540: IF (c_level_procedure >= g_log_level)
1541: THEN
1542: TRACE (p_module => l_log_module
1543: , p_msg => '# Rows update in xla_ae_lines' || l_update2_count
1544: , p_level => c_level_procedure
1545: );
1546: END IF;
1547:

Line 1633: , xla_ae_lines ael

1629: , $period_balance_dr$
1630: , $period_balance_cr$
1631: , SUBSTR (gps.effective_period_num, 1, 4) period_year
1632: FROM xla_ae_headers aeh
1633: , xla_ae_lines ael
1634: , gl_period_statuses gps
1635: , xla_ledger_options xlo
1636: , xla_ledger_relationships_v xlr
1637: $bal_concurrency$

Line 2332: --update records processed to 'Y' in xla_ae_lines

2328: );
2329: END IF;
2330:
2331: --
2332: --update records processed to 'Y' in xla_ae_lines
2333: --
2334: l_update_processed := 'UPDATE /*+ use_nl(ael) */xla_ae_lines ael
2335: SET control_balance_flag = '''||g_postupdate_flag||'''
2336: WHERE application_id = :'||l_processed_bind_count||'

Line 2334: l_update_processed := 'UPDATE /+ use_nl(ael) /xla_ae_lines ael

2330:
2331: --
2332: --update records processed to 'Y' in xla_ae_lines
2333: --
2334: l_update_processed := 'UPDATE /*+ use_nl(ael) */xla_ae_lines ael
2335: SET control_balance_flag = '''||g_postupdate_flag||'''
2336: WHERE application_id = :'||l_processed_bind_count||'
2337: AND control_balance_flag = '''||g_preupdate_flag||'''
2338: AND (ae_header_id,ae_line_num) IN ( SELECT /*+ $parallel$ leading(aeh) */

Line 2342: , xla_ae_lines ael

2338: AND (ae_header_id,ae_line_num) IN ( SELECT /*+ $parallel$ leading(aeh) */
2339: ael.ae_header_id
2340: ,ael.ae_line_num
2341: FROM xla_ae_headers aeh
2342: , xla_ae_lines ael
2343: , gl_period_statuses gps
2344: , xla_ledger_options xlo
2345: , xla_ledger_relationships_v xlr
2346: $bal_concurrency$

Line 2517: , p_msg => ' # rows updated in xla_ae_lines : ' || l_update2_count

2513: --
2514: IF (c_level_procedure >= g_log_level)
2515: THEN
2516: TRACE (p_module => l_log_module
2517: , p_msg => ' # rows updated in xla_ae_lines : ' || l_update2_count
2518: , p_level => c_level_procedure
2519: );
2520: END IF;
2521: --

Line 4911: from xla_ae_lines xal

4907: END IF;
4908: l_query := 'SELECT count(1)
4909: FROM dual
4910: where exists(select 1
4911: from xla_ae_lines xal
4912: ,xla_ae_line_acs xac
4913: ,gl_period_statuses gps1
4914: ,gl_period_statuses gps2
4915: ,xla_ae_headers xah