PAY_ORG_PAY_METHODS_VL

Details

• Schema: FUSION

• Object owner: PAY

• Object type: VIEW

Columns

Name

ORG_PAYMENT_METHOD_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE ORG_PAYMENT_METHOD_NAME LEGISLATIVE_DATA_GROUP_ID ENTERPRISE_ID BANK_ACCOUNT_ID PAYMENT_TYPE_ID DEFINED_BALANCE_ID THIRD_PARTY_FLAG BASE_ORG_PAY_METHOD_NAME ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE16 ATTRIBUTE17 ATTRIBUTE18 ATTRIBUTE19 ATTRIBUTE20 LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE PMETH_INFORMATION_CATEGORY PMETH_INFORMATION1 PMETH_INFORMATION2 PMETH_INFORMATION3 PMETH_INFORMATION4 PMETH_INFORMATION5 PMETH_INFORMATION6 PMETH_INFORMATION7 PMETH_INFORMATION8 PMETH_INFORMATION9 PMETH_INFORMATION10 PMETH_INFORMATION11 PMETH_INFORMATION12 PMETH_INFORMATION13 PMETH_INFORMATION14 PMETH_INFORMATION15 PMETH_INFORMATION16 PMETH_INFORMATION17 PMETH_INFORMATION18 PMETH_INFORMATION19 PMETH_INFORMATION20 TYPE ORGANIZATION_ID TIME_DEFINITION_ID PARENT_ORG_PAY_METHOD_ID OBJECT_VERSION_NUMBER CURRENCY_CODE ATTRIBUTE21 ATTRIBUTE22 ATTRIBUTE23 ATTRIBUTE24 ATTRIBUTE25 ATTRIBUTE26 ATTRIBUTE27 ATTRIBUTE28 ATTRIBUTE29 ATTRIBUTE30 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER11 ATTRIBUTE_NUMBER12 ATTRIBUTE_NUMBER13 ATTRIBUTE_NUMBER14 ATTRIBUTE_NUMBER15 ATTRIBUTE_NUMBER16 ATTRIBUTE_NUMBER17 ATTRIBUTE_NUMBER18 ATTRIBUTE_NUMBER19 ATTRIBUTE_NUMBER20 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_DATE6 ATTRIBUTE_DATE7 ATTRIBUTE_DATE8 ATTRIBUTE_DATE9 ATTRIBUTE_DATE10 ATTRIBUTE_DATE11 ATTRIBUTE_DATE12 ATTRIBUTE_DATE13 ATTRIBUTE_DATE14 ATTRIBUTE_DATE15 PMETH_INFORMATION21 PMETH_INFORMATION22 PMETH_INFORMATION23 PMETH_INFORMATION24 PMETH_INFORMATION25 PMETH_INFORMATION26 PMETH_INFORMATION27 PMETH_INFORMATION28 PMETH_INFORMATION29 PMETH_INFORMATION30 PMETH_INFORMATION_NUMBER1 PMETH_INFORMATION_NUMBER2 PMETH_INFORMATION_NUMBER3 PMETH_INFORMATION_NUMBER4 PMETH_INFORMATION_NUMBER5 PMETH_INFORMATION_NUMBER6 PMETH_INFORMATION_NUMBER7 PMETH_INFORMATION_NUMBER8 PMETH_INFORMATION_NUMBER9 PMETH_INFORMATION_NUMBER10 PMETH_INFORMATION_NUMBER11 PMETH_INFORMATION_NUMBER12 PMETH_INFORMATION_NUMBER13 PMETH_INFORMATION_NUMBER14 PMETH_INFORMATION_NUMBER15 PMETH_INFORMATION_NUMBER16 PMETH_INFORMATION_NUMBER17 PMETH_INFORMATION_NUMBER18 PMETH_INFORMATION_NUMBER19 PMETH_INFORMATION_NUMBER20 PMETH_INFORMATION_DATE1 PMETH_INFORMATION_DATE2 PMETH_INFORMATION_DATE3 PMETH_INFORMATION_DATE4 PMETH_INFORMATION_DATE5 PMETH_INFORMATION_DATE6 PMETH_INFORMATION_DATE7 PMETH_INFORMATION_DATE8 PMETH_INFORMATION_DATE9 PMETH_INFORMATION_DATE10 PMETH_INFORMATION_DATE11 PMETH_INFORMATION_DATE12 PMETH_INFORMATION_DATE13 PMETH_INFORMATION_DATE14 PMETH_INFORMATION_DATE15 EXT_DELIVERY_OPTION_ID THIRD_PARTY_DEL_OPTION_ID EFT_TEXT EFT_TEXT2 EFT_TRANSACTION_LIMIT EFT_FILE_LIMIT EFT_REFERENCE EFT_USER_REFERENCE EFT_USER_REFERENCE_TYPE EFT_USER_NAME EFT_BUREAU_REFERENCE EFT_BUREAU_REFERENCE_TYPE EFT_BUREAU_NAME EFT_BALANCING_FLAG PRE_VALIDATION_REQUIRED VALIDATION_DAYS VALIDATION_VALUE

