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_AE_JOURNAL_ENTRY_PKG dependencies on XLA_AE_LINES_GT

Line 32: | xla_ae_lines_gt, xla_je_headers_gt by |

28: | 05-MAI-2003 K.Boussema Modified to fix bug 2926949 |
29: | Added sla_ledger_id in ledger cache |
30: | 07-MAI-2003 K.Boussema Changed the call to cache API, bug 2945359 |
31: | 13-MAI-2003 K.Boussema Renamed temporary tables xla_je_lines_gt by |
32: | xla_ae_lines_gt, xla_je_headers_gt by |
33: | xla_ae_headers_gt |
34: | Renamed in xla_distribution_links the column |
35: | base_amount by ledger_amount |
36: | 14-MAI-2003 K.Boussema Removed the SELECT of application_name |

Line 1552: FROM xla_ae_lines_gt xalg

1548: ,ae_header_id
1549: ,NVL(SUM(unrounded_entered_cr), 0)
1550: - NVL(SUM(unrounded_entered_dr), 0) unrounded_entered_amount
1551: ,entered_currency_mau
1552: FROM xla_ae_lines_gt xalg
1553: WHERE temp_line_num <> 0
1554: GROUP BY ledger_id, event_id, ae_header_id,
1555: rounding_class_code, document_rounding_level, ae_line_num
1556: ,entered_currency_mau

