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_HIST_LEDGER_UPG_PKG dependencies on XLA_AE_LINES

Line 674: FROM xla_ae_lines

670:
671: IF l_lines_insert = TRUE THEN
672:
673: DELETE
674: FROM xla_ae_lines
675: WHERE request_id = l_upgrade_id;
676:
677: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
678: trace

Line 679: (p_msg => 'deleted rows from xla_ae_lines = ' || SQL%ROWCOUNT

675: WHERE request_id = l_upgrade_id;
676:
677: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
678: trace
679: (p_msg => 'deleted rows from xla_ae_lines = ' || SQL%ROWCOUNT
680: ,p_level => C_LEVEL_PROCEDURE
681: ,p_module => l_log_module);
682: END IF;
683: COMMIT;

Line 1057: FROM xla_ae_lines l

1053:
1054: CURSOR c_entered_currencies
1055: IS
1056: SELECT distinct(l.currency_code)
1057: FROM xla_ae_lines l
1058: WHERE exists
1059: (SELECT 1
1060: FROM xla_ae_headers h
1061: WHERE h.ledger_id = l_primary_ledger_id

Line 1898: (p_msg => 'xla_ae_headers insert SQL end and xla_ae_lines SQL start: ' || l_sql_time

1894: FROM dual;
1895:
1896:
1897: trace
1898: (p_msg => 'xla_ae_headers insert SQL end and xla_ae_lines SQL start: ' || l_sql_time
1899: ,p_level => C_LEVEL_PROCEDURE
1900: ,p_module => l_log_module);
1901: END IF;
1902:

Line 1907: INSERT /+ append / INTO XLA_AE_LINES

1903:
1904:
1905:
1906:
1907: INSERT /*+ append */ INTO XLA_AE_LINES
1908: ( AE_HEADER_ID
1909: , AE_LINE_NUM
1910: , APPLICATION_ID
1911: , CODE_COMBINATION_ID

Line 2109: ,XLA_AE_LINES XAL

2105: , XAL.SOURCE_TABLE
2106: , XAL.SOURCE_ID
2107: , XAL.ACCOUNT_OVERLAY_SOURCE_ID
2108: FROM XLA_AE_HEADERS XAH
2109: ,XLA_AE_LINES XAL
2110: ,XLA_RC_UPGRADE_RATES XRUR
2111: WHERE
2112: XAH.ledger_id = l_secondary_alc_ledger_id
2113: AND XAL.ledger_id = l_primary_ledger_id

Line 2131: (p_msg => 'Rows inserted into xla_ae_lines: ' || SQL%ROWCOUNT

2127:
2128:
2129: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2130: trace
2131: (p_msg => 'Rows inserted into xla_ae_lines: ' || SQL%ROWCOUNT
2132: ,p_level => C_LEVEL_PROCEDURE
2133: ,p_module => l_log_module);
2134:
2135: END IF;

Line 2149: (p_msg => 'xla_ae_lines insert SQL end: ' || l_sql_time

2145: INTO l_sql_time
2146: FROM dual;
2147:
2148: trace
2149: (p_msg => 'xla_ae_lines insert SQL end: ' || l_sql_time
2150: ,p_level => C_LEVEL_PROCEDURE
2151: ,p_module => l_log_module);
2152: END IF;
2153:

Line 2384: (p_msg => 'xla_ae_headers insert SQL end and xla_ae_lines SQL start: ' || l_sql_time

2380: FROM dual;
2381:
2382:
2383: trace
2384: (p_msg => 'xla_ae_headers insert SQL end and xla_ae_lines SQL start: ' || l_sql_time
2385: ,p_level => C_LEVEL_PROCEDURE
2386: ,p_module => l_log_module);
2387: END IF;
2388:

Line 2393: INSERT /+ append / INTO XLA_AE_LINES

2389:
2390:
2391:
2392:
2393: INSERT /*+ append */ INTO XLA_AE_LINES
2394: ( AE_HEADER_ID
2395: , AE_LINE_NUM
2396: , APPLICATION_ID
2397: , CODE_COMBINATION_ID

Line 2595: ,XLA_AE_LINES XAL

2591: , XAL.SOURCE_TABLE
2592: , XAL.SOURCE_ID
2593: , XAL.ACCOUNT_OVERLAY_SOURCE_ID
2594: FROM XLA_AE_HEADERS XAH
2595: ,XLA_AE_LINES XAL
2596: ,XLA_RC_UPGRADE_RATES XRUR
2597: WHERE
2598: XAH.ledger_id = l_secondary_alc_ledger_id
2599: AND XAL.ledger_id = l_primary_ledger_id

Line 2616: (p_msg => 'Rows inserted into xla_ae_lines: ' || SQL%ROWCOUNT

2612:
2613:
2614: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2615: trace
2616: (p_msg => 'Rows inserted into xla_ae_lines: ' || SQL%ROWCOUNT
2617: ,p_level => C_LEVEL_PROCEDURE
2618: ,p_module => l_log_module);
2619:
2620: END IF;

Line 2634: (p_msg => 'xla_ae_lines insert SQL end: ' || l_sql_time

2630: INTO l_sql_time
2631: FROM dual;
2632:
2633: trace
2634: (p_msg => 'xla_ae_lines insert SQL end: ' || l_sql_time
2635: ,p_level => C_LEVEL_PROCEDURE
2636: ,p_module => l_log_module);
2637: END IF;
2638:

Line 2728: FROM xla_ae_lines xal

2724:
2725:
2726: INSERT INTO gl_accts_map_int_gt(coa_mapping_id, from_ccid)
2727: SELECT distinct l_mapping_relationship_id, code_combination_id
2728: FROM xla_ae_lines xal
2729: WHERE XAL.gain_or_loss_flag <> 'Y'
2730: AND EXISTS (SELECT 1
2731: FROM xla_ae_headers xah
2732: WHERE xah.ae_header_id = xal.ae_header_id

Line 2908: FROM xla_ae_lines

2904: DELETE FROM gl_accts_map_int_gt; -- bug 4564062
2905:
2906: INSERT INTO gl_accts_map_int_gt(coa_mapping_id, from_ccid)
2907: SELECT distinct l_mapping_relationship_id, code_combination_id
2908: FROM xla_ae_lines
2909: WHERE request_id = l_upgrade_id;
2910:
2911:
2912:

Line 2941: UPDATE xla_ae_lines xal

2937: ,p_module => l_log_module);
2938: END IF;
2939:
2940:
2941: UPDATE xla_ae_lines xal
2942: SET code_combination_id = (SELECT (nvl(gl_int.to_ccid, -1))
2943: FROM gl_accts_map_int_gt gl_int
2944: WHERE xal.code_combination_id = gl_int.from_ccid
2945: AND gl_int.coa_mapping_id = l_mapping_relationship_id)

Line 2975: FROM xla_ae_lines

2971: SELECT 1
2972: INTO l_ccid_check
2973: FROM DUAL
2974: WHERE EXISTS (SELECT 1
2975: FROM xla_ae_lines
2976: WHERE code_combination_id = -1
2977: AND request_id = l_upgrade_id);
2978:
2979:

Line 3190: FROM xla_ae_lines xal

3186: AND XAH.ledger_id = l_primary_ledger_id
3187: AND XAH.accounting_entry_status_code = 'F'
3188: AND XAH.balance_type_code in ('A', 'E')
3189: AND EXISTS (SELECT 1
3190: FROM xla_ae_lines xal
3191: WHERE xal.ae_header_id = xah.ae_header_id
3192: AND xal.gain_or_loss_flag = 'Y'
3193: AND xah.application_id = xal.application_id);
3194:

Line 3226: UPDATE xla_ae_lines xx

3222: IF (l_array_gain_loss_header.COUNT > 0) THEN
3223:
3224:
3225: FORALL i IN 1..l_array_gain_loss_header.COUNT
3226: UPDATE xla_ae_lines xx
3227: SET displayed_line_number = (SELECT new_line from
3228: (SELECT ae_header_id,
3229: decode(nvl(accounted_cr, 0) + nvl(accounted_dr, 0), 0, -1, 1) *
3230: (ROW_NUMBER() over (PARTITION BY ae_header_id order by

Line 3236: FROM xla_ae_lines

3232: abs(nvl(accounted_dr, 0) + nvl(accounted_cr, 0)) desc,
3233: SIGN(nvl(accounted_dr, 0) + nvl(accounted_cr, 0)) desc)) new_line,
3234: ae_line_num,
3235: displayed_line_number
3236: FROM xla_ae_lines
3237: WHERE request_id = l_upgrade_id
3238: AND upg_batch_id = l_array_gain_loss_header(i)
3239: ) yy
3240: WHERE yy.ae_header_id = xx.ae_header_id

Line 3519: ,XLA_AE_LINES XAL

3515: , XDL.ALLOC_TO_DIST_ID_CHAR_4
3516: , XDL.ALLOC_TO_DIST_ID_CHAR_5
3517: , l_upgrade_id -- concurrent request id stored in column XDL.GAIN_OR_LOSS_REF
3518: FROM XLA_DISTRIBUTION_LINKS XDL
3519: ,XLA_AE_LINES XAL
3520: WHERE
3521: XAL.upg_batch_id = XDL.ae_header_id
3522: AND XAL.ledger_id = l_secondary_alc_ledger_id
3523: AND XAL.accounting_date >= l_start_date

Line 3681: FROM xla_ae_lines

3677:
3678: CURSOR c_validate_lines
3679: IS
3680: SELECT ae_header_id
3681: FROM xla_ae_lines
3682: WHERE request_id = l_upgrade_id
3683: GROUP BY ae_header_id
3684: HAVING sum(entered_cr) <> sum(entered_dr)
3685: OR sum(accounted_dr) <> sum(accounted_cr)

Line 3720: FROM xla_ae_lines

3716: SELECT 1
3717: INTO l_error_lines
3718: FROM DUAL
3719: WHERE EXISTS (SELECT 1
3720: FROM xla_ae_lines
3721: WHERE request_id = l_upgrade_id
3722: GROUP BY ae_header_id
3723: HAVING sum(entered_cr) <> sum(entered_dr)
3724: OR sum(accounted_dr) <> sum(accounted_cr)