VIEW: HR.PAY_ELEMENT_ENTRIES_F#

Source

View Text - Preformatted

select ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID, ASSIGNMENT_ID ASSIGNMENT_ID, UPDATING_ACTION_ID UPDATING_ACTION_ID, ELEMENT_LINK_ID ELEMENT_LINK_ID, ORIGINAL_ENTRY_ID ORIGINAL_ENTRY_ID, CREATOR_TYPE CREATOR_TYPE, ENTRY_TYPE ENTRY_TYPE, COMMENT_ID COMMENT_ID, CREATOR_ID CREATOR_ID, REASON REASON, TARGET_ENTRY_ID TARGET_ENTRY_ID, SOURCE_ID SOURCE_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, ENTRY_INFORMATION_CATEGORY ENTRY_INFORMATION_CATEGORY, ENTRY_INFORMATION1 ENTRY_INFORMATION1, ENTRY_INFORMATION2 ENTRY_INFORMATION2, ENTRY_INFORMATION3 ENTRY_INFORMATION3, ENTRY_INFORMATION4 ENTRY_INFORMATION4, ENTRY_INFORMATION5 ENTRY_INFORMATION5, ENTRY_INFORMATION6 ENTRY_INFORMATION6, ENTRY_INFORMATION7 ENTRY_INFORMATION7, ENTRY_INFORMATION8 ENTRY_INFORMATION8, ENTRY_INFORMATION9 ENTRY_INFORMATION9, ENTRY_INFORMATION10 ENTRY_INFORMATION10, ENTRY_INFORMATION11 ENTRY_INFORMATION11, ENTRY_INFORMATION12 ENTRY_INFORMATION12, ENTRY_INFORMATION13 ENTRY_INFORMATION13, ENTRY_INFORMATION14 ENTRY_INFORMATION14, ENTRY_INFORMATION15 ENTRY_INFORMATION15, ENTRY_INFORMATION16 ENTRY_INFORMATION16, ENTRY_INFORMATION17 ENTRY_INFORMATION17, ENTRY_INFORMATION18 ENTRY_INFORMATION18, ENTRY_INFORMATION19 ENTRY_INFORMATION19, ENTRY_INFORMATION20 ENTRY_INFORMATION20, ENTRY_INFORMATION21 ENTRY_INFORMATION21, ENTRY_INFORMATION22 ENTRY_INFORMATION22, ENTRY_INFORMATION23 ENTRY_INFORMATION23, ENTRY_INFORMATION24 ENTRY_INFORMATION24, ENTRY_INFORMATION25 ENTRY_INFORMATION25, ENTRY_INFORMATION26 ENTRY_INFORMATION26, ENTRY_INFORMATION27 ENTRY_INFORMATION27, ENTRY_INFORMATION28 ENTRY_INFORMATION28, ENTRY_INFORMATION29 ENTRY_INFORMATION29, ENTRY_INFORMATION30 ENTRY_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, SUBPRIORITY SUBPRIORITY, PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID, DATE_EARNED DATE_EARNED, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, BALANCE_ADJ_COST_FLAG BALANCE_ADJ_COST_FLAG, SOURCE_ASG_ACTION_ID SOURCE_ASG_ACTION_ID, SOURCE_LINK_ID SOURCE_LINK_ID, SOURCE_TRIGGER_ENTRY SOURCE_TRIGGER_ENTRY, SOURCE_PERIOD SOURCE_PERIOD, SOURCE_RUN_TYPE SOURCE_RUN_TYPE, UPDATING_ACTION_TYPE UPDATING_ACTION_TYPE, SOURCE_START_DATE SOURCE_START_DATE, SOURCE_END_DATE SOURCE_END_DATE, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, ALL_ENTRY_VALUES_NULL ALL_ENTRY_VALUES_NULL, LABEL_IDENTIFIER LABEL_IDENTIFIER, PREV_UPD_ACTION_ID PREV_UPD_ACTION_ID from "HR"."PAY_ELEMENT_ENTRIES_F"

View Text - HTML Formatted