Line 1588: (p_msg => 'SQL - Update xla_ae_lines_gt'

1584:
1585: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1586:
1587: trace
1588: (p_msg => 'SQL - Update xla_ae_lines_gt'
1589: ,p_level => C_LEVEL_STATEMENT
1590: ,p_module => l_log_module);
1591:
1592: END IF;

Line 1596: update xla_ae_lines_gt ael

1592: END IF;
1593:
1594: IF g_array_event_id.count > 0 then
1595: forall i in 1..g_array_event_id.count
1596: update xla_ae_lines_gt ael
1597: set ae_header_id = g_array_ae_header_id(i)
1598: ,ref_ae_header_id = DECODE(ref_event_id,NULL,g_array_ae_header_id(i),ref_ae_header_id)
1599: /* Calling get_hash_value for each row is expensive.
1600: Moved the columns to the select statement to retrieve ae_line_num.

Line 1754: (p_msg => 'SQL - Update xla_ae_lines_gt 2'

1750:
1751: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1752:
1753: trace
1754: (p_msg => 'SQL - Update xla_ae_lines_gt 2'
1755: ,p_level => C_LEVEL_STATEMENT
1756: ,p_module => l_log_module);
1757:
1758: END IF;

Line 1766: (p_msg => 'SQL - Update xla_ae_lines_gt 3.5'

1762: -- 4262811 ------------------------------------------------------------------
1763: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1764:
1765: trace
1766: (p_msg => 'SQL - Update xla_ae_lines_gt 3.5'
1767: ,p_level => C_LEVEL_STATEMENT
1768: ,p_module => l_log_module);
1769:
1770: END IF;

Line 1781: from xla_ae_lines_gt l

1777: forall i in 1..l_array_rowid.count
1778: update xla_ae_headers_gt h
1779: set parent_ae_line_num =
1780: (select l_array_ae_line_num(i)
1781: from xla_ae_lines_gt l
1782: where h.parent_header_id = l.event_id -- awan l.ae_header_id no rows
1783: and h.ledger_id = l.ledger_id
1784: and h.balance_type_code = l.balance_type_code
1785: and h.event_id = l.event_id

Line 1794: FROM xla_ae_lines_gt l

1790: -- IF l_array_rowid.count > 0 THEN commented IF for 7230462
1791: UPDATE xla_ae_headers_gt h
1792: SET parent_ae_line_num =
1793: (SELECT ae_line_num
1794: FROM xla_ae_lines_gt l
1795: WHERE h.parent_header_id = l.event_id -- awan l.ae_header_id no rows
1796: AND h.ledger_id = l.ledger_id
1797: AND h.balance_type_code = l.balance_type_code
1798: AND h.event_id = l.event_id

Line 1810: (p_msg => 'SQL - Update xla_ae_lines_gt 4'

1806:
1807: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1808:
1809: trace
1810: (p_msg => 'SQL - Update xla_ae_lines_gt 4'
1811: ,p_level => C_LEVEL_STATEMENT
1812: ,p_module => l_log_module);
1813:
1814: END IF;

Line 1816: UPDATE xla_ae_lines_gt ael

1812: ,p_module => l_log_module);
1813:
1814: END IF;
1815:
1816: UPDATE xla_ae_lines_gt ael
1817: SET (ref_ae_header_id, ref_temp_line_num) =
1818: (SELECT ae_header_id, temp_line_num
1819: FROM xla_ae_lines_gt
1820: WHERE event_id = ael.ref_event_id

Line 1819: FROM xla_ae_lines_gt

1815:
1816: UPDATE xla_ae_lines_gt ael
1817: SET (ref_ae_header_id, ref_temp_line_num) =
1818: (SELECT ae_header_id, temp_line_num
1819: FROM xla_ae_lines_gt
1820: WHERE event_id = ael.ref_event_id
1821: AND ledger_id = ael.ledger_id
1822: AND balance_type_code = ael.balance_type_code
1823: AND temp_line_num = ael.temp_line_num * -1)

Line 1829: (p_msg => 'SQL - Update xla_ae_lines_gt 5'

1825: AND ref_temp_line_num IS NULL;
1826:
1827: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1828: trace
1829: (p_msg => 'SQL - Update xla_ae_lines_gt 5'
1830: ,p_level => C_LEVEL_STATEMENT
1831: ,p_module => l_log_module);
1832: END IF;
1833:

Line 1880: (p_msg => 'SQL - Update xla_ae_lines_gt 6'

1876: EXIT;
1877: END IF;
1878: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1879: trace
1880: (p_msg => 'SQL - Update xla_ae_lines_gt 6'
1881: ,p_level => C_LEVEL_STATEMENT
1882: ,p_module => l_log_module);
1883: trace
1884: (p_msg => 'count:'||to_char(l_array_rounding_class_code.count)

Line 1959: update xla_ae_lines_gt

1955: l_array_rounding_entd_amt1(j) := l_curr_entd_rounding_amount;
1956: j:= j+1;
1957: IF (j> C_BULK_LIMIT) THEN
1958: FORALL i in 1..j-1
1959: update xla_ae_lines_gt
1960: set doc_rounding_acctd_amt = l_array_doc_rounding_amt1(i)
1961: ,doc_rounding_entered_amt = l_array_rounding_entd_amt1(i)
1962: where rowid = l_array_rowid1(i);
1963: j:=1;

Line 2041: (p_msg => 'SQL - Update xla_ae_lines_gt 7, j='||to_char(j)

2037: END IF;
2038:
2039: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2040: trace
2041: (p_msg => 'SQL - Update xla_ae_lines_gt 7, j='||to_char(j)
2042: ,p_level => C_LEVEL_STATEMENT
2043: ,p_module => l_log_module);
2044: END IF;
2045:

Line 2048: update xla_ae_lines_gt

2044: END IF;
2045:
2046: IF j>1 THEN
2047: FORALL i in 1..j-1
2048: update xla_ae_lines_gt
2049: set doc_rounding_acctd_amt = l_array_doc_rounding_amt1(i)
2050: ,doc_rounding_entered_amt = l_array_rounding_entd_amt1(i)
2051: where rowid = l_array_rowid1(i);
2052: END IF;

Line 2261: FROM xla_ae_lines_gt

2257: ae_line_num
2258: BULK COLLECT
2259: INTO l_array_rowid
2260: ,l_array_ae_line_num
2261: FROM xla_ae_lines_gt
2262: WHERE temp_line_num <> 0;
2263:
2264: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2265:

Line 2267: (p_msg => 'SQL - Update xla_ae_lines_gt 3'

2263:
2264: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2265:
2266: trace
2267: (p_msg => 'SQL - Update xla_ae_lines_gt 3'
2268: ,p_level => C_LEVEL_STATEMENT
2269: ,p_module => l_log_module);
2270:
2271: END IF;

Line 2274: UPDATE xla_ae_lines_gt

2270:
2271: END IF;
2272:
2273: FORALL i IN 1..l_array_rowid.COUNT
2274: UPDATE xla_ae_lines_gt
2275: SET ae_line_num = l_array_ae_line_num(i)
2276: WHERE rowid = l_array_rowid(i);
2277:
2278: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2511: FROM xla_ae_lines_gt

2507: ,merge_index)
2508:
2509: ae_line_num
2510: BULK COLLECT INTO l_array_rowid, l_array_ae_line_num
2511: FROM xla_ae_lines_gt
2512: WHERE temp_line_num <> 0;
2513:
2514: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2515:

Line 2517: (p_msg => 'SQL - Update xla_ae_lines_gt 3'

2513:
2514: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2515:
2516: trace
2517: (p_msg => 'SQL - Update xla_ae_lines_gt 3'
2518: ,p_level => C_LEVEL_STATEMENT
2519: ,p_module => l_log_module);
2520:
2521: END IF;

Line 2524: update xla_ae_lines_gt

2520:
2521: END IF;
2522:
2523: forall i in 1..l_array_rowid.count
2524: update xla_ae_lines_gt
2525: set ae_line_num = l_array_ae_line_num(i)
2526: where rowid = l_array_rowid(i);
2527:
2528:

Line 2763: FROM xla_ae_lines_gt

2759: ,merge_index)
2760:
2761: ae_line_num
2762: BULK COLLECT INTO l_array_rowid, l_array_ae_line_num
2763: FROM xla_ae_lines_gt
2764: WHERE temp_line_num <> 0;
2765:
2766: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2767:

Line 2769: (p_msg => 'SQL - Update xla_ae_lines_gt 3'

2765:
2766: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2767:
2768: trace
2769: (p_msg => 'SQL - Update xla_ae_lines_gt 3'
2770: ,p_level => C_LEVEL_STATEMENT
2771: ,p_module => l_log_module);
2772:
2773: END IF;

Line 2776: update xla_ae_lines_gt

2772:
2773: END IF;
2774:
2775: forall i in 1..l_array_rowid.count
2776: update xla_ae_lines_gt
2777: set ae_line_num = l_array_ae_line_num(i)
2778: where rowid = l_array_rowid(i);
2779:
2780:

Line 3014: FROM xla_ae_lines_gt

3010: ,merge_index)
3011:
3012: ae_line_num
3013: BULK COLLECT INTO l_array_rowid, l_array_ae_line_num
3014: FROM xla_ae_lines_gt
3015: WHERE temp_line_num <> 0;
3016:
3017: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3018:

Line 3020: (p_msg => 'SQL - Update xla_ae_lines_gt 3'

3016:
3017: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3018:
3019: trace
3020: (p_msg => 'SQL - Update xla_ae_lines_gt 3'
3021: ,p_level => C_LEVEL_STATEMENT
3022: ,p_module => l_log_module);
3023:
3024: END IF;

Line 3027: update xla_ae_lines_gt

3023:
3024: END IF;
3025:
3026: forall i in 1..l_array_rowid.count
3027: update xla_ae_lines_gt
3028: set ae_line_num = l_array_ae_line_num(i)
3029: where rowid = l_array_rowid(i);
3030:
3031:

Line 3482: FROM xla_ae_lines_gt lin

3478: , encumbrance_type_id -- 4458381 Public Sector Enh
3479: , ledger_id -- 4955764
3480: , accounting_date -- 4955764
3481: , gcc.reference3 control_balance_flag --4930177
3482: FROM xla_ae_lines_gt lin
3483: ,gl_code_combinations gcc
3484: WHERE ledger_id = l_ledger_attrs.array_ledger_id(i)
3485: AND ae_line_num is not NULL
3486: AND lin.code_combination_id = gcc.code_combination_id(+) --5261785

Line 3651: (SELECT 1 FROM xla_ae_lines_gt WHERE reversal_code='REVERSAL');

3647: BEGIN
3648: SELECT 'Y' into l_reversal_flag
3649: FROM dual
3650: WHERE exists
3651: (SELECT 1 FROM xla_ae_lines_gt WHERE reversal_code='REVERSAL');
3652:
3653: IF l_reversal_flag='Y' THEN
3654: Insert_ANC_Inv_Canc;
3655: END IF;

Line 4179: FROM xla_ae_lines_gt

4175: , anc_id_7
4176: , anc_id_8
4177: , anc_id_9
4178: , anc_id_10
4179: FROM xla_ae_lines_gt
4180: WHERE ae_line_num is not null
4181: GROUP BY
4182: ae_line_num
4183: ,ae_header_id

Line 6340: FROM xla_ae_lines_gt

6336: , anc_id_47
6337: , anc_id_48
6338: , anc_id_49
6339: , anc_id_50
6340: FROM xla_ae_lines_gt
6341: WHERE ae_line_num is not null
6342: GROUP BY
6343: ae_line_num
6344: ,ae_header_id

Line 10590: FROM xla_ae_lines_gt

10586: , anc_id_97
10587: , anc_id_98
10588: , anc_id_99
10589: , anc_id_100
10590: FROM xla_ae_lines_gt
10591: WHERE ae_line_num is not null
10592: GROUP BY
10593: ae_line_num
10594: ,ae_header_id

Line 11530: FROM xla_ae_lines_gt

11526: , alloc_to_dist_id_num_2
11527: , alloc_to_dist_id_num_3
11528: , alloc_to_dist_id_num_4
11529: , alloc_to_dist_id_num_5
11530: FROM xla_ae_lines_gt
11531: WHERE ae_line_num IS NOT NULL;
11532:
11533: l_rowcount:= SQL%ROWCOUNT;
11534:

Line 19461: (select /+ index(gt XLA_AE_LINES_GT_U1) /

19457: ac2,
19458: ac3,
19459: ac4,
19460: ac5)
19461: (select /*+ index(gt XLA_AE_LINES_GT_U1) */
19462: gt.ae_header_id,
19463: gt.ae_line_num,
19464: la.analytical_criterion_code,
19465: la.analytical_criterion_type_code,

Line 19474: xla_ae_lines_gt gt

19470: la.ac3,
19471: la.ac4,
19472: la.ac5
19473: from xla_ae_line_acs la,
19474: xla_ae_lines_gt gt
19475: where la.ae_header_id=gt.ref_ae_header_id
19476: and gt.ref_ae_header_id<> gt.ae_header_id
19477: and la.ae_line_num = gt.ref_ae_line_num
19478: and gt.ref_ae_line_num is not null