[Home] [Help]
30: | 06-MAI-2003 K.Boussema Modifcation included for bug2936071 |
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: | 20-MAI-2003 K.Boussema Added a Token to XLA_AP_CANNOT_INSERT_JE |
37: | message |
38: | 27-MAI-2003 K.Boussema Renamed the Document seq. Accounting sources |
99: | bug 3786980 |
100: | 23-Sep-2004 S.Singhania Made changes for the bulk peroformance. It has |
101: | changed the code at number of places. |
102: | 25-May-2005 W. Shen Remove column ledger_amount,entered amount |
103: | from xla_distribution_links, change the |
104: | function change_third_party to remove the |
105: | reference to the columns. |
106: | 11-Jul-2005 A. Wan Changed for MPA. 4262811 |
107: | 01-Aug-2005 W. Chan 4458381 - Public Sector Enhancement |
2588: , 0 -- 5100860 assign value to avoid using function index
2589: --
2590: FROM xla_ae_lines xal,
2591: xla_ae_headers xah,
2592: xla_distribution_links xdl,
2593: xla_events xe,
2594: (SELECT ae_header_id
2595: ,ae_line_num
2596: ,MAX(DECODE(rank,1,anc_id)) anc_id_1
2913: , 0 -- 5100860 assign value to avoid using function index
2914: --
2915: FROM xla_ae_lines xal,
2916: xla_ae_headers xah,
2917: xla_distribution_links xdl,
2918: xla_events xe
2919: WHERE xe.event_id = xdl.event_id
2920: AND xe.event_id = xah.event_id
2921: AND xal.ae_header_id = xdl.ae_header_id