applications audit table

Asagidaki query ile Applications'taki Audit tutulan tablolari
listeyebilirsiniz.

select fag.GROUP_NAME
, ft.TABLE_NAME
, fc.COLUMN_SEQUENCE
, fc.COLUMN_NAME
from fnd_audit_tables fat
, fnd_audit_columns fac
, fnd_tables ft
, fnd_columns fc
, fnd_audit_groups fag
where fat.TABLE_ID = ft.TABLE_ID
and fat.TABLE_APP_ID = ft.APPLICATION_ID
and fat.TABLE_ID = fac.TABLE_ID
and fat.TABLE_APP_ID = fac.TABLE_APP_ID
and fac.COLUMN_ID = fc.COLUMN_ID
and fat.AUDIT_GROUP_ID = fag.AUDIT_GROUP_ID
and fag.STATE = 'E'
and fac.SCHEMA_ID = 900
order by 1, 2 , 3 , 4