View: XLA_DIAG_NUMBERS_V

Product:	XLA - Subledger Accounting
Description:	This view retrieves the different transaction numbers for an event stored in XLA_DIAG_EVENTS table. This view is defined for the XLA_DIAG_TRANS_NUMBERS value set defined for the Transaction Object Diagnostics concurrent request.
Implementation/DBA Data:	APPS.XLA_DIAG_NUMBERS_V

View Text

SELECT A.APPLICATION_ID APPLICATION_ID
, A.LEDGER_ID LEDGER_ID
, A.ENTITY_CODE ENTITY_CODE
, A.EVENT_CLASS_CODE EVENT_CLASS_CODE
, A.EVENT_TYPE_CODE EVENT_TYPE_CODE
, A.TRANSACTION_NUMBER TRANSACTION_NUMBER
FROM XLA_DIAG_EVENTS A GROUP BY A.APPLICATION_ID
, A.LEDGER_ID
, A.ENTITY_CODE
, A.EVENT_CLASS_CODE
, A.EVENT_TYPE_CODE
, A.TRANSACTION_NUMBER

Columns