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

11095: ------------------------------------------------------------
11096: -- Find the original amounts
11097: ------------------------------------------------------------
11098: FOR i IN 1..l_array_parent_hdr_idx.COUNT LOOP
11099: /* Excluding the join with XLA_DISTRIBUTION_LINKS bug:7230462 */
11100: -- SELECT NVL(l.entered_cr, l.entered_dr)
11101: -- ,NVL(l.accounted_cr, l.accounted_dr)
11102: -- ,NVL(l.unrounded_entered_cr, l.unrounded_entered_dr)
11103: -- ,NVL(l.unrounded_accounted_cr, l.unrounded_accounted_dr)

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

11105: -- ,l_array_accted_amt(i)
11106: -- ,l_array_unround_entered_amt(i)
11107: -- ,l_array_unround_accted_amt(i)
11108: -- FROM xla_ae_lines l,
11109: -- xla_distribution_links d -- added for bug 7377888
11110: -- /*WHERE ae_header_id = l_array_parent_hdr_idx(i)
11111: -- AND ae_line_num = l_array_parent_line_idx(i)
11112: -- AND application_id = p_application_id;*/ -- commented for bug 7377888
11113: -- WHERE l.ae_header_id = d.ae_header_id

Line 11233: -- UPDATE xla_distribution_links xdl

11229: AND ae_line_num = l_array_mpa_line_idx(j);
11230:
11231: FORALL j IN 1..l_array_mpa_header_idx.COUNT
11232: -- Begin Bug 14246749
11233: -- UPDATE xla_distribution_links xdl
11234: -- SET (unrounded_entered_cr
11235: -- ,unrounded_entered_dr
11236: -- ,unrounded_accounted_cr
11237: -- ,unrounded_accounted_dr) =

Line 11250: merge into xla_distribution_links xdl

