VIEW: APPS.IBY_FD_DOCS_PAYABLE_V

Source

View Text - Preformatted

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,IBY_DOCS.ADDRESS_SOURCE,IBY_DOCS.EMPLOYEE_ADDRESS_CODE,IBY_DOCS.EMPLOYEE_PERSON_ID,IBY_DOCS.EMPLOYEE_PAYMENT_FLAG,IBY_DOCS.EMPLOYEE_ADDRESS_ID FROM IBY_DOCS_PAYABLE_ALL IBY_DOCS

View Text - HTML Formatted

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
, IBY_DOCS.ADDRESS_SOURCE
, IBY_DOCS.EMPLOYEE_ADDRESS_CODE
, IBY_DOCS.EMPLOYEE_PERSON_ID
, IBY_DOCS.EMPLOYEE_PAYMENT_FLAG
, IBY_DOCS.EMPLOYEE_ADDRESS_ID
FROM IBY_DOCS_PAYABLE_ALL IBY_DOCS