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

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 53: | 31-JUL-2003 K.Boussema Added in XLA_AE_LINES the two columns: |

49: | Reviewed GetAlternateCurrencyLedger |
50: | 24-JUL-2003 K.Boussema Updated the error messages |
51: | 28-JUL-2003 K.Boussema Reviewed GetAlternateCurrencyLedger Procedure |
52: | 29-JUL-2003 K.Boussema Reviewed the code to solve bug 3072881 |
53: | 31-JUL-2003 K.Boussema Added in XLA_AE_LINES the two columns: |
54: | DISPLAYED_LINE_NUMBER and GL_SL_LINK_TABLE |
55: | 05-Aug-2003 Shishir J Removed currency_code column from the |
56: | xla_distribution_links table |
57: | 13-Aug-2003 Shishir J Includes Neil's performance changes. |

Line 67: | 02-DEC-2003 K.Boussema Populated xla_ae_lines.gl_sl_link_table column|

63: | preference for Accounting Reversal from JLT |
64: | 14-NOV-2003 K.Boussema Reviewed the cache of the primary ledger coa |
65: | 26-NOV-2003 K.Boussema Called the accounting cache to get the coa |
66: | DYNAMIC_INSERTS_ALLOWED_FLAG, bug3256226 |
67: | 02-DEC-2003 K.Boussema Populated xla_ae_lines.gl_sl_link_table column|
68: | with 'XLAJEL' |
69: | 05-DEC-2003 K.Boussema Changed the cache of coa to fix bug3289875 |
70: | 12-DEC-2003 K.Boussema Added the validation of event accounting mode |
71: | 18-DEC-2003 K.Boussema Changed to fix bug 3042840,3307761,3268940 |

Line 103: | XLA_AE_LINES and XLA_DISTRIBUTION_LINKS. |

99: | 22-Sep-2004 S.Singhania Made changes for the bulk peroformance. It has |
100: | changed the code at number of places. |
101: | 05-Oct-2004 S.Singhania Bug 3931752: Removed the not required where |
102: | condition from the sqls that inserts into |
103: | XLA_AE_LINES and XLA_DISTRIBUTION_LINKS. |
104: | 05-OCT-2004 K.Boussema Changed for Extract Source Values Dump feature |
105: | added procedures : |
106: | - insert_extract_event() |
107: | - insert_extract_ledger() |

Line 150: | in xla_ae_lines table |

146: | 09-Jan-2006 A. Wan 4669308 - AdjustMpaRevLine |
147: | 11-Jan-2006 W. Shen 4943507 - modify GetLineNum to add more merge |
148: | columns when get linehashnum |
149: | 13-Feb-2006 V. Kumar 4955764 - Populating Ledger_id,Accounting_date |
150: | in xla_ae_lines table |
151: | 03-Mar-2006 V. Kumar 5041325 Populating GL_SL_LINK_ID in xla_ae_lines|
152: | 21-Jun-2006 A. Wan 5100860 Performance fix, see bug for detail |
153: | 23-Sep-2008 Vijaya.G 7377888 Changes in AdjustMPALine procedure for |
154: | MPA Accounting |

Line 151: | 03-Mar-2006 V. Kumar 5041325 Populating GL_SL_LINK_ID in xla_ae_lines|

147: | 11-Jan-2006 W. Shen 4943507 - modify GetLineNum to add more merge |
148: | columns when get linehashnum |
149: | 13-Feb-2006 V. Kumar 4955764 - Populating Ledger_id,Accounting_date |
150: | in xla_ae_lines table |
151: | 03-Mar-2006 V. Kumar 5041325 Populating GL_SL_LINK_ID in xla_ae_lines|
152: | 21-Jun-2006 A. Wan 5100860 Performance fix, see bug for detail |
153: | 23-Sep-2008 Vijaya.G 7377888 Changes in AdjustMPALine procedure for |
154: | MPA Accounting |
155: | 03-Oct-2008 KARAMAKR 7382288 insert analytical criteria for |

Line 1455: XLA_AE_LINES_PKG.RefreshLines;

1451: g_cache_ledgers_info := l_null_ledgers_info;
1452: g_cache_event_tl := l_null_event_tl;
1453: --
1454: XLA_AE_HEADER_PKG.RefreshHeader;
1455: XLA_AE_LINES_PKG.RefreshLines;
1456: --
1457: -- free source value set cache
1458: --
1459: XLA_AE_SOURCES_PKG.g_array_meaning:= l_null_sc_value_set;

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 1745: -- Also, this was causing XLA_AE_LINES_U1 error

1741: --
1742: -- Bug 4719297 added NVL to the following.
1743: --
1744: -- 4669308 NVL(-1) creates a separate header for MPA reversal. NVL(0) combines original reversal and MPA reversal into 1 header
1745: -- Also, this was causing XLA_AE_LINES_U1 error
1746: --and nvl(header_num,-1) = nvl(g_array_header_num(i),-1)
1747: and header_num = nvl(g_array_header_num(i), 0); -- 5100860 instead of nvl(header_num, 0)
1748: --and temp_line_num <> 0; -- 5100860 should never be zero
1749: end if;

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 3094: (p_msg => 'SQL - Insert into xla_ae_lines'

3090: BEGIN
3091:
3092: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
3093: trace
3094: (p_msg => 'SQL - Insert into xla_ae_lines'
3095: ,p_level => C_LEVEL_STATEMENT
3096: ,p_module => l_log_module);
3097: END IF;
3098: --

Line 3111: INSERT INTO xla_ae_lines

3107: END IF;
3108:
3109:
3110: FORALL i in 1..l_ledger_attrs.array_ledger_id.count
3111: INSERT INTO xla_ae_lines
3112: (
3113: ae_header_id
3114: , ae_line_num
3115: , displayed_line_number

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 3561: (p_msg => '# journal entry lines inserted into xla_ae_lines = '||to_char(l_count)

3557: --
3558: l_count := SQL%ROWCOUNT;
3559: IF (C_LEVEL_EVENT >= g_log_level) THEN
3560: trace
3561: (p_msg => '# journal entry lines inserted into xla_ae_lines = '||to_char(l_count)
3562: ,p_level => C_LEVEL_EVENT
3563: ,p_module => l_log_module);
3564: END IF;
3565:

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 10822: -- FROM xla_ae_lines l,

10818: -- INTO l_array_entered_amt(i)
10819: -- ,l_array_accted_amt(i)
10820: -- ,l_array_unround_entered_amt(i)
10821: -- ,l_array_unround_accted_amt(i)
10822: -- FROM xla_ae_lines l,
10823: -- xla_distribution_links d -- added for bug 7377888
10824: -- /*WHERE ae_header_id = l_array_parent_hdr_idx(i)
10825: -- AND ae_line_num = l_array_parent_line_idx(i)
10826: -- AND application_id = p_application_id;*/ -- commented for bug 7377888

Line 10843: FROM xla_ae_lines l

10839: INTO l_array_entered_amt(i)
10840: ,l_array_accted_amt(i)
10841: ,l_array_unround_entered_amt(i)
10842: ,l_array_unround_accted_amt(i)
10843: FROM xla_ae_lines l
10844: WHERE l.ae_header_id = l_array_parent_hdr_idx(i)
10845: AND l.ae_line_num = l_array_parent_line_idx(i)
10846: AND l.application_id = p_application_id ;
10847:

Line 10861: FROM xla_ae_lines xel2

10857: ,xel2.ae_line_num
10858: BULK COLLECT INTO
10859: l_array_mpa_header_idx
10860: ,l_array_mpa_line_idx
10861: FROM xla_ae_lines xel2
10862: ,xla_ae_headers xeh
10863: WHERE xel2.ae_header_id = xeh.ae_header_id
10864: AND xel2.application_id = p_application_id
10865: AND xel2.ae_header_id <> l_array_max_hdr_idx(i)

Line 10885: UPDATE xla_ae_lines xel

10881: END LOOP;
10882: END IF;
10883:
10884: FORALL j IN 1..l_array_mpa_header_idx.COUNT
10885: UPDATE xla_ae_lines xel
10886: SET unrounded_entered_cr = entered_cr
10887: ,unrounded_entered_dr = entered_dr
10888: ,unrounded_accounted_cr = accounted_cr
10889: ,unrounded_accounted_dr = accounted_dr

Line 10904: FROM xla_ae_lines xel2

10900: (SELECT unrounded_entered_cr
10901: ,unrounded_entered_dr
10902: ,unrounded_accounted_cr
10903: ,unrounded_accounted_dr
10904: FROM xla_ae_lines xel2
10905: WHERE xel2.ae_header_id = xdl.ae_header_id
10906: AND xel2.ae_line_num = xdl.ae_line_num)
10907: WHERE application_id = p_application_id -- 4585874
10908: AND ae_header_id = l_array_mpa_header_idx(j)

Line 10918: UPDATE xla_ae_lines xel

10914: ------------------------------------------------------------
10915: -- Update the AMOUNTs for the last MPA line amount
10916: ------------------------------------------------------------
10917: FORALL i IN 1..l_array_parent_hdr_idx.COUNT
10918: UPDATE xla_ae_lines xel
10919: SET (entered_cr
10920: ,entered_dr
10921: ,accounted_cr
10922: ,accounted_dr

Line 10935: FROM xla_ae_lines xel2

10931: ,DECODE(MIN(unrounded_entered_cr), NULL,NULL, l_array_unround_entered_amt(i) - SUM(unrounded_entered_cr))
10932: ,DECODE(MIN(unrounded_entered_dr), NULL,NULL, l_array_unround_entered_amt(i) - SUM(unrounded_entered_dr))
10933: ,DECODE(MIN(unrounded_accounted_cr), NULL,NULL, l_array_unround_accted_amt(i) - SUM(unrounded_accounted_cr))
10934: ,DECODE(MIN(unrounded_accounted_dr), NULL,NULL, l_array_unround_accted_amt(i) - SUM(unrounded_accounted_dr))
10935: FROM xla_ae_lines xel2
10936: ,xla_ae_headers xeh
10937: WHERE xel2.ae_header_id = xeh.ae_header_id
10938: AND xel2.ae_line_num = xel.ae_line_num
10939: AND xel2.application_id = p_application_id -- 4585874

Line 10971: FROM xla_ae_lines xel2

10967: ,unrounded_entered_cr
10968: ,unrounded_entered_dr
10969: ,unrounded_accounted_cr
10970: ,unrounded_accounted_dr
10971: FROM xla_ae_lines xel2
10972: WHERE xel2.ae_header_id = xdl.ae_header_id
10973: AND xel2.ae_line_num = xdl.ae_line_num)
10974: WHERE application_id = p_application_id -- 4585874
10975: AND ae_header_id = l_array_max_hdr_idx(i);

Line 11046: --(SELECT COUNT(*) FROM xla_ae_lines xel,xla_ae_headers xeh -- count of original lines

11042: AND xdl3.ref_temp_line_num IS NULL
11043: AND xeh.parent_ae_header_id = xdl1.ref_ae_header_id
11044: AND xeh.parent_ae_line_num IS NOT NULL)
11045: ORDER BY xeh1.ledger_id, xdl1.ref_event_id;
11046: --(SELECT COUNT(*) FROM xla_ae_lines xel,xla_ae_headers xeh -- count of original lines
11047: -- WHERE xeh.application_id = p_application_id
11048: -- AND xel.ae_header_id = xeh.ae_header_id
11049: -- AND xeh.parent_ae_header_id = xdl1.ref_ae_header_id
11050: -- AND xeh.parent_ae_line_num IS NOT NULL)

Line 11054: FROM xla_ae_lines xel ,

11050: -- AND xeh.parent_ae_line_num IS NOT NULL)
11051:
11052: CURSOR cur_last_mpa (l_ae_header NUMBER, l_max_ae_header NUMBER) is
11053: SELECT xel.rowid, xel.*
11054: FROM xla_ae_lines xel ,
11055: xla_distribution_links xdl2
11056: WHERE xel.application_id = p_application_id
11057: AND xel.ae_header_id = l_ae_header
11058: AND xdl2.application_id = p_application_id

Line 11131: FROM xla_ae_lines

11127: INTO l_array_entered_amt(i)
11128: ,l_array_accted_amt(i)
11129: ,l_array_unround_entered_amt(i)
11130: ,l_array_unround_accted_amt(i)
11131: FROM xla_ae_lines
11132: WHERE application_id = p_application_id
11133: AND ae_header_id = l_array_ae_header_id(i)
11134: AND ae_line_num = l_array_parent_max_line(i);
11135: END LOOP;

Line 11186: UPDATE xla_ae_lines xel

11182: OPEN cur_last_mpa(l_array_ae_header_id(i), l_max_hdr_id);
11183: FETCH cur_last_mpa INTO l_last_mpa;
11184: WHILE cur_last_mpa%FOUND LOOP
11185:
11186: UPDATE xla_ae_lines xel
11187: SET (entered_cr
11188: ,entered_dr
11189: ,accounted_cr
11190: ,accounted_dr

Line 11203: FROM xla_ae_lines xel2

11199: ,DECODE((l_last_mpa.unrounded_entered_cr), NULL,NULL, l_array_unround_entered_amt(i) - SUM(xel2.unrounded_entered_cr))
11200: ,DECODE((l_last_mpa.unrounded_entered_dr), NULL,NULL, l_array_unround_entered_amt(i) - SUM(xel2.unrounded_entered_dr))
11201: ,DECODE((l_last_mpa.unrounded_accounted_cr), NULL,NULL, l_array_unround_accted_amt(i) - SUM(xel2.unrounded_accounted_cr))
11202: ,DECODE((l_last_mpa.unrounded_accounted_dr), NULL,NULL, l_array_unround_accted_amt(i) - SUM(xel2.unrounded_accounted_dr))
11203: FROM xla_ae_lines xel2
11204: ,xla_distribution_links xdl1
11205: ,xla_ae_headers xeh1
11206: WHERE xel2.application_id = p_application_id
11207: AND xel2.ae_header_id = xdl1.ae_header_id

Line 11223: (p_msg => 'update xla_ae_lines count='||SQL%ROWCOUNT||

11219: WHERE rowid = l_last_mpa.rowid;
11220:
11221: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
11222: trace
11223: (p_msg => 'update xla_ae_lines count='||SQL%ROWCOUNT||
11224: ' ae_header='||l_last_mpa.ae_header_id||
11225: ' ae_line='||l_last_mpa.ae_line_num
11226: ,p_level => C_LEVEL_STATEMENT
11227: ,p_module => l_log_module);

Line 11253: FROM xla_ae_lines xel

11249: ,xel.unrounded_entered_cr
11250: ,xel.unrounded_entered_dr
11251: ,xel.unrounded_accounted_cr
11252: ,xel.unrounded_accounted_dr
11253: FROM xla_ae_lines xel
11254: ,xla_distribution_links xdl1
11255: WHERE xel.application_id = p_application_id
11256: AND xel.ae_header_id = xdl1.ae_header_id
11257: AND xel.ae_line_num = xdl1.ae_line_num

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