11246: -- AND ae_header_id = l_array_mpa_header_idx(j)
11247: -- AND ae_line_num = l_array_mpa_line_idx(j);
11248: --
11249:
11250: merge into xla_distribution_links xdl
11251: using (SELECT unrounded_entered_cr
11252: ,unrounded_entered_dr
11253: ,unrounded_accounted_cr
11254: ,unrounded_accounted_dr

Line 11282: FROM xla_distribution_links xdlmp

11278: -- Parent accounting XDL,hence, MPA Accounting would be on the same SIDE of
11279: -- the Parent Accounting.
11280: SELECT xdlmp.ae_line_num
11281: INTO l_array_recog_line_num(i)
11282: FROM xla_distribution_links xdlmp
11283: WHERE xdlmp.application_id = p_application_id
11284: AND xdlmp.ae_header_id = l_array_max_hdr_idx(i)
11285: AND NOT EXISTS
11286: ( SELECT 1

Line 11287: FROM xla_distribution_links xdlp

11283: WHERE xdlmp.application_id = p_application_id
11284: AND xdlmp.ae_header_id = l_array_max_hdr_idx(i)
11285: AND NOT EXISTS
11286: ( SELECT 1
11287: FROM xla_distribution_links xdlp
11288: WHERE xdlp.application_id = p_application_id
11289: AND xdlp.ae_header_id = l_array_parent_hdr_idx(i)
11290: AND xdlp.ae_line_num = l_array_parent_line_idx(i)
11291: AND xdlp.accounting_line_code = xdlmp.accounting_line_code

Line 11473: UPDATE xla_distribution_links xdl

11469: --------------------------------------------------------------------------------------------
11470: -- Update the DOC_ROUNDING values for the corresponding MPA line
11471: --------------------------------------------------------------------------------------------
11472: FORALL i IN 1..l_array_parent_hdr_idx.COUNT
11473: UPDATE xla_distribution_links xdl
11474: SET (doc_rounding_acctd_amt
11475: ,doc_rounding_entered_amt
11476: ,unrounded_entered_cr -- 4669308
11477: ,unrounded_entered_dr -- 4669308

Line 11539: FROM xla_distribution_links xdl1

11535: ,MAX(xdl1.ae_line_num)
11536: ,xdl1.ae_header_id
11537: ,xdl1.ref_event_id
11538: ,xeh1.ledger_id
11539: FROM xla_distribution_links xdl1
11540: ,xla_ae_headers xeh1
11541: ,xla_ae_headers_gt xehg
11542: WHERE xdl1.application_id = p_application_id
11543: AND xeh1.application_id = p_application_id

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

11549: WHERE application_id = p_application_id
11550: AND parent_ae_header_id = xdl1.ref_ae_header_id
11551: AND parent_ae_line_num IS NOT NULL) -- MPA only, not for Accrual Reversal
11552: GROUP BY xdl1.ref_ae_header_id, xdl1.ref_event_id, xdl1.application_id, xeh1.ledger_id, xdl1.ae_header_id
11553: HAVING (SELECT COUNT(*) FROM xla_distribution_links xdl2 -- count of reversal lines
11554: WHERE xdl2.application_id = p_application_id
11555: AND xdl2.ae_header_id = xdl1.ae_header_id
11556: AND xdl2.temp_line_num = xdl2.ref_temp_line_num*-1
11557: AND xdl2.ref_ae_header_id <> xdl1.ref_ae_header_id

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

11555: AND xdl2.ae_header_id = xdl1.ae_header_id
11556: AND xdl2.temp_line_num = xdl2.ref_temp_line_num*-1
11557: AND xdl2.ref_ae_header_id <> xdl1.ref_ae_header_id
11558: AND xdl2.ref_event_id = xdl1.ref_event_id ) =
11559: (SELECT COUNT(*) FROM xla_distribution_links xdl3,xla_ae_headers xeh -- count of original lines
11560: WHERE xdl3.application_id = p_application_id
11561: AND xeh.application_id = p_application_id
11562: AND xdl3.ae_header_id = xeh.ae_header_id
11563: AND xdl3.event_id = xdl1.ref_event_id

Line 11577: xla_distribution_links xdl2

11573:
11574: CURSOR cur_last_mpa (l_ae_header NUMBER, l_max_ae_header NUMBER) is
11575: SELECT xel.rowid, xel.*
11576: FROM xla_ae_lines xel ,
11577: xla_distribution_links xdl2
11578: WHERE xel.application_id = p_application_id
11579: AND xel.ae_header_id = l_ae_header
11580: AND xdl2.application_id = p_application_id
11581: AND xdl2.ae_header_id = xel.ae_header_id

Line 11682: FROM xla_distribution_links xdl1

11678: l_max_lin_id := NULL;
11679:
11680: SELECT MAX(xdl1.ref_ae_header_id) -- last recognition header
11681: INTO l_max_hdr_id
11682: FROM xla_distribution_links xdl1
11683: ,xla_ae_headers xeh1
11684: WHERE xdl1.application_id = p_application_id
11685: AND xdl1.ae_header_id = l_array_ae_header_id(i)
11686: AND xdl1.temp_line_num = xdl1.ref_temp_line_num*-1

Line 11726: ,xla_distribution_links xdl1

11722: ,DECODE((l_last_mpa.unrounded_entered_dr), NULL,NULL, l_array_unround_entered_amt(i) - SUM(xel2.unrounded_entered_dr))
11723: ,DECODE((l_last_mpa.unrounded_accounted_cr), NULL,NULL, l_array_unround_accted_amt(i) - SUM(xel2.unrounded_accounted_cr))
11724: ,DECODE((l_last_mpa.unrounded_accounted_dr), NULL,NULL, l_array_unround_accted_amt(i) - SUM(xel2.unrounded_accounted_dr))
11725: FROM xla_ae_lines xel2
11726: ,xla_distribution_links xdl1
11727: ,xla_ae_headers xeh1
11728: WHERE xel2.application_id = p_application_id
11729: AND xel2.ae_header_id = xdl1.ae_header_id
11730: AND xel2.ae_line_num = xdl1.ae_line_num

Line 11755: UPDATE xla_distribution_links xdl

11751:
11752: --------------------------------------------------------------------------------------------
11753: -- Update the DOC_ROUNDING values for the corresponding MPA line
11754: --------------------------------------------------------------------------------------------
11755: UPDATE xla_distribution_links xdl
11756: SET (doc_rounding_acctd_amt
11757: ,doc_rounding_entered_amt
11758: ,unrounded_entered_cr
11759: ,unrounded_entered_dr

Line 11776: ,xla_distribution_links xdl1

11772: ,xel.unrounded_entered_dr
11773: ,xel.unrounded_accounted_cr
11774: ,xel.unrounded_accounted_dr
11775: FROM xla_ae_lines xel
11776: ,xla_distribution_links xdl1
11777: WHERE xel.application_id = p_application_id
11778: AND xel.ae_header_id = xdl1.ae_header_id
11779: AND xel.ae_line_num = xdl1.ae_line_num
11780: AND xdl1.application_id = p_application_id

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

11862:
11863: IF (C_LEVEL_EXCEPTION >= g_log_level) THEN
11864:
11865: trace
11866: (p_msg => 'SQL - Insert into xla_distribution_links'
11867: ,p_level => C_LEVEL_EXCEPTION
11868: ,p_module => l_log_module);
11869:
11870: END IF;

Line 11874: INSERT INTO xla_distribution_links

11870: END IF;
11871:
11872: l_rowcount := 0;
11873:
11874: INSERT INTO xla_distribution_links
11875: (
11876: application_id
11877: , event_id
11878: , source_distribution_id_char_1

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

12055: l_rowcount:= SQL%ROWCOUNT;
12056:
12057: IF (C_LEVEL_EVENT >= g_log_level) THEN
12058: trace
12059: (p_msg => '# lines inserted into xla_distribution_links = '||l_rowcount
12060: ,p_level => C_LEVEL_EVENT
12061: ,p_module => l_log_module);
12062: END IF;
12063: