DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on XLA_AE_HEADERS

Line 64: (1) Changed the reference to xla_ae_headers instead

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.

Line 846: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all

842:
843: /* Bug 4991017. Added by Lakshmi Gopalsami
844: Merged the cursors c_ap_accounted_invoices and c_event_distributions
845: because of SLA uptake by base and removed the same.
846: (1) Changed the reference to xla_ae_headers instead of ap_ae_headers_all
847: (2) Also added xla_transaction_entities to get the entity_id and
848: source_int_id_1 so that it can be joined with transaction tables.
849: (3) Discussed with shekhar and found that we should derive by
850: accounting_date and not on the creation_date.

Line 870: FROM xla_ae_headers xah ,

866: aid.org_id, aid.accounting_event_id,
867: ai.vendor_id, ai.vendor_site_id, ai.invoice_currency_code,
868: aid.exchange_rate, aid.exchange_rate_type, aid.exchange_date,
869: ai.source
870: FROM xla_ae_headers xah ,
871: xla_transaction_entities xte,
872: ap_invoices_all ai,
873: ap_invoice_distributions_all aid
874: WHERE xah.je_category_name = cp_ae_category