[Home] [Help]
25: | 06-MAI-2003 K.Boussema Modified to fix bug 2936066(Unbalanced JE) |
26: | 13-MAI-2003 K.Boussema Renamed temporary tables xla_je_lines_gt by |
27: | xla_ae_lines_gt, xla_je_headers_gt by |
28: | xla_ae_headers_gt |
29: | Renamed in xla_distribution_links the column |
30: | base_amount by ledger_amount |
31: | 20-MAI-2003 K.Boussema Added a Token to XLA_AP_CANNOT_INSERT_JE |
32: | message |
33: | 27-MAI-2003 K.Boussema Renamed code_combination_status by |
110: | 03-Nov-2004 S.Singhania Bug 3984919. Fixed the technical problem in |
111: | AccountingReversal. |
112: | Also modified the insert statments in |
113: | AccountingRevesal to use amounts from |
114: | xla_distribution_links instead of amounts |
115: | from xla_ae_lines table. |
116: | 09-MAR-2005 W.Shen Ledger Currency Project. |
117: | 14-Mar-2005 K.Boussema Changed for ADR-enhancements. |
118: | 28-Mar-2005 A.Wan Changed for Business Flow. |
265: | details in FUNCTION InsertLines for |
266: | merging lines issue between Primary |
267: | and Secondary Ledgers |
268: | 30-Mar-2010 M.S.Narayanan 9352035 Changed BusinessFlowPriorEntries to store|
269: | exchange rate derived from xla_distribution_links|
270: | of upstream transactions. This derived exchange rate|
271: | is used for accounted amount calculation of downstream|
272: | transactions whose corresponding upstream|
273: | transactions are merged to zero. |
5581: FROM
5582: xla_ae_lines_gt lgt
5583: ,xla_ae_lines ael
5584: ,xla_ae_headers aeh
5585: ,xla_distribution_links xdl
5586: WHERE xdl.application_id = l_application_id
5587: AND xdl.source_distribution_type = lgt.reverse_distribution_type
5588: AND lgt.reversal_code = 'DUMMY_LR'
5589: AND xdl.source_distribution_id_num_1 = lgt.reverse_dist_id_num_1 -- 5479652
6046: null) analytical_balance_flag -- Bug 7382288
6047: ,nvl2(ael.analytical_balance_flag, 'DUMMY_ANC_'||ael.ae_header_id||ael.ae_line_num,null) ANC_ID_1 --Bug 8691573
6048: FROM
6049: xla_ae_lines_gt lgt
6050: ,xla_distribution_links xdl
6051: ,xla_ae_lines ael
6052: ,xla_ae_headers aeh
6053: ,fnd_currencies fcu
6054: ,xla_events evt
6077: AND fcu.currency_code = ael.currency_code
6078: -- lines that have been reversed before in previous run are not reversed again
6079: AND NOT EXISTS (
6080: SELECT /*+ no_unnest */ 1
6081: FROM xla_distribution_links
6082: WHERE ref_ae_header_id = xdl.ae_header_id
6083: AND temp_line_num = xdl.temp_line_num * -1
6084: AND application_id = xdl.application_id
6085: )
7332: , alloc_to_dist_id_num_5 -- 4955764
7333: , analytical_balance_flag --8417496
7334: ,ANC_ID_1 -- 8691573
7335: )
7336: SELECT /*+ index(xdl XLA_DISTRIBUTION_LINKS_N3) */
7337: -- populates ae_header_id which is same as event_id till this point
7338: l_array_event_id(i)
7339: -- populates temp_line_num which is (-ve) of original line
7340: ,0 - xdl.temp_line_num
7514:
7515: FROM
7516: xla_ae_lines ael
7517: ,xla_ae_headers aeh
7518: ,xla_distribution_links xdl
7519: ,fnd_currencies fcu
7520: ,xla_events xe
7521: WHERE aeh.application_id = l_application_id
7522: AND aeh.ledger_id = l_array_ledger_id(i)
7532: AND ael.ae_line_num = xdl.ae_line_num
7533: AND ael.currency_code = fcu.currency_code
7534: AND NOT EXISTS (
7535: SELECT /*+ no_unnest */ 1
7536: FROM xla_distribution_links
7537: WHERE ref_ae_header_id = xdl.ae_header_id
7538: AND temp_line_num = xdl.temp_line_num * -1
7539: AND application_id = xdl.application_id
7540: )
11619: ) DERIVED_EXCH_RATE
11620: FROM xla_ae_lines_gt xalg
11621: ,xla_transaction_entities xte
11622: ,xla_ae_headers xah
11623: ,xla_distribution_links xdl
11624: ,xla_ae_lines xal
11625: --Added for bug 12379106
11626: ,xla_events xe
11627: -- ,xla_ledger_relationships_v xlr
11655: -- exclude reversed entries
11656: -- When running in BC mode, draft reversal entries are not considered
11657: -- ignore exclude reversal for AP.6647974/6614418
11658: AND NOT EXISTS (SELECT /*+ no_unnest */ 1
11659: FROM xla_distribution_links xdl4
11660: , xla_ae_headers xah4
11661: WHERE xdl4.ref_ae_header_id = xdl.ae_header_id
11662: AND xdl4.application_id = xdl.application_id
11663: AND xdl4.temp_line_num = xdl.temp_line_num * -1
12080: DECODE(xalg.bflow_applied_to_amount, NULL, 'X', xah3.accounting_entry_status_code))) -- 5132302
12081: ,MIN(xah3.entity_id)
12082: FROM xla_ae_lines xal3
12083: , xla_ae_headers xah3
12084: , xla_distribution_links xdl3
12085: WHERE xah3.application_id = xdl3.application_id
12086: AND xah3.ae_header_id = xdl3.ae_header_id
12087: AND xal3.application_id = xdl3.application_id
12088: AND xal3.ae_header_id = xdl3.ae_header_id
12101: AND NVL(xdl3.source_distribution_id_char_5,C_CHAR) = NVL(xalg.bflow_dist_id_char_5,C_CHAR)
12102: AND xah3.parent_ae_header_id IS NULL -- 4655713b MPA/Accrual Reversal lines cannot be used as prior entries
12103: -- exclude reversed entries
12104: AND NOT EXISTS (SELECT 1
12105: FROM xla_distribution_links xdl4
12106: , xla_ae_headers xah4
12107: WHERE xdl4.ref_ae_header_id = xdl3.ae_header_id
12108: AND xdl4.temp_line_num = xdl3.temp_line_num * -1
12109: AND xah4.application_id = xdl4.application_id
12116: AND xdl3.ae_header_id =
12117: (SELECT MAX(xdl.ae_header_id)
12118: FROM xla_transaction_entities xte
12119: , xla_ae_headers xah
12120: , xla_distribution_links xdl
12121: , xla_ae_lines xal
12122: , xla_ledger_relationships_v xlr -- 4478604
12123: , xla_gl_ledgers_v xgl -- 4478604
12124: , xla_ledger_options xlo -- 5204178
12175: AND xah.accounting_entry_status_code IN ('F', DECODE(p_bc_mode,'NONE',p_accounting_mode,'F'))
12176: -- exclude reversed entries
12177: -- When running in BC mode, draft reversal entries are not considered
12178: AND NOT EXISTS (SELECT 1
12179: FROM xla_distribution_links xdl2
12180: , xla_ae_headers xah2
12181: WHERE xdl2.ref_ae_header_id = xdl.ae_header_id
12182: AND xdl2.temp_line_num = xdl.temp_line_num * -1
12183: AND xah2.application_id = xdl2.application_id