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_DISTRIBUTION_LINKS

Line 34: | Renamed in xla_distribution_links the column |

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 |
37: | 20-MAI-2003 K.Boussema Added a Token to XLA_AP_CANNOT_INSERT_JE |
38: | message |

Line 56: | xla_distribution_links table |

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. |
58: | 19-SEP-2003 K.Boussema Code changed to include reversed_ae_header_id|
59: | and reversed_line_num, see bug 3143095 |
60: | 16-Oct-2003 Shishir J Added accounting class code in the call to the|

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 10813: /* Excluding the join with XLA_DISTRIBUTION_LINKS bug:7230462 */

10809: ------------------------------------------------------------
10810: -- Find the original amounts
10811: ------------------------------------------------------------
10812: FOR i IN 1..l_array_parent_hdr_idx.COUNT LOOP
10813: /* Excluding the join with XLA_DISTRIBUTION_LINKS bug:7230462 */
10814: -- SELECT NVL(l.entered_cr, l.entered_dr)
10815: -- ,NVL(l.accounted_cr, l.accounted_dr)
10816: -- ,NVL(l.unrounded_entered_cr, l.unrounded_entered_dr)
10817: -- ,NVL(l.unrounded_accounted_cr, l.unrounded_accounted_dr)

Line 10823: -- xla_distribution_links d -- added for bug 7377888

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
10827: -- WHERE l.ae_header_id = d.ae_header_id

Line 10895: UPDATE xla_distribution_links xdl

10891: AND ae_header_id = l_array_mpa_header_idx(j)
10892: AND ae_line_num = l_array_mpa_line_idx(j);
10893:
10894: FORALL j IN 1..l_array_mpa_header_idx.COUNT
10895: UPDATE xla_distribution_links xdl
10896: SET (unrounded_entered_cr
10897: ,unrounded_entered_dr
10898: ,unrounded_accounted_cr
10899: ,unrounded_accounted_dr) =

Line 10951: UPDATE xla_distribution_links xdl

10947: --------------------------------------------------------------------------------------------
10948: -- Update the DOC_ROUNDING values for the corresponding MPA line
10949: --------------------------------------------------------------------------------------------
10950: FORALL i IN 1..l_array_parent_hdr_idx.COUNT
10951: UPDATE xla_distribution_links xdl
10952: SET (doc_rounding_acctd_amt
10953: ,doc_rounding_entered_amt
10954: ,unrounded_entered_cr -- 4669308
10955: ,unrounded_entered_dr -- 4669308

Line 11017: FROM xla_distribution_links xdl1

11013: ,MAX(xdl1.ae_line_num)
11014: ,xdl1.ae_header_id
11015: ,xdl1.ref_event_id
11016: ,xeh1.ledger_id
11017: FROM xla_distribution_links xdl1
11018: ,xla_ae_headers xeh1
11019: ,xla_ae_headers_gt xehg
11020: WHERE xdl1.application_id = p_application_id
11021: AND xeh1.application_id = p_application_id

Line 11031: HAVING (SELECT COUNT(*) FROM xla_distribution_links xdl2 -- count of reversal lines

11027: WHERE application_id = p_application_id
11028: AND parent_ae_header_id = xdl1.ref_ae_header_id
11029: AND parent_ae_line_num IS NOT NULL) -- MPA only, not for Accrual Reversal
11030: GROUP BY xdl1.ref_ae_header_id, xdl1.ref_event_id, xdl1.application_id, xeh1.ledger_id, xdl1.ae_header_id
11031: HAVING (SELECT COUNT(*) FROM xla_distribution_links xdl2 -- count of reversal lines
11032: WHERE xdl2.application_id = p_application_id
11033: AND xdl2.ae_header_id = xdl1.ae_header_id
11034: AND xdl2.temp_line_num = xdl2.ref_temp_line_num*-1
11035: AND xdl2.ref_ae_header_id <> xdl1.ref_ae_header_id

Line 11037: (SELECT COUNT(*) FROM xla_distribution_links xdl3,xla_ae_headers xeh -- count of original lines

11033: AND xdl2.ae_header_id = xdl1.ae_header_id
11034: AND xdl2.temp_line_num = xdl2.ref_temp_line_num*-1
11035: AND xdl2.ref_ae_header_id <> xdl1.ref_ae_header_id
11036: AND xdl2.ref_event_id = xdl1.ref_event_id ) =
11037: (SELECT COUNT(*) FROM xla_distribution_links xdl3,xla_ae_headers xeh -- count of original lines
11038: WHERE xdl3.application_id = p_application_id
11039: AND xeh.application_id = p_application_id
11040: AND xdl3.ae_header_id = xeh.ae_header_id
11041: AND xdl3.event_id = xdl1.ref_event_id

Line 11055: xla_distribution_links xdl2

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
11059: AND xdl2.ae_header_id = xel.ae_header_id

Line 11160: FROM xla_distribution_links xdl1

11156: l_max_lin_id := NULL;
11157:
11158: SELECT MAX(xdl1.ref_ae_header_id) -- last recognition header
11159: INTO l_max_hdr_id
11160: FROM xla_distribution_links xdl1
11161: ,xla_ae_headers xeh1
11162: WHERE xdl1.application_id = p_application_id
11163: AND xdl1.ae_header_id = l_array_ae_header_id(i)
11164: AND xdl1.temp_line_num = xdl1.ref_temp_line_num*-1

Line 11204: ,xla_distribution_links xdl1

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
11208: AND xel2.ae_line_num = xdl1.ae_line_num

Line 11233: UPDATE xla_distribution_links xdl

11229:
11230: --------------------------------------------------------------------------------------------
11231: -- Update the DOC_ROUNDING values for the corresponding MPA line
11232: --------------------------------------------------------------------------------------------
11233: UPDATE xla_distribution_links xdl
11234: SET (doc_rounding_acctd_amt
11235: ,doc_rounding_entered_amt
11236: ,unrounded_entered_cr
11237: ,unrounded_entered_dr

Line 11254: ,xla_distribution_links xdl1

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
11258: AND xdl1.application_id = p_application_id

Line 11344: (p_msg => 'SQL - Insert into xla_distribution_links'

11340:
11341: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
11342:
11343: trace
11344: (p_msg => 'SQL - Insert into xla_distribution_links'
11345: ,p_level => C_LEVEL_EXCEPTION
11346: ,p_module => l_log_module);
11347:
11348: END IF;

Line 11352: INSERT INTO xla_distribution_links

11348: END IF;
11349:
11350: l_rowcount := 0;
11351:
11352: INSERT INTO xla_distribution_links
11353: (
11354: application_id
11355: , event_id
11356: , source_distribution_id_char_1

Line 11537: (p_msg => '# lines inserted into xla_distribution_links = '||l_rowcount

11533: l_rowcount:= SQL%ROWCOUNT;
11534:
11535: IF (C_LEVEL_EVENT >= g_log_level) THEN
11536: trace
11537: (p_msg => '# lines inserted into xla_distribution_links = '||l_rowcount
11538: ,p_level => C_LEVEL_EVENT
11539: ,p_module => l_log_module);
11540: END IF;
11541: