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
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
|
|
|