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 175: | of AE_HEADER_ID in XLA_AE_LINES_GT |

171: | for changes via bug8277823 |
172: | 13-MAY-2010 VGOPISET 9630931 Perf Change for REF_AE_HEADER_ID update |
173: | introduced via bug 8619700 |
174: | 29-OCT-2010 VGOPISET 10247334 Perf Change of GetLineNumber SQL update|
175: | of AE_HEADER_ID in XLA_AE_LINES_GT |
176: | 11-Nov-2010 VGOPISET 10242870 Changes in AdjustMPALine to adjust the |
177: | difference in Last Period header with MAX Amount|
178: | to avoid sum getting added to ERV MPA Lines. |
179: | 26-NOV-2010 Narayanan M.S. Bug#10124492 Group_id will not be stamped |

Line 1648: --FROM xla_ae_lines_gt xalg

1644: -- ,ae_header_id
1645: -- ,NVL(SUM(unrounded_entered_cr), 0)
1646: -- - NVL(SUM(unrounded_entered_dr), 0) unrounded_entered_amount
1647: -- ,entered_currency_mau
1648: --FROM xla_ae_lines_gt xalg
1649: --WHERE temp_line_num <> 0
1650: --GROUP BY ledger_id, event_id, ae_header_id,
1651: -- rounding_class_code, document_rounding_level, ae_line_num
1652: -- ,entered_currency_mau

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

1680:
1681: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1682:
1683: trace
1684: (p_msg => 'SQL - Update xla_ae_lines_gt'
1685: ,p_level => C_LEVEL_STATEMENT
1686: ,p_module => l_log_module);
1687:
1688: END IF;

Line 1695: --update /+ index(ael,XLA_AE_LINES_GT_N4) / xla_ae_lines_gt ael

