FND Design Data [Home] [Help]

View: IBY_EXTERNAL_PAYEES_V

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

SELECT PAYEE.EXT_PAYEE_ID
, PAYEE.PAYEE_PARTY_ID
, PAYEE.PAYMENT_FUNCTION
, PAYEE.PARTY_SITE_ID
, PAYEE.SUPPLIER_SITE_ID
, PAYEE.ORG_ID
, PAYEE.ORG_TYPE
, PAYEE.EXCLUSIVE_PAYMENT_FLAG
, PAYEE.DEFAULT_PAYMENT_METHOD_CODE
, PAYEE.ECE_TP_LOCATION_CODE
, PAYEE.BANK_CHARGE_BEARER
, PAYEE.BANK_INSTRUCTION1_CODE
, PAYEE.BANK_INSTRUCTION2_CODE
, PAYEE.BANK_INSTRUCTION_DETAILS
, PAYEE.PAYMENT_REASON_CODE
, PAYEE.PAYMENT_REASON_COMMENTS
, PAYEE.INACTIVE_DATE
, PAYEE.PAYMENT_TEXT_MESSAGE1
, PAYEE.PAYMENT_TEXT_MESSAGE2
, PAYEE.PAYMENT_TEXT_MESSAGE3
, PAYEE.DELIVERY_CHANNEL_CODE
, PAYEE.PAYMENT_FORMAT_CODE
, PAYEE.SETTLEMENT_PRIORITY
FROM IBY_EXTERNAL_PAYEES_ALL PAYEE

Columns

Name
EXT_PAYEE_ID
PAYEE_PARTY_ID
PAYMENT_FUNCTION
PARTY_SITE_ID
SUPPLIER_SITE_ID
ORG_ID
ORG_TYPE
EXCLUSIVE_PAYMENT_FLAG
DEFAULT_PAYMENT_METHOD_CODE
ECE_TP_LOCATION_CODE
BANK_CHARGE_BEARER
BANK_INSTRUCTION1_CODE
BANK_INSTRUCTION2_CODE
BANK_INSTRUCTION_DETAILS
PAYMENT_REASON_CODE
PAYMENT_REASON_COMMENTS
INACTIVE_DATE
PAYMENT_TEXT_MESSAGE1
PAYMENT_TEXT_MESSAGE2
PAYMENT_TEXT_MESSAGE3
DELIVERY_CHANNEL_CODE
PAYMENT_FORMAT_CODE
SETTLEMENT_PRIORITY