Product: | IBY - Payments |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IBY_FD_DOCS_PAYABLE_V |
SELECT IBY_DOCS.DOCUMENT_AMOUNT
, IBY_DOCS.PAYMENT_CURRENCY_CODE
, IBY_DOCS.PAYMENT_AMOUNT
, IBY_DOCS.ALLOW_REMOVING_DOCUMENT_FLAG
, IBY_DOCS.REMIT_TO_LOCATION_ID
, IBY_DOCS.STRAIGHT_THROUGH_FLAG
, IBY_DOCS.PAYMENT_SERVICE_REQUEST_ID
, IBY_DOCS.PAYMENT_METHOD_CODE
, IBY_DOCS.EXCLUSIVE_PAYMENT_FLAG
, IBY_DOCS.EXT_PAYEE_ID
, IBY_DOCS.PAYEE_PARTY_ID
, IBY_DOCS.LEGAL_ENTITY_ID
, IBY_DOCS.ORG_ID
, IBY_DOCS.CREATED_BY
, IBY_DOCS.CREATION_DATE
, IBY_DOCS.LAST_UPDATED_BY
, IBY_DOCS.LAST_UPDATE_DATE
, IBY_DOCS.OBJECT_VERSION_NUMBER
, IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF1
, IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF2
, IBY_DOCS.ORG_TYPE
, IBY_DOCS.COMPLETED_PMTS_GROUP_ID
, IBY_DOCS.REJECTED_DOCS_GROUP_ID
, IBY_DOCS.DELIVERY_CHANNEL_CODE
, IBY_DOCS.PAYMENT_FORMAT_CODE
, IBY_DOCS.PAY_PROC_TRXN_TYPE_CODE
, IBY_DOCS.CALLING_APP_ID
, IBY_DOCS.CALLING_APP_DOC_REF_NUMBER
, IBY_DOCS.DOCUMENT_PAYABLE_ID
, IBY_DOCS.PAYMENT_FUNCTION
, IBY_DOCS.PAYMENT_DATE
, IBY_DOCS.DOCUMENT_DATE
, IBY_DOCS.DOCUMENT_TYPE
, IBY_DOCS.DOCUMENT_STATUS
, IBY_DOCS.DOCUMENT_CURRENCY_CODE
, IBY_DOCS.PAYMENT_REASON_CODE
, IBY_DOCS.REMITTANCE_MESSAGE1
, IBY_DOCS.DOCUMENT_SEQUENCE_ID
, IBY_DOCS.DOCUMENT_SEQUENCE_VALUE
, IBY_DOCS.DOCUMENT_CATEGORY_CODE
, IBY_DOCS.BANK_ASSIGNED_REF_CODE
, IBY_DOCS.PO_NUMBER
, IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF4
, IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF5
, IBY_DOCS.LAST_UPDATE_LOGIN
, IBY_DOCS.PARTY_SITE_ID
, IBY_DOCS.SUPPLIER_SITE_ID
, IBY_DOCS.REMITTANCE_MESSAGE2
, IBY_DOCS.REMITTANCE_MESSAGE3
, IBY_DOCS.PAYMENT_REASON_COMMENTS
, IBY_DOCS.ANTICIPATED_VALUE_DATE
, IBY_DOCS.DOCUMENT_DESCRIPTION
, IBY_DOCS.DOCUMENT_CURRENCY_TAX_AMOUNT
, IBY_DOCS.DOCUMENT_CURR_CHARGE_AMOUNT
, IBY_DOCS.AMOUNT_WITHHELD
, IBY_DOCS.PAYMENT_CURR_DISCOUNT_TAKEN
, IBY_DOCS.DISCOUNT_DATE
, IBY_DOCS.PAYMENT_DUE_DATE
, IBY_DOCS.PAYMENT_PROFILE_ID
, IBY_DOCS.PAYMENT_ID
, IBY_DOCS.FORMATTING_PAYMENT_ID
, IBY_DOCS.INTERNAL_BANK_ACCOUNT_ID
, IBY_DOCS.EXTERNAL_BANK_ACCOUNT_ID
, IBY_DOCS.BANK_CHARGE_BEARER
, IBY_DOCS.INTEREST_RATE
, IBY_DOCS.PAYMENT_GROUPING_NUMBER
, IBY_DOCS.UNIQUE_REMITTANCE_IDENTIFIER
, IBY_DOCS.URI_CHECK_DIGIT
, IBY_DOCS.CALLING_APP_DOC_UNIQUE_REF3
, IBY_DOCS.BENEFICIARY_PARTY
, IBY_DOCS.ATTRIBUTE_CATEGORY
, IBY_DOCS.ATTRIBUTE1
, IBY_DOCS.ATTRIBUTE2
, IBY_DOCS.ATTRIBUTE3
, IBY_DOCS.ATTRIBUTE4
, IBY_DOCS.ATTRIBUTE5
, IBY_DOCS.ATTRIBUTE6
, IBY_DOCS.ATTRIBUTE7
, IBY_DOCS.ATTRIBUTE8
, IBY_DOCS.ATTRIBUTE9
, IBY_DOCS.ATTRIBUTE10
, IBY_DOCS.ATTRIBUTE11
, IBY_DOCS.ATTRIBUTE12
, IBY_DOCS.ATTRIBUTE13
, IBY_DOCS.ATTRIBUTE14
, IBY_DOCS.ATTRIBUTE15
, IBY_DOCS.SETTLEMENT_PRIORITY
FROM IBY_DOCS_PAYABLE_ALL IBY_DOCS