VIEW: APPS.PAY_STAT_TRANS_AUDIT_DFV

Source

View Text - Preformatted

SELECT ROWID, AUDIT_INFORMATION_CATEGORY, (DECODE (AUDIT_INFORMATION_CATEGORY, 'W4 State', AUDIT_INFORMATION1, 'W4 FED', AUDIT_INFORMATION1, NULL)), (DECODE (AUDIT_INFORMATION_CATEGORY, 'W4 State', AUDIT_INFORMATION2, 'W4 FED', AUDIT_INFORMATION2, NULL)), (DECODE (AUDIT_INFORMATION_CATEGORY, 'W4 State', AUDIT_INFORMATION3, 'W4 FED', AUDIT_INFORMATION3, NULL)), (DECODE (AUDIT_INFORMATION_CATEGORY, 'W4 State', AUDIT_INFORMATION4, 'W4 FED', AUDIT_INFORMATION4, NULL)), AUDIT_INFORMATION5,  
 (DECODE (AUDIT_INFORMATION_CATEGORY,  
      'W4 FED', AUDIT_INFORMATION_CATEGORY || '.' || AUDIT_INFORMATION1 || '.' || AUDIT_INFORMATION2 || '.' || AUDIT_INFORMATION3 || '.' || AUDIT_INFORMATION4 || '.' || AUDIT_INFORMATION5,  
      'W4 State', AUDIT_INFORMATION_CATEGORY || '.' || AUDIT_INFORMATION1 || '.' || AUDIT_INFORMATION2 || '.' || AUDIT_INFORMATION3 || '.' || AUDIT_INFORMATION4, NULL)) 
 FROM PAY_STAT_TRANS_AUDIT

View Text - HTML Formatted

SELECT ROWID
, AUDIT_INFORMATION_CATEGORY
, (DECODE (AUDIT_INFORMATION_CATEGORY
, 'W4 STATE'
, AUDIT_INFORMATION1
, 'W4 FED'
, AUDIT_INFORMATION1
, NULL))
, (DECODE (AUDIT_INFORMATION_CATEGORY
, 'W4 STATE'
, AUDIT_INFORMATION2
, 'W4 FED'
, AUDIT_INFORMATION2
, NULL))
, (DECODE (AUDIT_INFORMATION_CATEGORY
, 'W4 STATE'
, AUDIT_INFORMATION3
, 'W4 FED'
, AUDIT_INFORMATION3
, NULL))
, (DECODE (AUDIT_INFORMATION_CATEGORY
, 'W4 STATE'
, AUDIT_INFORMATION4
, 'W4 FED'
, AUDIT_INFORMATION4
, NULL))
, AUDIT_INFORMATION5
, (DECODE (AUDIT_INFORMATION_CATEGORY
, 'W4 FED'
, AUDIT_INFORMATION_CATEGORY || '.' || AUDIT_INFORMATION1 || '.' || AUDIT_INFORMATION2 || '.' || AUDIT_INFORMATION3 || '.' || AUDIT_INFORMATION4 || '.' || AUDIT_INFORMATION5
, 'W4 STATE'
, AUDIT_INFORMATION_CATEGORY || '.' || AUDIT_INFORMATION1 || '.' || AUDIT_INFORMATION2 || '.' || AUDIT_INFORMATION3 || '.' || AUDIT_INFORMATION4
, NULL))
FROM PAY_STAT_TRANS_AUDIT