Query

SQL_Statement

SELECT popm.ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID, popm.EFFECTIVE_START_DATE EFFECTIVE_START_DATE, popm.EFFECTIVE_END_DATE EFFECTIVE_END_DATE, popmtl.ORG_PAYMENT_METHOD_NAME ORG_PAYMENT_METHOD_NAME, popm.LEGISLATIVE_DATA_GROUP_ID LEGISLATIVE_DATA_GROUP_ID, popm.ENTERPRISE_ID ENTERPRISE_ID, popm.BANK_ACCOUNT_ID BANK_ACCOUNT_ID, popm.PAYMENT_TYPE_ID PAYMENT_TYPE_ID, popm.DEFINED_BALANCE_ID DEFINED_BALANCE_ID, popm.THIRD_PARTY_FLAG THIRD_PARTY_FLAG, popm.BASE_ORG_PAY_METHOD_NAME BASE_ORG_PAY_METHOD_NAME, popm.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, popm.ATTRIBUTE1 ATTRIBUTE1, popm.ATTRIBUTE2 ATTRIBUTE2, popm.ATTRIBUTE3 ATTRIBUTE3, popm.ATTRIBUTE4 ATTRIBUTE4, popm.ATTRIBUTE5 ATTRIBUTE5, popm.ATTRIBUTE6 ATTRIBUTE6, popm.ATTRIBUTE7 ATTRIBUTE7, popm.ATTRIBUTE8 ATTRIBUTE8, popm.ATTRIBUTE9 ATTRIBUTE9, popm.ATTRIBUTE10 ATTRIBUTE10, popm.ATTRIBUTE11 ATTRIBUTE11, popm.ATTRIBUTE12 ATTRIBUTE12, popm.ATTRIBUTE13 ATTRIBUTE13, popm.ATTRIBUTE14 ATTRIBUTE14, popm.ATTRIBUTE15 ATTRIBUTE15, popm.ATTRIBUTE16 ATTRIBUTE16, popm.ATTRIBUTE17 ATTRIBUTE17, popm.ATTRIBUTE18 ATTRIBUTE18, popm.ATTRIBUTE19 ATTRIBUTE19, popm.ATTRIBUTE20 ATTRIBUTE20, popm.LAST_UPDATE_DATE LAST_UPDATE_DATE, popm.LAST_UPDATED_BY LAST_UPDATED_BY, popm.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, popm.CREATED_BY CREATED_BY, popm.CREATION_DATE CREATION_DATE, popm.PMETH_INFORMATION_CATEGORY PMETH_INFORMATION_CATEGORY, popm.PMETH_INFORMATION1 PMETH_INFORMATION1, popm.PMETH_INFORMATION2 PMETH_INFORMATION2, popm.PMETH_INFORMATION3 PMETH_INFORMATION3, popm.PMETH_INFORMATION4 PMETH_INFORMATION4, popm.PMETH_INFORMATION5 PMETH_INFORMATION5, popm.PMETH_INFORMATION6 PMETH_INFORMATION6, popm.PMETH_INFORMATION7 PMETH_INFORMATION7, popm.PMETH_INFORMATION8 PMETH_INFORMATION8, popm.PMETH_INFORMATION9 PMETH_INFORMATION9, popm.PMETH_INFORMATION10 PMETH_INFORMATION10, popm.PMETH_INFORMATION11 PMETH_INFORMATION11, popm.PMETH_INFORMATION12 PMETH_INFORMATION12, popm.PMETH_INFORMATION13 PMETH_INFORMATION13, popm.PMETH_INFORMATION14 PMETH_INFORMATION14, popm.PMETH_INFORMATION15 PMETH_INFORMATION15, popm.PMETH_INFORMATION16 PMETH_INFORMATION16, popm.PMETH_INFORMATION17 PMETH_INFORMATION17, popm.PMETH_INFORMATION18 PMETH_INFORMATION18, popm.PMETH_INFORMATION19 PMETH_INFORMATION19, popm.PMETH_INFORMATION20 PMETH_INFORMATION20, popm.TYPE TYPE, popm.ORGANIZATION_ID ORGANIZATION_ID, popm.TIME_DEFINITION_ID TIME_DEFINITION_ID, popm.PARENT_ORG_PAY_METHOD_ID PARENT_ORG_PAY_METHOD_ID, popm.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, popm.CURRENCY_CODE CURRENCY_CODE, popm.ATTRIBUTE21, popm.ATTRIBUTE22, popm.ATTRIBUTE23, popm.ATTRIBUTE24, popm.ATTRIBUTE25, popm.ATTRIBUTE26, popm.ATTRIBUTE27, popm.ATTRIBUTE28, popm.ATTRIBUTE29, popm.ATTRIBUTE30, popm.ATTRIBUTE_NUMBER1, popm.ATTRIBUTE_NUMBER2, popm.ATTRIBUTE_NUMBER3, popm.ATTRIBUTE_NUMBER4, popm.ATTRIBUTE_NUMBER5, popm.ATTRIBUTE_NUMBER6, popm.ATTRIBUTE_NUMBER7, popm.ATTRIBUTE_NUMBER8, popm.ATTRIBUTE_NUMBER9, popm.ATTRIBUTE_NUMBER10, popm.ATTRIBUTE_NUMBER11, popm.ATTRIBUTE_NUMBER12, popm.ATTRIBUTE_NUMBER13, popm.ATTRIBUTE_NUMBER14, popm.ATTRIBUTE_NUMBER15, popm.ATTRIBUTE_NUMBER16, popm.ATTRIBUTE_NUMBER17, popm.ATTRIBUTE_NUMBER18, popm.ATTRIBUTE_NUMBER19, popm.ATTRIBUTE_NUMBER20, popm.ATTRIBUTE_DATE1, popm.ATTRIBUTE_DATE2, popm.ATTRIBUTE_DATE3, popm.ATTRIBUTE_DATE4, popm.ATTRIBUTE_DATE5, popm.ATTRIBUTE_DATE6, popm.ATTRIBUTE_DATE7, popm.ATTRIBUTE_DATE8, popm.ATTRIBUTE_DATE9, popm.ATTRIBUTE_DATE10, popm.ATTRIBUTE_DATE11, popm.ATTRIBUTE_DATE12, popm.ATTRIBUTE_DATE13, popm.ATTRIBUTE_DATE14, popm.ATTRIBUTE_DATE15, popm.PMETH_INFORMATION21, popm.PMETH_INFORMATION22, popm.PMETH_INFORMATION23, popm.PMETH_INFORMATION24, popm.PMETH_INFORMATION25, popm.PMETH_INFORMATION26, popm.PMETH_INFORMATION27, popm.PMETH_INFORMATION28, popm.PMETH_INFORMATION29, popm.PMETH_INFORMATION30, popm.PMETH_INFORMATION_NUMBER1, popm.PMETH_INFORMATION_NUMBER2, popm.PMETH_INFORMATION_NUMBER3, popm.PMETH_INFORMATION_NUMBER4, popm.PMETH_INFORMATION_NUMBER5, popm.PMETH_INFORMATION_NUMBER6, popm.PMETH_INFORMATION_NUMBER7, popm.PMETH_INFORMATION_NUMBER8, popm.PMETH_INFORMATION_NUMBER9, popm.PMETH_INFORMATION_NUMBER10, popm.PMETH_INFORMATION_NUMBER11, popm.PMETH_INFORMATION_NUMBER12, popm.PMETH_INFORMATION_NUMBER13, popm.PMETH_INFORMATION_NUMBER14, popm.PMETH_INFORMATION_NUMBER15, popm.PMETH_INFORMATION_NUMBER16, popm.PMETH_INFORMATION_NUMBER17, popm.PMETH_INFORMATION_NUMBER18, popm.PMETH_INFORMATION_NUMBER19, popm.PMETH_INFORMATION_NUMBER20, popm.PMETH_INFORMATION_DATE1, popm.PMETH_INFORMATION_DATE2, popm.PMETH_INFORMATION_DATE3, popm.PMETH_INFORMATION_DATE4, popm.PMETH_INFORMATION_DATE5, popm.PMETH_INFORMATION_DATE6, popm.PMETH_INFORMATION_DATE7, popm.PMETH_INFORMATION_DATE8, popm.PMETH_INFORMATION_DATE9, popm.PMETH_INFORMATION_DATE10, popm.PMETH_INFORMATION_DATE11, popm.PMETH_INFORMATION_DATE12, popm.PMETH_INFORMATION_DATE13, popm.PMETH_INFORMATION_DATE14, popm.PMETH_INFORMATION_DATE15, popm.EXT_DELIVERY_OPTION_ID, popm.THIRD_PARTY_DEL_OPTION_ID, popm.EFT_TEXT, popm.EFT_TEXT2, popm.EFT_TRANSACTION_LIMIT, popm.EFT_FILE_LIMIT, popm.EFT_REFERENCE, popm.EFT_USER_REFERENCE, popm.EFT_USER_REFERENCE_TYPE, popm.EFT_USER_NAME, popm.EFT_BUREAU_REFERENCE, popm.EFT_BUREAU_REFERENCE_TYPE, popm.EFT_BUREAU_NAME, popm.EFT_BALANCING_FLAG, popm.PRE_VALIDATION_REQUIRED, popm.VALIDATION_DAYS, popm.VALIDATION_VALUE FROM PAY_ORG_PAY_METHODS_F popm, PAY_ORG_PAY_METHODS_TL popmtl WHERE popm.ORG_PAYMENT_METHOD_ID = popmtl.ORG_PAYMENT_METHOD_ID AND popmtl.LANGUAGE = USERENV('LANG')