Product: | IBY - Payments |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IBY_EXTERNAL_PAYEES_V |
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