DBA Data[Home] [Help]

APPS.JAI_CMN_RGM_PROCESSING_PKG dependencies on XLA_TRANSACTION_ENTITIES

Line 66: (2) Also added xla_transaction_entities to get the entity_id

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.
69: (3) Discussed with shekhar and found that we should derive by
70: accounting_date and not on the creation_date.

Line 847: (2) Also added xla_transaction_entities to get the entity_id and

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.
851: (4) Added accounting_event_id in cursor

Line 871: xla_transaction_entities xte,

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
875: AND xah.ledger_id = cp_sob_id