[Home] [Help]
60: 8. 24-Jan-2006 Bug 4991017. Added by Lakshmi Gopalsami version 120.4
61: Merged the cursors c_ap_accounted_invoices and
62: c_event_distributions because of SLA uptake by base
63: and removed the same.
64: (1) Changed the reference to xla_ae_headers instead
65: of ap_ae_headers_all
66: (2) Also added xla_transaction_entities to get the entity_id
67: and source_int_id_1 so that it can be joined with
68: transaction tables.
1819:
1820: /* Bug 4991017. Added by Lakshmi Gopalsami
1821: Merged the cursors c_ap_accounted_invoices and c_event_distributions
1822: because of SLA uptake by base and removed the same.
1823: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
1824: (2) Also added xla_transaction_entities to get the entity_id and
1825: source_int_id_1 so that it can be joined with transaction tables.
1826: (3) Discussed with shekhar and found that we should derive by
1827: accounting_date and not on the creation_date.
1844: ai.vendor_id, ai.vendor_site_id, ai.invoice_currency_code,
1845: aid.exchange_rate, aid.exchange_rate_type, aid.exchange_date,
1846: ai.source
1847: ,aid.accounting_date --Added by zhiwei for POT change Bug#13023443 on 20110930
1848: FROM xla_ae_headers xah ,
1849: xla_transaction_entities xte,
1850: ap_invoices_all ai,
1851: ap_invoice_distributions_all aid
1852: WHERE xah.je_category_name = cp_ae_category
4441: , ai.invoice_type_lookup_code
4442: , ai.invoice_date
4443: , aid.accounting_date
4444: , ai.cancelled_date
4445: FROM xla_ae_headers xah
4446: , xla_transaction_entities xte
4447: , ap_invoices_all ai
4448: , ap_invoice_distributions_all aid
4449: WHERE xah.je_category_name = cp_ae_category