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_LINES_PKG dependencies on XLA_DISTRIBUTION_LINKS

Line 29: | Renamed in xla_distribution_links the column |

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 |

Line 114: | xla_distribution_links instead of amounts |

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. |

Line 5475: ,xla_distribution_links xdl

5471: FROM
5472: xla_ae_lines_gt lgt
5473: ,xla_ae_lines ael
5474: ,xla_ae_headers aeh
5475: ,xla_distribution_links xdl
5476: WHERE xdl.application_id = l_application_id
5477: AND xdl.source_distribution_type = lgt.reverse_distribution_type
5478: AND lgt.reversal_code = 'DUMMY_LR'
5479: AND xdl.source_distribution_id_num_1 = lgt.reverse_dist_id_num_1 -- 5479652

Line 5918: ,xla_distribution_links xdl

5914: 'P','Y',
5915: null) analytical_balance_flag -- Bug 7382288
5916: FROM
5917: xla_ae_lines_gt lgt
5918: ,xla_distribution_links xdl
5919: ,xla_ae_lines ael
5920: ,xla_ae_headers aeh
5921: ,fnd_currencies fcu
5922: ,xla_events evt

Line 5949: FROM xla_distribution_links

5945: AND fcu.currency_code = ael.currency_code
5946: -- lines that have been reversed before in previous run are not reversed again
5947: AND NOT EXISTS (
5948: SELECT /*+ no_unnest */ 1
5949: FROM xla_distribution_links
5950: WHERE ref_ae_header_id = xdl.ae_header_id
5951: AND temp_line_num = xdl.temp_line_num * -1
5952: AND application_id = xdl.application_id
5953: )

Line 7152: ,xla_distribution_links xdl

7148: , xdl.alloc_to_dist_id_num_5 alloc_to_dist_id_num_5
7149: FROM
7150: xla_ae_lines ael
7151: ,xla_ae_headers aeh
7152: ,xla_distribution_links xdl
7153: ,fnd_currencies fcu
7154: ,xla_events xe
7155: WHERE aeh.application_id = l_application_id
7156: AND aeh.ledger_id = l_array_ledger_id(i)

Line 7169: FROM xla_distribution_links

7165: AND ael.ae_line_num = xdl.ae_line_num
7166: AND ael.currency_code = fcu.currency_code
7167: AND NOT EXISTS (
7168: SELECT /*+ no_unnest */ 1
7169: FROM xla_distribution_links
7170: WHERE ref_ae_header_id = xdl.ae_header_id
7171: AND temp_line_num = xdl.temp_line_num * -1
7172: AND application_id = xdl.application_id
7173: )

Line 11203: ,xla_distribution_links xdl

11199: ,(xah.entity_id) applied_to_entity_id
11200: FROM xla_ae_lines_gt xalg
11201: ,xla_transaction_entities xte
11202: ,xla_ae_headers xah
11203: ,xla_distribution_links xdl
11204: ,xla_ae_lines xal
11205: -- ,xla_ledger_relationships_v xlr
11206: -- ,xla_gl_ledgers_v xgl
11207: -- ,xla_ledger_options xlo

Line 11231: FROM xla_distribution_links xdl4

11227: -- exclude reversed entries
11228: -- When running in BC mode, draft reversal entries are not considered
11229: -- ignore exclude reversal for AP.6647974/6614418
11230: AND NOT EXISTS (SELECT /*+ no_unnest */ 1
11231: FROM xla_distribution_links xdl4
11232: , xla_ae_headers xah4
11233: WHERE xdl4.ref_ae_header_id = xdl.ae_header_id
11234: AND xdl4.application_id = xdl.application_id
11235: AND xdl4.temp_line_num = xdl.temp_line_num * -1

Line 11638: , xla_distribution_links xdl3

11634: DECODE(xalg.bflow_applied_to_amount, NULL, 'X', xah3.accounting_entry_status_code))) -- 5132302
11635: ,MIN(xah3.entity_id)
11636: FROM xla_ae_lines xal3
11637: , xla_ae_headers xah3
11638: , xla_distribution_links xdl3
11639: WHERE xah3.application_id = xdl3.application_id
11640: AND xah3.ae_header_id = xdl3.ae_header_id
11641: AND xal3.application_id = xdl3.application_id
11642: AND xal3.ae_header_id = xdl3.ae_header_id

Line 11659: FROM xla_distribution_links xdl4

11655: AND NVL(xdl3.source_distribution_id_char_5,C_CHAR) = NVL(xalg.bflow_dist_id_char_5,C_CHAR)
11656: AND xah3.parent_ae_header_id IS NULL -- 4655713b MPA/Accrual Reversal lines cannot be used as prior entries
11657: -- exclude reversed entries
11658: AND NOT EXISTS (SELECT 1
11659: FROM xla_distribution_links xdl4
11660: , xla_ae_headers xah4
11661: WHERE xdl4.ref_ae_header_id = xdl3.ae_header_id
11662: AND xdl4.temp_line_num = xdl3.temp_line_num * -1
11663: AND xah4.application_id = xdl4.application_id

Line 11674: , xla_distribution_links xdl

11670: AND xdl3.ae_header_id =
11671: (SELECT MAX(xdl.ae_header_id)
11672: FROM xla_transaction_entities xte
11673: , xla_ae_headers xah
11674: , xla_distribution_links xdl
11675: , xla_ae_lines xal
11676: , xla_ledger_relationships_v xlr -- 4478604
11677: , xla_gl_ledgers_v xgl -- 4478604
11678: , xla_ledger_options xlo -- 5204178

Line 11733: FROM xla_distribution_links xdl2

11729: AND xah.accounting_entry_status_code IN ('F', DECODE(p_bc_mode,'NONE',p_accounting_mode,'F'))
11730: -- exclude reversed entries
11731: -- When running in BC mode, draft reversal entries are not considered
11732: AND NOT EXISTS (SELECT 1
11733: FROM xla_distribution_links xdl2
11734: , xla_ae_headers xah2
11735: WHERE xdl2.ref_ae_header_id = xdl.ae_header_id
11736: AND xdl2.temp_line_num = xdl.temp_line_num * -1
11737: AND xah2.application_id = xdl2.application_id