SELECT ELEMENT_ENTRY_ID ELEMENT_ENTRY_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, UPDATING_ACTION_ID UPDATING_ACTION_ID
, ELEMENT_LINK_ID ELEMENT_LINK_ID
, ORIGINAL_ENTRY_ID ORIGINAL_ENTRY_ID
, CREATOR_TYPE CREATOR_TYPE
, ENTRY_TYPE ENTRY_TYPE
, COMMENT_ID COMMENT_ID
, CREATOR_ID CREATOR_ID
, REASON REASON
, TARGET_ENTRY_ID TARGET_ENTRY_ID
, SOURCE_ID SOURCE_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, ENTRY_INFORMATION_CATEGORY ENTRY_INFORMATION_CATEGORY
, ENTRY_INFORMATION1 ENTRY_INFORMATION1
, ENTRY_INFORMATION2 ENTRY_INFORMATION2
, ENTRY_INFORMATION3 ENTRY_INFORMATION3
, ENTRY_INFORMATION4 ENTRY_INFORMATION4
, ENTRY_INFORMATION5 ENTRY_INFORMATION5
, ENTRY_INFORMATION6 ENTRY_INFORMATION6
, ENTRY_INFORMATION7 ENTRY_INFORMATION7
, ENTRY_INFORMATION8 ENTRY_INFORMATION8
, ENTRY_INFORMATION9 ENTRY_INFORMATION9
, ENTRY_INFORMATION10 ENTRY_INFORMATION10
, ENTRY_INFORMATION11 ENTRY_INFORMATION11
, ENTRY_INFORMATION12 ENTRY_INFORMATION12
, ENTRY_INFORMATION13 ENTRY_INFORMATION13
, ENTRY_INFORMATION14 ENTRY_INFORMATION14
, ENTRY_INFORMATION15 ENTRY_INFORMATION15
, ENTRY_INFORMATION16 ENTRY_INFORMATION16
, ENTRY_INFORMATION17 ENTRY_INFORMATION17
, ENTRY_INFORMATION18 ENTRY_INFORMATION18
, ENTRY_INFORMATION19 ENTRY_INFORMATION19
, ENTRY_INFORMATION20 ENTRY_INFORMATION20
, ENTRY_INFORMATION21 ENTRY_INFORMATION21
, ENTRY_INFORMATION22 ENTRY_INFORMATION22
, ENTRY_INFORMATION23 ENTRY_INFORMATION23
, ENTRY_INFORMATION24 ENTRY_INFORMATION24
, ENTRY_INFORMATION25 ENTRY_INFORMATION25
, ENTRY_INFORMATION26 ENTRY_INFORMATION26
, ENTRY_INFORMATION27 ENTRY_INFORMATION27
, ENTRY_INFORMATION28 ENTRY_INFORMATION28
, ENTRY_INFORMATION29 ENTRY_INFORMATION29
, ENTRY_INFORMATION30 ENTRY_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
, SUBPRIORITY SUBPRIORITY
, PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID
, DATE_EARNED DATE_EARNED
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BALANCE_ADJ_COST_FLAG BALANCE_ADJ_COST_FLAG
, SOURCE_ASG_ACTION_ID SOURCE_ASG_ACTION_ID
, SOURCE_LINK_ID SOURCE_LINK_ID
, SOURCE_TRIGGER_ENTRY SOURCE_TRIGGER_ENTRY
, SOURCE_PERIOD SOURCE_PERIOD
, SOURCE_RUN_TYPE SOURCE_RUN_TYPE
, UPDATING_ACTION_TYPE UPDATING_ACTION_TYPE
, SOURCE_START_DATE SOURCE_START_DATE
, SOURCE_END_DATE SOURCE_END_DATE
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, ALL_ENTRY_VALUES_NULL ALL_ENTRY_VALUES_NULL
, LABEL_IDENTIFIER LABEL_IDENTIFIER
, PREV_UPD_ACTION_ID PREV_UPD_ACTION_ID
FROM "HR"."PAY_ELEMENT_ENTRIES_F"