APPS.IBY_FD_PAYMENTS_V
[Home] [Help]
| Product: | IBY - Payments |
|---|---|
| Description: | |
| Implementation/DBA Data: |
APPS.IBY_FD_PAYMENTS_V
|
SELECT IBY_PAY.COMPLETED_PMTS_GROUP_ID
, IBY_PAY.PAYMENT_REASON_COMMENTS
, IBY_PAY.PAYMENT_DATE
, IBY_PAY.ANTICIPATED_VALUE_DATE
, IBY_PAY.DECLARATION_AMOUNT
, IBY_PAY.DECLARATION_CURRENCY_CODE
, IBY_PAY.DISCOUNT_AMOUNT_TAKEN
, IBY_PAY.BANK_CHARGE_AMOUNT
, IBY_PAY.SETTLEMENT_PRIORITY
, IBY_PAY.PAYMENT_ID
, IBY_PAY.PAYMENT_METHOD_CODE
, IBY_PAY.PAYMENT_SERVICE_REQUEST_ID
, IBY_PAY.PROCESS_TYPE
, IBY_PAY.PAYMENT_STATUS
, IBY_PAY.PAYMENTS_COMPLETE_FLAG
, IBY_PAY.PAYMENT_FUNCTION
, IBY_PAY.PAYMENT_AMOUNT
, IBY_PAY.PAYMENT_CURRENCY_CODE
, IBY_PAY.STOP_CONFIRMED_BY
, IBY_PAY.STOP_CONFIRM_DATE
, IBY_PAY.STOP_CONFIRM_REASON
, IBY_PAY.STOP_CONFIRM_REFERENCE
, IBY_PAY.STOP_RELEASED_BY
, IBY_PAY.STOP_RELEASE_DATE
, IBY_PAY.STOP_RELEASE_REASON
, IBY_PAY.STOP_RELEASE_REFERENCE
, IBY_PAY.STOP_REQUEST_DATE
, IBY_PAY.STOP_REQUEST_PLACED_BY
, IBY_PAY.STOP_REQUEST_REASON
, IBY_PAY.STOP_REQUEST_REFERENCE
, IBY_PAY.VOIDED_BY
, IBY_PAY.VOID_DATE
, IBY_PAY.VOID_REASON
, IBY_PAY.ATTRIBUTE_CATEGORY
, IBY_PAY.ATTRIBUTE1
, IBY_PAY.ATTRIBUTE2
, IBY_PAY.ATTRIBUTE3
, IBY_PAY.ATTRIBUTE4
, IBY_PAY.ATTRIBUTE5
, IBY_PAY.ATTRIBUTE6
, IBY_PAY.ATTRIBUTE7
, IBY_PAY.ATTRIBUTE8
, IBY_PAY.ATTRIBUTE9
, IBY_PAY.ATTRIBUTE10
, IBY_PAY.ATTRIBUTE11
, IBY_PAY.ATTRIBUTE12
, IBY_PAY.ATTRIBUTE13
, IBY_PAY.ATTRIBUTE14
, IBY_PAY.ATTRIBUTE15
, IBY_PAY.STOP_CONFIRMED_FLAG
, IBY_PAY.STOP_RELEASED_FLAG
, IBY_PAY.STOP_REQUEST_PLACED_FLAG
, IBY_PAY.CREATED_BY
, IBY_PAY.CREATION_DATE
, IBY_PAY.LAST_UPDATED_BY
, IBY_PAY.LAST_UPDATE_LOGIN
, IBY_PAY.LAST_UPDATE_DATE
, IBY_PAY.OBJECT_VERSION_NUMBER
, IBY_PAY.PAYEE_PARTY_ID
, IBY_PAY.PARTY_SITE_ID
, IBY_PAY.SUPPLIER_SITE_ID
, IBY_PAY.PAYMENT_REASON_CODE
, IBY_PAY.REMIT_TO_LOCATION_ID
, IBY_PAY.ORG_ID
, IBY_PAY.ORG_TYPE
, IBY_PAY.LEGAL_ENTITY_ID
, IBY_PAY.DECLARE_PAYMENT_FLAG
, IBY_PAY.DELIVERY_CHANNEL_CODE
, IBY_PAY.EXT_PAYEE_ID
, IBY_PAY.PAYMENT_INSTRUCTION_ID
, IBY_PAY.PAYMENT_PROFILE_ID
, IBY_PAY.PREGROUPED_PAYMENT_FLAG
, IBY_PAY.REMITTANCE_MESSAGE1
, IBY_PAY.REMITTANCE_MESSAGE2
, IBY_PAY.PAYMENT_DETAILS
, IBY_PAY.BANK_CHARGE_BEARER
, IBY_PAY.SEPARATE_REMIT_ADVICE_REQ_FLAG
, IBY_PAY.INTERNAL_BANK_ACCOUNT_ID
, IBY_PAY.BILL_PAYABLE_FLAG
, IBY_PAY.EXCLUSIVE_PAYMENT_FLAG
, IBY_PAY.REMITTANCE_MESSAGE3
, IBY_PAY.PAYMENT_REFERENCE_NUMBER
, IBY_PAY.PAPER_DOCUMENT_NUMBER
, IBY_PAY.BANK_ASSIGNED_REF_CODE
, IBY_PAY.EXTERNAL_BANK_ACCOUNT_ID
, IBY_PAY.UNIQUE_REMITTANCE_IDENTIFIER
, IBY_PAY.URI_CHECK_DIGIT
, IBY_PAY.BANK_INSTRUCTION1_CODE
, IBY_PAY.BANK_INSTRUCTION2_CODE
, IBY_PAY.BANK_INSTRUCTION_DETAILS
, IBY_PAY.PAYMENT_TEXT_MESSAGE1
, IBY_PAY.PAYMENT_TEXT_MESSAGE2
, IBY_PAY.PAYMENT_TEXT_MESSAGE3
, IBY_PAY.MATURITY_DATE
, IBY_PAY.PAYMENT_DUE_DATE
, IBY_PAY.DOCUMENT_CATEGORY_CODE
, IBY_PAY.DOCUMENT_SEQUENCE_ID
, IBY_PAY.EXT_BRANCH_NUMBER
, IBY_PAY.DOCUMENT_SEQUENCE_VALUE
, IBY_PAY.EXT_BANK_NUMBER
, IBY_PAY.BENEFICIARY_PARTY
, IBY_PAY.EXT_BANK_ACCOUNT_NAME
, IBY_PAY.EXT_BANK_ACCOUNT_NUMBER
, IBY_PAY.EXT_BANK_ACCOUNT_TYPE
, IBY_PAY.EXT_BANK_ACCOUNT_IBAN_NUMBER
, IBY_PAY.PAYEE_NAME
, IBY_PAY.PAYEE_ADDRESS1
, IBY_PAY.PAYEE_ADDRESS2
, IBY_PAY.PAYEE_ADDRESS3
, IBY_PAY.PAYEE_ADDRESS4
, IBY_PAY.PAYEE_CITY
, IBY_PAY.PAYEE_POSTAL_CODE
, IBY_PAY.PAYEE_STATE
, IBY_PAY.PAYEE_PROVINCE
, IBY_PAY.PAYEE_COUNTY
, IBY_PAY.PAYEE_COUNTRY
FROM IBY_PAYMENTS_ALL IBY_PAY