FND Design Data [Home] [Help]

View: IBY_PAYMENT_METHODS_VL

Product: IBY - Payments
Description:
Implementation/DBA Data: ViewAPPS.IBY_PAYMENT_METHODS_VL
View Text

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
, T.PAYMENT_METHOD_NAME
, T.DESCRIPTION
, B.SEEDED_FLAG
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')

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
PAYMENT_METHOD_NAME
DESCRIPTION
SEEDED_FLAG