1691: -- Commented FORALL Update for perf bug#10247334
1692: /* forall i in 1..g_array_event_id.count
1693: -- added the hint for bug:7560587
1694: */
1695: --update /*+ index(ael,XLA_AE_LINES_GT_N4) */ xla_ae_lines_gt ael
1696: /*set ae_header_id = g_array_ae_header_id(i)
1697: ,ref_ae_header_id = DECODE(ref_event_id,NULL,g_array_ae_header_id(i),ref_ae_header_id)
1698: */
1699: /* Calling get_hash_value for each row is expensive.

Line 1851: merge /+ use_hash(xal) / into xla_ae_lines_gt XAL

1847: /* and header_num = nvl(g_array_header_num(i), 0); -- 5100860 instead of nvl(header_num, 0) */
1848: --and temp_line_num <> 0; -- 5100860 should never be zero
1849:
1850: --added the below MERGE Update for bug#10247334
1851: merge /*+ use_hash(xal) */ into xla_ae_lines_gt XAL
1852: using xla_ae_headers_gt xah
1853: on (
1854: xal.event_id = xah.event_id
1855: and xal.ledger_id = xah.ledger_id

Line 1896: (p_msg => 'SQL - Update xla_ae_lines_gt 2: '||SQL%ROWCOUNT

1892:
1893: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1894:
1895: trace
1896: (p_msg => 'SQL - Update xla_ae_lines_gt 2: '||SQL%ROWCOUNT
1897: ,p_level => C_LEVEL_STATEMENT
1898: ,p_module => l_log_module);
1899:
1900: END IF;

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

1904: -- 4262811 ------------------------------------------------------------------
1905: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1906:
1907: trace
1908: (p_msg => 'SQL - Update xla_ae_lines_gt 3.5'
1909: ,p_level => C_LEVEL_STATEMENT
1910: ,p_module => l_log_module);
1911:
1912: END IF;

Line 1922: from xla_ae_lines_gt l

1918: forall i in 1..l_array_rowid.count
1919: update xla_ae_headers_gt h
1920: set parent_ae_line_num =
1921: (select l_array_ae_line_num(i)
1922: from xla_ae_lines_gt l
1923: where h.parent_header_id = l.event_id -- awan l.ae_header_id no rows
1924: and h.ledger_id = l.ledger_id
1925: and h.balance_type_code = l.balance_type_code
1926: and h.event_id = l.event_id

Line 1934: (SELECT /+ index(L XLA_AE_LINES_GT_U1) / ae_line_num --Index added for bug 14246749

1930: */
1931: -- IF l_array_rowid.count > 0 THEN commented IF for 7230462
1932: UPDATE xla_ae_headers_gt h
1933: SET parent_ae_line_num =
1934: (SELECT /*+ index(L XLA_AE_LINES_GT_U1) */ ae_line_num --Index added for bug 14246749
1935: FROM xla_ae_lines_gt l
1936: WHERE h.parent_header_id = l.event_id -- awan l.ae_header_id no rows
1937: AND h.ledger_id = l.ledger_id
1938: AND h.balance_type_code = l.balance_type_code

Line 1935: FROM xla_ae_lines_gt l

1931: -- IF l_array_rowid.count > 0 THEN commented IF for 7230462
1932: UPDATE xla_ae_headers_gt h
1933: SET parent_ae_line_num =
1934: (SELECT /*+ index(L XLA_AE_LINES_GT_U1) */ ae_line_num --Index added for bug 14246749
1935: FROM xla_ae_lines_gt l
1936: WHERE h.parent_header_id = l.event_id -- awan l.ae_header_id no rows
1937: AND h.ledger_id = l.ledger_id
1938: AND h.balance_type_code = l.balance_type_code
1939: AND h.event_id = l.event_id

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

1947:
1948: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1949:
1950: trace
1951: (p_msg => 'SQL - Update xla_ae_lines_gt 4'
1952: ,p_level => C_LEVEL_STATEMENT
1953: ,p_module => l_log_module);
1954:
1955: END IF;

Line 1957: UPDATE xla_ae_lines_gt ael

1953: ,p_module => l_log_module);
1954:
1955: END IF;
1956:
1957: UPDATE xla_ae_lines_gt ael
1958: SET (ref_ae_header_id, ref_temp_line_num) =
1959: (SELECT ae_header_id, temp_line_num
1960: FROM xla_ae_lines_gt
1961: WHERE event_id = ael.ref_event_id

Line 1960: FROM xla_ae_lines_gt

1956:
1957: UPDATE xla_ae_lines_gt ael
1958: SET (ref_ae_header_id, ref_temp_line_num) =
1959: (SELECT ae_header_id, temp_line_num
1960: FROM xla_ae_lines_gt
1961: WHERE event_id = ael.ref_event_id
1962: AND ledger_id = ael.ledger_id
1963: AND balance_type_code = ael.balance_type_code
1964: AND temp_line_num = ael.temp_line_num * -1)

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

1966: AND ref_temp_line_num IS NULL;
1967:
1968: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1969: trace
1970: (p_msg => 'SQL - Update xla_ae_lines_gt 5'
1971: ,p_level => C_LEVEL_STATEMENT
1972: ,p_module => l_log_module);
1973: END IF;
1974:

Line 1979: UPDATE xla_ae_lines_gt ael

1975: -- added the follwing update to correct REF_AE_HEADER_ID when ORIGINAL AND REVERSAL EVENTS
1976: -- are accounted in the same batch for bug:8277823
1977: -- commented the following code for performance issues faced in bug: 8619700
1978: /*
1979: UPDATE xla_ae_lines_gt ael
1980: SET ael.ref_event_id = -1 * ael.ref_event_id
1981: , ael.ref_ae_header_id =
1982: ( SELECT lgt.ae_header_id
1983: FROM xla_ae_lines_gt lgt

Line 1983: FROM xla_ae_lines_gt lgt

1979: UPDATE xla_ae_lines_gt ael
1980: SET ael.ref_event_id = -1 * ael.ref_event_id
1981: , ael.ref_ae_header_id =
1982: ( SELECT lgt.ae_header_id
1983: FROM xla_ae_lines_gt lgt
1984: WHERE lgt.event_id = -1 * ael.ref_event_id
1985: AND lgt.ledger_id = ael.ledger_id
1986: AND lgt.balance_type_code = ael.balance_type_code
1987: AND lgt.temp_line_num = ael.temp_line_num * -1

Line 1996: UPDATE /+ INDEX(ael XLA_AE_LINES_GT_U1) / XLA_AE_LINES_GT AEL

1992: */
1993: -- added the following code for performance issues faced in bug:8619700
1994: -- added hint for perf bug9630931
1995: forall i in 1..g_array_event_id.count
1996: UPDATE /*+ INDEX(ael XLA_AE_LINES_GT_U1) */ XLA_AE_LINES_GT AEL
1997: SET AEL.REF_EVENT_ID = -1 * AEL.REF_EVENT_ID ,
1998: AEL.REF_AE_HEADER_ID = g_array_ae_header_id(i)
1999: WHERE AEL.REF_AE_HEADER_ID = g_array_event_id(i)
2000: AND AEL.REF_EVENT_ID = -1 * g_array_event_id(i)

Line 2009: (p_msg => 'SQL - Update xla_ae_lines_gt 5_1 for ReversalEvents '|| SQL%ROWCOUNT

2005: AND AEL.HEADER_NUM = NVL( g_array_header_num(i) , 0) ;
2006:
2007: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2008: trace
2009: (p_msg => 'SQL - Update xla_ae_lines_gt 5_1 for ReversalEvents '|| SQL%ROWCOUNT
2010: ,p_level => C_LEVEL_STATEMENT
2011: ,p_module => l_log_module);
2012: END IF;
2013:

Line 2035: ' FROM xla_ae_lines_gt xalg '||

2031: l_case_sql || ' bsv_value '||
2032: ' ,NVL(SUM(unrounded_entered_cr), 0) '||
2033: ' - NVL(SUM(unrounded_entered_dr), 0) unrounded_entered_amount '||
2034: ' ,entered_currency_mau '||
2035: ' FROM xla_ae_lines_gt xalg '||
2036: ' , gl_code_combinations gcc '||
2037: ' WHERE temp_line_num <> 0 '||
2038: ' and gcc.code_combination_id = xalg.code_combination_id '||
2039: ' GROUP BY ledger_id, event_id, ae_header_id, '||

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

2106: EXIT;
2107: END IF;
2108: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2109: trace
2110: (p_msg => 'SQL - Update xla_ae_lines_gt 6'
2111: ,p_level => C_LEVEL_STATEMENT
2112: ,p_module => l_log_module);
2113: trace
2114: (p_msg => 'count:'||to_char(l_array_rounding_class_code.count)

Line 2195: update xla_ae_lines_gt

2191: l_array_rounding_entd_amt1(j) := l_curr_entd_rounding_amount;
2192: j:= j+1;
2193: IF (j> C_BULK_LIMIT) THEN
2194: FORALL i in 1..j-1
2195: update xla_ae_lines_gt
2196: set doc_rounding_acctd_amt = l_array_doc_rounding_amt1(i)
2197: ,doc_rounding_entered_amt = l_array_rounding_entd_amt1(i)
2198: where rowid = l_array_rowid1(i);
2199: j:=1;

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

2274: END IF;
2275:
2276: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2277: trace
2278: (p_msg => 'SQL - Update xla_ae_lines_gt 7, j='||to_char(j)
2279: ,p_level => C_LEVEL_STATEMENT
2280: ,p_module => l_log_module);
2281: END IF;
2282:

Line 2285: update xla_ae_lines_gt

2281: END IF;
2282:
2283: IF j>1 THEN
2284: FORALL i in 1..j-1
2285: update xla_ae_lines_gt
2286: set doc_rounding_acctd_amt = l_array_doc_rounding_amt1(i)
2287: ,doc_rounding_entered_amt = l_array_rounding_entd_amt1(i)
2288: where rowid = l_array_rowid1(i);
2289: END IF;

Line 2500: FROM xla_ae_lines_gt

2496: ae_line_num
2497: BULK COLLECT
2498: INTO l_array_rowid
2499: ,l_array_ae_line_num
2500: FROM xla_ae_lines_gt
2501: WHERE temp_line_num <> 0;
2502:
2503: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2504:

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

2502:
2503: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2504:
2505: trace
2506: (p_msg => 'SQL - Update xla_ae_lines_gt 3'
2507: ,p_level => C_LEVEL_STATEMENT
2508: ,p_module => l_log_module);
2509:
2510: END IF;

Line 2513: UPDATE xla_ae_lines_gt

2509:
2510: END IF;
2511:
2512: FORALL i IN 1..l_array_rowid.COUNT
2513: UPDATE xla_ae_lines_gt
2514: SET ae_line_num = l_array_ae_line_num(i)
2515: WHERE rowid = l_array_rowid(i);
2516:
2517: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2752: FROM xla_ae_lines_gt

2748: ,entered_currency_mau)
2749:
2750: ae_line_num
2751: BULK COLLECT INTO l_array_rowid, l_array_ae_line_num
2752: FROM xla_ae_lines_gt
2753: WHERE temp_line_num <> 0;
2754:
2755: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2756:

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

2754:
2755: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2756:
2757: trace
2758: (p_msg => 'SQL - Update xla_ae_lines_gt 3'
2759: ,p_level => C_LEVEL_STATEMENT
2760: ,p_module => l_log_module);
2761:
2762: END IF;

Line 2765: update xla_ae_lines_gt

2761:
2762: END IF;
2763:
2764: forall i in 1..l_array_rowid.count
2765: update xla_ae_lines_gt
2766: set ae_line_num = l_array_ae_line_num(i)
2767: where rowid = l_array_rowid(i);
2768:
2769:

Line 3006: FROM xla_ae_lines_gt

3002: ,entered_currency_mau)
3003:
3004: ae_line_num
3005: BULK COLLECT INTO l_array_rowid, l_array_ae_line_num
3006: FROM xla_ae_lines_gt
3007: WHERE temp_line_num <> 0;
3008:
3009: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3010:

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

3008:
3009: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3010:
3011: trace
3012: (p_msg => 'SQL - Update xla_ae_lines_gt 3'
3013: ,p_level => C_LEVEL_STATEMENT
3014: ,p_module => l_log_module);
3015:
3016: END IF;

Line 3019: update xla_ae_lines_gt

3015:
3016: END IF;
3017:
3018: forall i in 1..l_array_rowid.count
3019: update xla_ae_lines_gt
3020: set ae_line_num = l_array_ae_line_num(i)
3021: where rowid = l_array_rowid(i);
3022:
3023:

Line 3259: FROM xla_ae_lines_gt

3255: ,entered_currency_mau)
3256:
3257: ae_line_num
3258: BULK COLLECT INTO l_array_rowid, l_array_ae_line_num
3259: FROM xla_ae_lines_gt
3260: WHERE temp_line_num <> 0;
3261:
3262: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3263:

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

3261:
3262: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3263:
3264: trace
3265: (p_msg => 'SQL - Update xla_ae_lines_gt 3'
3266: ,p_level => C_LEVEL_STATEMENT
3267: ,p_module => l_log_module);
3268:
3269: END IF;

Line 3272: update xla_ae_lines_gt

3268:
3269: END IF;
3270:
3271: forall i in 1..l_array_rowid.count
3272: update xla_ae_lines_gt
3273: set ae_line_num = l_array_ae_line_num(i)
3274: where rowid = l_array_rowid(i);
3275:
3276:

Line 3757: FROM xla_ae_lines_gt lin

3753: , encumbrance_type_id -- 4458381 Public Sector Enh
3754: , ledger_id -- 4955764
3755: , accounting_date -- 4955764
3756: , gcc.reference3 control_balance_flag --4930177
3757: FROM xla_ae_lines_gt lin
3758: ,gl_code_combinations gcc
3759: WHERE ledger_id = l_ledger_attrs.array_ledger_id(i)
3760: AND ae_line_num is not NULL
3761: AND lin.code_combination_id = gcc.code_combination_id(+) --5261785

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

3922: BEGIN
3923: SELECT 'Y' into l_reversal_flag
3924: FROM dual
3925: WHERE exists
3926: (SELECT 1 FROM xla_ae_lines_gt WHERE reversal_code='REVERSAL');
3927:
3928: IF l_reversal_flag='Y' THEN
3929: Insert_ANC_Inv_Canc;
3930: END IF;

Line 4454: FROM xla_ae_lines_gt

4450: , anc_id_7
4451: , anc_id_8
4452: , anc_id_9
4453: , anc_id_10
4454: FROM xla_ae_lines_gt
4455: WHERE ae_line_num is not null
4456: GROUP BY
4457: ae_line_num
4458: ,ae_header_id

Line 6615: FROM xla_ae_lines_gt

6611: , anc_id_47
6612: , anc_id_48
6613: , anc_id_49
6614: , anc_id_50
6615: FROM xla_ae_lines_gt
6616: WHERE ae_line_num is not null
6617: GROUP BY
6618: ae_line_num
6619: ,ae_header_id

Line 10865: FROM xla_ae_lines_gt

10861: , anc_id_97
10862: , anc_id_98
10863: , anc_id_99
10864: , anc_id_100
10865: FROM xla_ae_lines_gt
10866: WHERE ae_line_num is not null
10867: GROUP BY
10868: ae_line_num
10869: ,ae_header_id

Line 12052: FROM xla_ae_lines_gt

12048: , alloc_to_dist_id_num_2
12049: , alloc_to_dist_id_num_3
12050: , alloc_to_dist_id_num_4
12051: , alloc_to_dist_id_num_5
12052: FROM xla_ae_lines_gt
12053: WHERE ae_line_num IS NOT NULL;
12054:
12055: l_rowcount:= SQL%ROWCOUNT;
12056:

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

19986: ac2,
19987: ac3,
19988: ac4,
19989: ac5)
19990: (select /*+ index(gt XLA_AE_LINES_GT_U1) */
19991: gt.ae_header_id,
19992: gt.ae_line_num,
19993: la.analytical_criterion_code,
19994: la.analytical_criterion_type_code,

Line 20003: xla_ae_lines_gt gt

19999: la.ac3,
20000: la.ac4,
20001: la.ac5
20002: from xla_ae_line_acs la,
20003: xla_ae_lines_gt gt
20004: where la.ae_header_id=gt.ref_ae_header_id
20005: and gt.ref_ae_header_id<> gt.ae_header_id
20006: and la.ae_line_num = gt.ref_ae_line_num
20007: and gt.ref_ae_line_num is not null