VIEW: HR.PAY_STAT_TRANS_AUDIT#

Source

View Text - Preformatted

select STAT_TRANS_AUDIT_ID STAT_TRANS_AUDIT_ID, TRANSACTION_TYPE TRANSACTION_TYPE, TRANSACTION_SUBTYPE TRANSACTION_SUBTYPE, TRANSACTION_DATE TRANSACTION_DATE, TRANSACTION_EFFECTIVE_DATE TRANSACTION_EFFECTIVE_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID, SOURCE1 SOURCE1, SOURCE1_TYPE SOURCE1_TYPE, SOURCE2 SOURCE2, SOURCE2_TYPE SOURCE2_TYPE, SOURCE3 SOURCE3, SOURCE3_TYPE SOURCE3_TYPE, SOURCE4 SOURCE4, SOURCE4_TYPE SOURCE4_TYPE, SOURCE5 SOURCE5, SOURCE5_TYPE SOURCE5_TYPE, TRANSACTION_PARENT_ID TRANSACTION_PARENT_ID, AUDIT_INFORMATION_CATEGORY AUDIT_INFORMATION_CATEGORY, AUDIT_INFORMATION1 AUDIT_INFORMATION1, AUDIT_INFORMATION2 AUDIT_INFORMATION2, AUDIT_INFORMATION3 AUDIT_INFORMATION3, AUDIT_INFORMATION4 AUDIT_INFORMATION4, AUDIT_INFORMATION5 AUDIT_INFORMATION5, AUDIT_INFORMATION6 AUDIT_INFORMATION6, AUDIT_INFORMATION7 AUDIT_INFORMATION7, AUDIT_INFORMATION8 AUDIT_INFORMATION8, AUDIT_INFORMATION9 AUDIT_INFORMATION9, AUDIT_INFORMATION10 AUDIT_INFORMATION10, AUDIT_INFORMATION11 AUDIT_INFORMATION11, AUDIT_INFORMATION12 AUDIT_INFORMATION12, AUDIT_INFORMATION13 AUDIT_INFORMATION13, AUDIT_INFORMATION14 AUDIT_INFORMATION14, AUDIT_INFORMATION15 AUDIT_INFORMATION15, AUDIT_INFORMATION16 AUDIT_INFORMATION16, AUDIT_INFORMATION17 AUDIT_INFORMATION17, AUDIT_INFORMATION18 AUDIT_INFORMATION18, AUDIT_INFORMATION19 AUDIT_INFORMATION19, AUDIT_INFORMATION20 AUDIT_INFORMATION20, AUDIT_INFORMATION21 AUDIT_INFORMATION21, AUDIT_INFORMATION22 AUDIT_INFORMATION22, AUDIT_INFORMATION23 AUDIT_INFORMATION23, AUDIT_INFORMATION24 AUDIT_INFORMATION24, AUDIT_INFORMATION25 AUDIT_INFORMATION25, AUDIT_INFORMATION26 AUDIT_INFORMATION26, AUDIT_INFORMATION27 AUDIT_INFORMATION27, AUDIT_INFORMATION28 AUDIT_INFORMATION28, AUDIT_INFORMATION29 AUDIT_INFORMATION29, AUDIT_INFORMATION30 AUDIT_INFORMATION30, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, TITLE TITLE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER from "HR"."PAY_STAT_TRANS_AUDIT"

View Text - HTML Formatted

SELECT STAT_TRANS_AUDIT_ID STAT_TRANS_AUDIT_ID
, TRANSACTION_TYPE TRANSACTION_TYPE
, TRANSACTION_SUBTYPE TRANSACTION_SUBTYPE
, TRANSACTION_DATE TRANSACTION_DATE
, TRANSACTION_EFFECTIVE_DATE TRANSACTION_EFFECTIVE_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, SOURCE1 SOURCE1
, SOURCE1_TYPE SOURCE1_TYPE
, SOURCE2 SOURCE2
, SOURCE2_TYPE SOURCE2_TYPE
, SOURCE3 SOURCE3
, SOURCE3_TYPE SOURCE3_TYPE
, SOURCE4 SOURCE4
, SOURCE4_TYPE SOURCE4_TYPE
, SOURCE5 SOURCE5
, SOURCE5_TYPE SOURCE5_TYPE
, TRANSACTION_PARENT_ID TRANSACTION_PARENT_ID
, AUDIT_INFORMATION_CATEGORY AUDIT_INFORMATION_CATEGORY
, AUDIT_INFORMATION1 AUDIT_INFORMATION1
, AUDIT_INFORMATION2 AUDIT_INFORMATION2
, AUDIT_INFORMATION3 AUDIT_INFORMATION3
, AUDIT_INFORMATION4 AUDIT_INFORMATION4
, AUDIT_INFORMATION5 AUDIT_INFORMATION5
, AUDIT_INFORMATION6 AUDIT_INFORMATION6
, AUDIT_INFORMATION7 AUDIT_INFORMATION7
, AUDIT_INFORMATION8 AUDIT_INFORMATION8
, AUDIT_INFORMATION9 AUDIT_INFORMATION9
, AUDIT_INFORMATION10 AUDIT_INFORMATION10
, AUDIT_INFORMATION11 AUDIT_INFORMATION11
, AUDIT_INFORMATION12 AUDIT_INFORMATION12
, AUDIT_INFORMATION13 AUDIT_INFORMATION13
, AUDIT_INFORMATION14 AUDIT_INFORMATION14
, AUDIT_INFORMATION15 AUDIT_INFORMATION15
, AUDIT_INFORMATION16 AUDIT_INFORMATION16
, AUDIT_INFORMATION17 AUDIT_INFORMATION17
, AUDIT_INFORMATION18 AUDIT_INFORMATION18
, AUDIT_INFORMATION19 AUDIT_INFORMATION19
, AUDIT_INFORMATION20 AUDIT_INFORMATION20
, AUDIT_INFORMATION21 AUDIT_INFORMATION21
, AUDIT_INFORMATION22 AUDIT_INFORMATION22
, AUDIT_INFORMATION23 AUDIT_INFORMATION23
, AUDIT_INFORMATION24 AUDIT_INFORMATION24
, AUDIT_INFORMATION25 AUDIT_INFORMATION25
, AUDIT_INFORMATION26 AUDIT_INFORMATION26
, AUDIT_INFORMATION27 AUDIT_INFORMATION27
, AUDIT_INFORMATION28 AUDIT_INFORMATION28
, AUDIT_INFORMATION29 AUDIT_INFORMATION29
, AUDIT_INFORMATION30 AUDIT_INFORMATION30
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, TITLE TITLE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
FROM "HR"."PAY_STAT_TRANS_AUDIT"