VIEW: HR.PAY_BATCH_LINES#

Source

View Text - Preformatted

select BATCH_LINE_ID BATCH_LINE_ID, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, ASSIGNMENT_ID ASSIGNMENT_ID, BATCH_ID BATCH_ID, BATCH_LINE_STATUS BATCH_LINE_STATUS, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER, BATCH_SEQUENCE BATCH_SEQUENCE, CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS, EFFECTIVE_DATE EFFECTIVE_DATE, ELEMENT_NAME ELEMENT_NAME, ENTRY_TYPE ENTRY_TYPE, REASON REASON, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, SEGMENT11 SEGMENT11, SEGMENT12 SEGMENT12, SEGMENT13 SEGMENT13, SEGMENT14 SEGMENT14, SEGMENT15 SEGMENT15, SEGMENT16 SEGMENT16, SEGMENT17 SEGMENT17, SEGMENT18 SEGMENT18, SEGMENT19 SEGMENT19, SEGMENT20 SEGMENT20, SEGMENT21 SEGMENT21, SEGMENT22 SEGMENT22, SEGMENT23 SEGMENT23, SEGMENT24 SEGMENT24, SEGMENT25 SEGMENT25, SEGMENT26 SEGMENT26, SEGMENT27 SEGMENT27, SEGMENT28 SEGMENT28, SEGMENT29 SEGMENT29, SEGMENT30 SEGMENT30, VALUE_1 VALUE_1, VALUE_2 VALUE_2, VALUE_3 VALUE_3, VALUE_4 VALUE_4, VALUE_5 VALUE_5, VALUE_6 VALUE_6, VALUE_7 VALUE_7, VALUE_8 VALUE_8, VALUE_9 VALUE_9, VALUE_10 VALUE_10, VALUE_11 VALUE_11, VALUE_12 VALUE_12, VALUE_13 VALUE_13, VALUE_14 VALUE_14, VALUE_15 VALUE_15, 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, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, DATE_EARNED DATE_EARNED, PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID, SUBPRIORITY SUBPRIORITY from "HR"."PAY_BATCH_LINES"

View Text - HTML Formatted

SELECT BATCH_LINE_ID BATCH_LINE_ID
, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, BATCH_ID BATCH_ID
, BATCH_LINE_STATUS BATCH_LINE_STATUS
, ASSIGNMENT_NUMBER ASSIGNMENT_NUMBER
, BATCH_SEQUENCE BATCH_SEQUENCE
, CONCATENATED_SEGMENTS CONCATENATED_SEGMENTS
, EFFECTIVE_DATE EFFECTIVE_DATE
, ELEMENT_NAME ELEMENT_NAME
, ENTRY_TYPE ENTRY_TYPE
, REASON REASON
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, SEGMENT11 SEGMENT11
, SEGMENT12 SEGMENT12
, SEGMENT13 SEGMENT13
, SEGMENT14 SEGMENT14
, SEGMENT15 SEGMENT15
, SEGMENT16 SEGMENT16
, SEGMENT17 SEGMENT17
, SEGMENT18 SEGMENT18
, SEGMENT19 SEGMENT19
, SEGMENT20 SEGMENT20
, SEGMENT21 SEGMENT21
, SEGMENT22 SEGMENT22
, SEGMENT23 SEGMENT23
, SEGMENT24 SEGMENT24
, SEGMENT25 SEGMENT25
, SEGMENT26 SEGMENT26
, SEGMENT27 SEGMENT27
, SEGMENT28 SEGMENT28
, SEGMENT29 SEGMENT29
, SEGMENT30 SEGMENT30
, VALUE_1 VALUE_1
, VALUE_2 VALUE_2
, VALUE_3 VALUE_3
, VALUE_4 VALUE_4
, VALUE_5 VALUE_5
, VALUE_6 VALUE_6
, VALUE_7 VALUE_7
, VALUE_8 VALUE_8
, VALUE_9 VALUE_9
, VALUE_10 VALUE_10
, VALUE_11 VALUE_11
, VALUE_12 VALUE_12
, VALUE_13 VALUE_13
, VALUE_14 VALUE_14
, VALUE_15 VALUE_15
, 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
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, DATE_EARNED DATE_EARNED
, PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID
, SUBPRIORITY SUBPRIORITY
FROM "HR"."PAY_BATCH_LINES"