VIEW: HR.PAY_PSS_TRANSACTION_STEPS#

Source

View Text - Preformatted

select TRANSACTION_STEP_ID TRANSACTION_STEP_ID, TRANSACTION_ID TRANSACTION_ID, SOURCE_TABLE SOURCE_TABLE, STATE STATE, PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID, UPDATE_OVN UPDATE_OVN, DELETE_OVN DELETE_OVN, UPDATE_DATETRACK_MODE UPDATE_DATETRACK_MODE, DELETE_DATETRACK_MODE DELETE_DATETRACK_MODE, DELETE_DISABLED DELETE_DISABLED, EFFECTIVE_DATE EFFECTIVE_DATE, ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID, ASSIGNMENT_ID ASSIGNMENT_ID, PAYMENT_TYPE PAYMENT_TYPE, CURRENCY_CODE CURRENCY_CODE, TERRITORY_CODE TERRITORY_CODE, REAL_PRIORITY REAL_PRIORITY, LOGICAL_PRIORITY LOGICAL_PRIORITY, AMOUNT_TYPE AMOUNT_TYPE, AMOUNT AMOUNT, EXTERNAL_ACCOUNT_ID EXTERNAL_ACCOUNT_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, O_REAL_PRIORITY O_REAL_PRIORITY, O_LOGICAL_PRIORITY O_LOGICAL_PRIORITY, O_AMOUNT_TYPE O_AMOUNT_TYPE, O_AMOUNT O_AMOUNT, O_EXTERNAL_ACCOUNT_ID O_EXTERNAL_ACCOUNT_ID, O_ATTRIBUTE_CATEGORY O_ATTRIBUTE_CATEGORY, O_ATTRIBUTE1 O_ATTRIBUTE1, O_ATTRIBUTE2 O_ATTRIBUTE2, O_ATTRIBUTE3 O_ATTRIBUTE3, O_ATTRIBUTE4 O_ATTRIBUTE4, O_ATTRIBUTE5 O_ATTRIBUTE5, O_ATTRIBUTE6 O_ATTRIBUTE6, O_ATTRIBUTE7 O_ATTRIBUTE7, O_ATTRIBUTE8 O_ATTRIBUTE8, O_ATTRIBUTE9 O_ATTRIBUTE9, O_ATTRIBUTE10 O_ATTRIBUTE10, O_ATTRIBUTE11 O_ATTRIBUTE11, O_ATTRIBUTE12 O_ATTRIBUTE12, O_ATTRIBUTE13 O_ATTRIBUTE13, O_ATTRIBUTE14 O_ATTRIBUTE14, O_ATTRIBUTE15 O_ATTRIBUTE15, O_ATTRIBUTE16 O_ATTRIBUTE16, O_ATTRIBUTE17 O_ATTRIBUTE17, O_ATTRIBUTE18 O_ATTRIBUTE18, O_ATTRIBUTE19 O_ATTRIBUTE19, O_ATTRIBUTE20 O_ATTRIBUTE20, RUN_TYPE_ID RUN_TYPE_ID, PPM_INFORMATION_CATEGORY PPM_INFORMATION_CATEGORY, PPM_INFORMATION1 PPM_INFORMATION1, PPM_INFORMATION2 PPM_INFORMATION2, PPM_INFORMATION3 PPM_INFORMATION3, PPM_INFORMATION4 PPM_INFORMATION4, PPM_INFORMATION5 PPM_INFORMATION5, PPM_INFORMATION6 PPM_INFORMATION6, PPM_INFORMATION7 PPM_INFORMATION7, PPM_INFORMATION8 PPM_INFORMATION8, PPM_INFORMATION9 PPM_INFORMATION9, PPM_INFORMATION10 PPM_INFORMATION10, PPM_INFORMATION11 PPM_INFORMATION11, PPM_INFORMATION12 PPM_INFORMATION12, PPM_INFORMATION13 PPM_INFORMATION13, PPM_INFORMATION14 PPM_INFORMATION14, PPM_INFORMATION15 PPM_INFORMATION15, PPM_INFORMATION16 PPM_INFORMATION16, PPM_INFORMATION17 PPM_INFORMATION17, PPM_INFORMATION18 PPM_INFORMATION18, PPM_INFORMATION19 PPM_INFORMATION19, PPM_INFORMATION20 PPM_INFORMATION20, PPM_INFORMATION21 PPM_INFORMATION21, PPM_INFORMATION22 PPM_INFORMATION22, PPM_INFORMATION23 PPM_INFORMATION23, PPM_INFORMATION24 PPM_INFORMATION24, PPM_INFORMATION25 PPM_INFORMATION25, PPM_INFORMATION26 PPM_INFORMATION26, PPM_INFORMATION27 PPM_INFORMATION27, PPM_INFORMATION28 PPM_INFORMATION28, PPM_INFORMATION29 PPM_INFORMATION29, PPM_INFORMATION30 PPM_INFORMATION30, O_PPM_INFORMATION_CATEGORY O_PPM_INFORMATION_CATEGORY, O_PPM_INFORMATION1 O_PPM_INFORMATION1, O_PPM_INFORMATION2 O_PPM_INFORMATION2, O_PPM_INFORMATION3 O_PPM_INFORMATION3, O_PPM_INFORMATION4 O_PPM_INFORMATION4, O_PPM_INFORMATION5 O_PPM_INFORMATION5, O_PPM_INFORMATION6 O_PPM_INFORMATION6, O_PPM_INFORMATION7 O_PPM_INFORMATION7, O_PPM_INFORMATION8 O_PPM_INFORMATION8, O_PPM_INFORMATION9 O_PPM_INFORMATION9, O_PPM_INFORMATION10 O_PPM_INFORMATION10, O_PPM_INFORMATION11 O_PPM_INFORMATION11, O_PPM_INFORMATION12 O_PPM_INFORMATION12, O_PPM_INFORMATION13 O_PPM_INFORMATION13, O_PPM_INFORMATION14 O_PPM_INFORMATION14, O_PPM_INFORMATION15 O_PPM_INFORMATION15, O_PPM_INFORMATION16 O_PPM_INFORMATION16, O_PPM_INFORMATION17 O_PPM_INFORMATION17, O_PPM_INFORMATION18 O_PPM_INFORMATION18, O_PPM_INFORMATION19 O_PPM_INFORMATION19, O_PPM_INFORMATION20 O_PPM_INFORMATION20, O_PPM_INFORMATION21 O_PPM_INFORMATION21, O_PPM_INFORMATION22 O_PPM_INFORMATION22, O_PPM_INFORMATION23 O_PPM_INFORMATION23, O_PPM_INFORMATION24 O_PPM_INFORMATION24, O_PPM_INFORMATION25 O_PPM_INFORMATION25, O_PPM_INFORMATION26 O_PPM_INFORMATION26, O_PPM_INFORMATION27 O_PPM_INFORMATION27, O_PPM_INFORMATION28 O_PPM_INFORMATION28, O_PPM_INFORMATION29 O_PPM_INFORMATION29, O_PPM_INFORMATION30 O_PPM_INFORMATION30 from "HR"."PAY_PSS_TRANSACTION_STEPS"

