View: IBY_EXT_FD_DOC_1_0_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_EXT_FD_DOC_1_0_V

View Text

SELECT DOC.PAYMENT_ID
, DOC.DOCUMENT_PAYABLE_ID
, DOC.PAYMENT_SERVICE_REQUEST_ID
, DOC.CALLING_APP_DOC_UNIQUE_REF1
, DOC.CALLING_APP_DOC_UNIQUE_REF2
, DOC.CALLING_APP_DOC_UNIQUE_REF3
, DOC.CALLING_APP_DOC_UNIQUE_REF4
, DOC.CALLING_APP_DOC_UNIQUE_REF5
, DOC.CALLING_APP_ID
, DOC.PAY_PROC_TRXN_TYPE_CODE
, DOC.CALLING_APP_DOC_UNIQUE_REF1
, DOC.CALLING_APP_DOC_REF_NUMBER
, DOC.BANK_ASSIGNED_REF_CODE
, DOC.UNIQUE_REMITTANCE_IDENTIFIER
, DOC.URI_CHECK_DIGIT
, DOC.DOCUMENT_CATEGORY_CODE
, FND_DOC_SEQ.NAME
, DOC.DOCUMENT_SEQUENCE_VALUE
, DOC.PO_NUMBER
, DOC.DOCUMENT_STATUS
, DOCUMENT_STATUS_LOOKUP.MEANING
, DOC.DOCUMENT_DATE
, DOC.CREATION_DATE
, DOC.PAYMENT_DUE_DATE
, DOC.DOCUMENT_TYPE
, DOCUMENT_TYPE_LOOKUP.MEANING
, DOC.DOCUMENT_DESCRIPTION
, DOC.DOCUMENT_AMOUNT
, DOC.DOCUMENT_CURRENCY_CODE
, DOC.PAYMENT_AMOUNT
, DOC.PAYMENT_CURRENCY_CODE
, DOC.DISCOUNT_DATE
, DOC.PAYMENT_CURR_DISCOUNT_TAKEN
, DOC.DOCUMENT_CURR_CHARGE_AMOUNT
, DOC.INTEREST_RATE
, DOC.BANK_CHARGE_BEARER
, BANK_CHARGE_BEARER_LOOKUP.MEANING
, DOC.EXCLUSIVE_PAYMENT_FLAG
, DOC.DELIVERY_CHANNEL_CODE
, DELIVERY_CHANNELS.MEANING
, DELIVERY_CHANNELS.FORMAT_VALUE
, DOC.SETTLEMENT_PRIORITY
, SETTLEMENT_PRIORITY_LOOKUP.MEANING
, DOC.AMOUNT_WITHHELD
, DOC.PAYMENT_REASON_CODE
, PAYMENT_REASONS.MEANING
, PAYMENT_REASONS.FORMAT_VALUE
, PAYMENT_REASON_COMMENTS
, DOC.REMITTANCE_MESSAGE1
, DOC.REMITTANCE_MESSAGE2
, DOC.REMITTANCE_MESSAGE3
, DOC.ATTRIBUTE_CATEGORY
FROM IBY_DOCS_PAYABLE_ALL DOC
, FND_DOCUMENT_SEQUENCES FND_DOC_SEQ
, IBY_DELIVERY_CHANNELS_VL DELIVERY_CHANNELS
, IBY_PAYMENT_REASONS_VL PAYMENT_REASONS
, FND_LOOKUPS DOCUMENT_STATUS_LOOKUP
, FND_LOOKUPS DOCUMENT_TYPE_LOOKUP
, FND_LOOKUPS SETTLEMENT_PRIORITY_LOOKUP
, FND_LOOKUPS BANK_CHARGE_BEARER_LOOKUP
WHERE DOC.DOCUMENT_SEQUENCE_ID = FND_DOC_SEQ.DOC_SEQUENCE_ID(+)
AND DOC.DELIVERY_CHANNEL_CODE = DELIVERY_CHANNELS.DELIVERY_CHANNEL_CODE(+)
AND DOC.PAYMENT_REASON_CODE = PAYMENT_REASONS.PAYMENT_REASON_CODE(+)
AND DOC.DOCUMENT_STATUS = DOCUMENT_STATUS_LOOKUP.LOOKUP_CODE
AND DOCUMENT_STATUS_LOOKUP.LOOKUP_TYPE = 'IBY_DOCS_PAYABLE_STATUSES'
AND DOC.DOCUMENT_TYPE = DOCUMENT_TYPE_LOOKUP.LOOKUP_CODE
AND DOCUMENT_TYPE_LOOKUP.LOOKUP_TYPE = 'IBY_DOCUMENT_TYPES'
AND DOC.SETTLEMENT_PRIORITY = SETTLEMENT_PRIORITY_LOOKUP.LOOKUP_CODE(+)
AND SETTLEMENT_PRIORITY_LOOKUP.LOOKUP_TYPE(+) = 'IBY_SETTLEMENT_PRIORITY'
AND DOC.BANK_CHARGE_BEARER = BANK_CHARGE_BEARER_LOOKUP.LOOKUP_CODE(+)
AND BANK_CHARGE_BEARER_LOOKUP.LOOKUP_TYPE(+) = 'IBY_BANK_CHARGE_BEARER'

Columns