test

➜ Back to Library
Description
select 
xal.code_combination_id,
xal.accounting_class_code,
xal.accounted_dr,
xal.accounted_cr,
xal.entered_dr,
xal.entered_cr,
xah.accounting_date
from 
xla_ae_headers xah,
xla_ae_lines xal,
xla_transaction_entities xte
where
xte.entity_code='TRANSACTIONS' and
xte.application_id=xah.application_id and
xte.entity_id=xah.entity_id and
xah.ae_header_id=xal.ae_header_id and
xah.application_id=xal.application_id and
xah.application_id=222 and
xal.accounting_class_code='RECEIVABLE' and
xte.ledger_id=1 and
nvl(xte.source_id_int_1, -99)=1333285
Download
Related Blitz Reports
XLA Third Party Balances GMF Create Accounting PA Create Accounting AP Invoice History Report- Not Supported: Reserved For Future Use XLA Distribution Links Summary LSE: INV Material Account Distribution Detail JA India - Creditors Ledger- Not Supported: Reserved For Future Use JA Third Party Detail Trial Balance with Contra Accounts TB GL Account Analysis (Drilldown)v2 GL Category and subledger entities
Blitz Report™