[Home] [Help]
| 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