View: XLA_DIAG_LINES_V

Product:	XLA - Subledger Accounting
Description:	This view retrieves the different extract line numbers for an event identifier stored in XLA_DIAG_SOURCES. This view is defined for the XLA_DIAG_LINE_NUMBERS value set defined for the Transaction Object Diagnostics concurrent request.
Implementation/DBA Data:	APPS.XLA_DIAG_LINES_V

View Text

SELECT XEV.APPLICATION_ID APPLICATION_ID
, XEV.TRANSACTION_NUMBER TRANSACTION_NUMBER
, XEV.EVENT_NUMBER EVENT_NUMBER
, XES.LINE_NUMBER LINE_NUMBER
FROM XLA_DIAG_EVENTS XEV
, XLA_DIAG_SOURCES XES
WHERE XEV.EVENT_ID = XES.EVENT_ID (+)
AND XES.LINE_NUMBER IS NOT NULL GROUP BY XEV.APPLICATION_ID
, XEV.TRANSACTION_NUMBER
, XEV.EVENT_NUMBER
, XES.LINE_NUMBER

Columns