View Text - HTML Formatted

SELECT TRANSACTION_STEP_ID TRANSACTION_STEP_ID
, TRANSACTION_ID TRANSACTION_ID
, SOURCE_TABLE SOURCE_TABLE
, STATE STATE
, PERSONAL_PAYMENT_METHOD_ID PERSONAL_PAYMENT_METHOD_ID
, UPDATE_OVN UPDATE_OVN
, DELETE_OVN DELETE_OVN
, UPDATE_DATETRACK_MODE UPDATE_DATETRACK_MODE
, DELETE_DATETRACK_MODE DELETE_DATETRACK_MODE
, DELETE_DISABLED DELETE_DISABLED
, EFFECTIVE_DATE EFFECTIVE_DATE
, ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, PAYMENT_TYPE PAYMENT_TYPE
, CURRENCY_CODE CURRENCY_CODE
, TERRITORY_CODE TERRITORY_CODE
, REAL_PRIORITY REAL_PRIORITY
, LOGICAL_PRIORITY LOGICAL_PRIORITY
, AMOUNT_TYPE AMOUNT_TYPE
, AMOUNT AMOUNT
, EXTERNAL_ACCOUNT_ID EXTERNAL_ACCOUNT_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
, O_REAL_PRIORITY O_REAL_PRIORITY
, O_LOGICAL_PRIORITY O_LOGICAL_PRIORITY
, O_AMOUNT_TYPE O_AMOUNT_TYPE
, O_AMOUNT O_AMOUNT
, O_EXTERNAL_ACCOUNT_ID O_EXTERNAL_ACCOUNT_ID
, O_ATTRIBUTE_CATEGORY O_ATTRIBUTE_CATEGORY
, O_ATTRIBUTE1 O_ATTRIBUTE1
, O_ATTRIBUTE2 O_ATTRIBUTE2
, O_ATTRIBUTE3 O_ATTRIBUTE3
, O_ATTRIBUTE4 O_ATTRIBUTE4
, O_ATTRIBUTE5 O_ATTRIBUTE5
, O_ATTRIBUTE6 O_ATTRIBUTE6
, O_ATTRIBUTE7 O_ATTRIBUTE7
, O_ATTRIBUTE8 O_ATTRIBUTE8
, O_ATTRIBUTE9 O_ATTRIBUTE9
, O_ATTRIBUTE10 O_ATTRIBUTE10
, O_ATTRIBUTE11 O_ATTRIBUTE11
, O_ATTRIBUTE12 O_ATTRIBUTE12
, O_ATTRIBUTE13 O_ATTRIBUTE13
, O_ATTRIBUTE14 O_ATTRIBUTE14
, O_ATTRIBUTE15 O_ATTRIBUTE15
, O_ATTRIBUTE16 O_ATTRIBUTE16
, O_ATTRIBUTE17 O_ATTRIBUTE17
, O_ATTRIBUTE18 O_ATTRIBUTE18
, O_ATTRIBUTE19 O_ATTRIBUTE19
, O_ATTRIBUTE20 O_ATTRIBUTE20
, RUN_TYPE_ID RUN_TYPE_ID
, PPM_INFORMATION_CATEGORY PPM_INFORMATION_CATEGORY
, PPM_INFORMATION1 PPM_INFORMATION1
, PPM_INFORMATION2 PPM_INFORMATION2
, PPM_INFORMATION3 PPM_INFORMATION3
, PPM_INFORMATION4 PPM_INFORMATION4
, PPM_INFORMATION5 PPM_INFORMATION5
, PPM_INFORMATION6 PPM_INFORMATION6
, PPM_INFORMATION7 PPM_INFORMATION7
, PPM_INFORMATION8 PPM_INFORMATION8
, PPM_INFORMATION9 PPM_INFORMATION9
, PPM_INFORMATION10 PPM_INFORMATION10
, PPM_INFORMATION11 PPM_INFORMATION11
, PPM_INFORMATION12 PPM_INFORMATION12
, PPM_INFORMATION13 PPM_INFORMATION13
, PPM_INFORMATION14 PPM_INFORMATION14
, PPM_INFORMATION15 PPM_INFORMATION15
, PPM_INFORMATION16 PPM_INFORMATION16
, PPM_INFORMATION17 PPM_INFORMATION17
, PPM_INFORMATION18 PPM_INFORMATION18
, PPM_INFORMATION19 PPM_INFORMATION19
, PPM_INFORMATION20 PPM_INFORMATION20
, PPM_INFORMATION21 PPM_INFORMATION21
, PPM_INFORMATION22 PPM_INFORMATION22
, PPM_INFORMATION23 PPM_INFORMATION23
, PPM_INFORMATION24 PPM_INFORMATION24
, PPM_INFORMATION25 PPM_INFORMATION25
, PPM_INFORMATION26 PPM_INFORMATION26
, PPM_INFORMATION27 PPM_INFORMATION27
, PPM_INFORMATION28 PPM_INFORMATION28
, PPM_INFORMATION29 PPM_INFORMATION29
, PPM_INFORMATION30 PPM_INFORMATION30
, O_PPM_INFORMATION_CATEGORY O_PPM_INFORMATION_CATEGORY
, O_PPM_INFORMATION1 O_PPM_INFORMATION1
, O_PPM_INFORMATION2 O_PPM_INFORMATION2
, O_PPM_INFORMATION3 O_PPM_INFORMATION3
, O_PPM_INFORMATION4 O_PPM_INFORMATION4
, O_PPM_INFORMATION5 O_PPM_INFORMATION5
, O_PPM_INFORMATION6 O_PPM_INFORMATION6
, O_PPM_INFORMATION7 O_PPM_INFORMATION7
, O_PPM_INFORMATION8 O_PPM_INFORMATION8
, O_PPM_INFORMATION9 O_PPM_INFORMATION9
, O_PPM_INFORMATION10 O_PPM_INFORMATION10
, O_PPM_INFORMATION11 O_PPM_INFORMATION11
, O_PPM_INFORMATION12 O_PPM_INFORMATION12
, O_PPM_INFORMATION13 O_PPM_INFORMATION13
, O_PPM_INFORMATION14 O_PPM_INFORMATION14
, O_PPM_INFORMATION15 O_PPM_INFORMATION15
, O_PPM_INFORMATION16 O_PPM_INFORMATION16
, O_PPM_INFORMATION17 O_PPM_INFORMATION17
, O_PPM_INFORMATION18 O_PPM_INFORMATION18
, O_PPM_INFORMATION19 O_PPM_INFORMATION19
, O_PPM_INFORMATION20 O_PPM_INFORMATION20
, O_PPM_INFORMATION21 O_PPM_INFORMATION21
, O_PPM_INFORMATION22 O_PPM_INFORMATION22
, O_PPM_INFORMATION23 O_PPM_INFORMATION23
, O_PPM_INFORMATION24 O_PPM_INFORMATION24
, O_PPM_INFORMATION25 O_PPM_INFORMATION25
, O_PPM_INFORMATION26 O_PPM_INFORMATION26
, O_PPM_INFORMATION27 O_PPM_INFORMATION27
, O_PPM_INFORMATION28 O_PPM_INFORMATION28
, O_PPM_INFORMATION29 O_PPM_INFORMATION29
, O_PPM_INFORMATION30 O_PPM_INFORMATION30
FROM "HR"."PAY_PSS_TRANSACTION_STEPS"