VIEW: HR.PAY_ORG_PAYMENT_METHODS_F#

Source

View Text - Preformatted

select ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, EXTERNAL_ACCOUNT_ID EXTERNAL_ACCOUNT_ID, CURRENCY_CODE CURRENCY_CODE, PAYMENT_TYPE_ID PAYMENT_TYPE_ID, DEFINED_BALANCE_ID DEFINED_BALANCE_ID, ORG_PAYMENT_METHOD_NAME ORG_PAYMENT_METHOD_NAME, COMMENT_ID COMMENT_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, 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, PMETH_INFORMATION_CATEGORY PMETH_INFORMATION_CATEGORY, PMETH_INFORMATION1 PMETH_INFORMATION1, PMETH_INFORMATION2 PMETH_INFORMATION2, PMETH_INFORMATION3 PMETH_INFORMATION3, PMETH_INFORMATION4 PMETH_INFORMATION4, PMETH_INFORMATION5 PMETH_INFORMATION5, PMETH_INFORMATION6 PMETH_INFORMATION6, PMETH_INFORMATION7 PMETH_INFORMATION7, PMETH_INFORMATION8 PMETH_INFORMATION8, PMETH_INFORMATION9 PMETH_INFORMATION9, PMETH_INFORMATION10 PMETH_INFORMATION10, PMETH_INFORMATION11 PMETH_INFORMATION11, PMETH_INFORMATION12 PMETH_INFORMATION12, PMETH_INFORMATION13 PMETH_INFORMATION13, PMETH_INFORMATION14 PMETH_INFORMATION14, PMETH_INFORMATION15 PMETH_INFORMATION15, PMETH_INFORMATION16 PMETH_INFORMATION16, PMETH_INFORMATION17 PMETH_INFORMATION17, PMETH_INFORMATION18 PMETH_INFORMATION18, PMETH_INFORMATION19 PMETH_INFORMATION19, PMETH_INFORMATION20 PMETH_INFORMATION20, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TRANSFER_TO_GL_FLAG TRANSFER_TO_GL_FLAG, COST_PAYMENT COST_PAYMENT, COST_CLEARED_PAYMENT COST_CLEARED_PAYMENT, COST_CLEARED_VOID_PAYMENT COST_CLEARED_VOID_PAYMENT, EXCLUDE_MANUAL_PAYMENT EXCLUDE_MANUAL_PAYMENT, TYPE TYPE, ORGANIZATION_ID ORGANIZATION_ID, TIME_DEFINITION_ID TIME_DEFINITION_ID, PARENT_ORG_PAYMENT_METHOD_ID PARENT_ORG_PAYMENT_METHOD_ID, ZD_EDITION_NAME ZD_EDITION_NAME from "HR"."PAY_ORG_PAYMENT_METHODS_F"

View Text - HTML Formatted

SELECT ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, EXTERNAL_ACCOUNT_ID EXTERNAL_ACCOUNT_ID
, CURRENCY_CODE CURRENCY_CODE
, PAYMENT_TYPE_ID PAYMENT_TYPE_ID
, DEFINED_BALANCE_ID DEFINED_BALANCE_ID
, ORG_PAYMENT_METHOD_NAME ORG_PAYMENT_METHOD_NAME
, COMMENT_ID COMMENT_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
, 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
, PMETH_INFORMATION_CATEGORY PMETH_INFORMATION_CATEGORY
, PMETH_INFORMATION1 PMETH_INFORMATION1
, PMETH_INFORMATION2 PMETH_INFORMATION2
, PMETH_INFORMATION3 PMETH_INFORMATION3
, PMETH_INFORMATION4 PMETH_INFORMATION4
, PMETH_INFORMATION5 PMETH_INFORMATION5
, PMETH_INFORMATION6 PMETH_INFORMATION6
, PMETH_INFORMATION7 PMETH_INFORMATION7
, PMETH_INFORMATION8 PMETH_INFORMATION8
, PMETH_INFORMATION9 PMETH_INFORMATION9
, PMETH_INFORMATION10 PMETH_INFORMATION10
, PMETH_INFORMATION11 PMETH_INFORMATION11
, PMETH_INFORMATION12 PMETH_INFORMATION12
, PMETH_INFORMATION13 PMETH_INFORMATION13
, PMETH_INFORMATION14 PMETH_INFORMATION14
, PMETH_INFORMATION15 PMETH_INFORMATION15
, PMETH_INFORMATION16 PMETH_INFORMATION16
, PMETH_INFORMATION17 PMETH_INFORMATION17
, PMETH_INFORMATION18 PMETH_INFORMATION18
, PMETH_INFORMATION19 PMETH_INFORMATION19
, PMETH_INFORMATION20 PMETH_INFORMATION20
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TRANSFER_TO_GL_FLAG TRANSFER_TO_GL_FLAG
, COST_PAYMENT COST_PAYMENT
, COST_CLEARED_PAYMENT COST_CLEARED_PAYMENT
, COST_CLEARED_VOID_PAYMENT COST_CLEARED_VOID_PAYMENT
, EXCLUDE_MANUAL_PAYMENT EXCLUDE_MANUAL_PAYMENT
, TYPE TYPE
, ORGANIZATION_ID ORGANIZATION_ID
, TIME_DEFINITION_ID TIME_DEFINITION_ID
, PARENT_ORG_PAYMENT_METHOD_ID PARENT_ORG_PAYMENT_METHOD_ID
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "HR"."PAY_ORG_PAYMENT_METHODS_F"