IBY_PAYMENT_METHODS_VL

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name

ROW_ID PAYMENT_FORMAT_APL_FLAG LAST_UPDATE_DATE LAST_UPDATE_LOGIN PAYMENT_METHOD_CODE CREATED_BY CREATION_DATE LAST_UPDATED_BY OBJECT_VERSION_NUMBER BANK_CHARGE_BEARER_APL_FLAG PAYMENT_REASON_APL_FLAG PAYMENT_REASON_COMNT_APL_FLAG REMITTANCE_MESSAGE1_APL_FLAG REMITTANCE_MESSAGE2_APL_FLAG REMITTANCE_MESSAGE3_APL_FLAG UNIQUE_REMITTANCE_ID_APL_FLAG URI_CHECK_DIGIT_APL_FLAG DELIVERY_CHANNEL_APL_FLAG INACTIVE_DATE ANTICIPATED_FLOAT SETTLEMENT_PRIORITY_APL_FLAG EXCLUSIVE_PMT_APL_FLAG EXTERNAL_BANK_ACCT_APL_FLAG DOCUMENT_CATEGORY_CODE SUPPORT_BILLS_PAYABLE_FLAG MATURITY_DATE_OFFSET_DAYS ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER5 GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE5 PAYMENT_METHOD_NAME DESCRIPTION SEEDED_FLAG FORMAT_VALUE START_DATE END_DATE PAYMENT_MODE_CODE

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.PAYMENT_FORMAT_APL_FLAG, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.PAYMENT_METHOD_CODE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.OBJECT_VERSION_NUMBER, B.BANK_CHARGE_BEARER_APL_FLAG, B.PAYMENT_REASON_APL_FLAG, B.PAYMENT_REASON_COMNT_APL_FLAG, B.REMITTANCE_MESSAGE1_APL_FLAG, B.REMITTANCE_MESSAGE2_APL_FLAG, B.REMITTANCE_MESSAGE3_APL_FLAG, B.UNIQUE_REMITTANCE_ID_APL_FLAG, B.URI_CHECK_DIGIT_APL_FLAG, B.DELIVERY_CHANNEL_APL_FLAG, B.INACTIVE_DATE, B.ANTICIPATED_FLOAT, B.SETTLEMENT_PRIORITY_APL_FLAG, B.EXCLUSIVE_PMT_APL_FLAG, B.EXTERNAL_BANK_ACCT_APL_FLAG, B.DOCUMENT_CATEGORY_CODE , B.SUPPORT_BILLS_PAYABLE_FLAG , B.MATURITY_DATE_OFFSET_DAYS , B.ATTRIBUTE_CATEGORY , B.ATTRIBUTE1 , B.ATTRIBUTE2 , B.ATTRIBUTE3 , B.ATTRIBUTE4 , B.ATTRIBUTE5 , B.ATTRIBUTE6 , B.ATTRIBUTE7 , B.ATTRIBUTE8 , B.ATTRIBUTE9 , B.ATTRIBUTE10 , B.ATTRIBUTE11 , B.ATTRIBUTE12 , B.ATTRIBUTE13 , B.ATTRIBUTE14 , B.ATTRIBUTE15 , B.GLOBAL_ATTRIBUTE_CATEGORY, B.GLOBAL_ATTRIBUTE1 , B.GLOBAL_ATTRIBUTE2 , B.GLOBAL_ATTRIBUTE3 , B.GLOBAL_ATTRIBUTE4 , B.GLOBAL_ATTRIBUTE5 , B.GLOBAL_ATTRIBUTE6 , B.GLOBAL_ATTRIBUTE7 , B.GLOBAL_ATTRIBUTE8 , B.GLOBAL_ATTRIBUTE9 , B.GLOBAL_ATTRIBUTE10 , B.GLOBAL_ATTRIBUTE11 , B.GLOBAL_ATTRIBUTE12 , B.GLOBAL_ATTRIBUTE13 , B.GLOBAL_ATTRIBUTE14 , B.GLOBAL_ATTRIBUTE15 , B.GLOBAL_ATTRIBUTE16 , B.GLOBAL_ATTRIBUTE17 , B.GLOBAL_ATTRIBUTE18 , B.GLOBAL_ATTRIBUTE19 , B.GLOBAL_ATTRIBUTE20 ,B.GLOBAL_ATTRIBUTE_NUMBER1 , B.GLOBAL_ATTRIBUTE_NUMBER2 , B.GLOBAL_ATTRIBUTE_NUMBER3 , B.GLOBAL_ATTRIBUTE_NUMBER4 , B.GLOBAL_ATTRIBUTE_NUMBER5 ,B.GLOBAL_ATTRIBUTE_DATE1 , B.GLOBAL_ATTRIBUTE_DATE2 , B.GLOBAL_ATTRIBUTE_DATE3 , B.GLOBAL_ATTRIBUTE_DATE4 , B.GLOBAL_ATTRIBUTE_DATE5, T.PAYMENT_METHOD_NAME, T.DESCRIPTION , B.SEEDED_FLAG , B.FORMAT_VALUE, B.START_DATE, B.END_DATE, B.PAYMENT_MODE_CODE FROM IBY_PAYMENT_METHODS_TL T,IBY_PAYMENT_METHODS_B B WHERE B.PAYMENT_METHOD_CODE = T.PAYMENT_METHOD_CODE and T.LANGUAGE = userenv('LANG')