View: IBY_EXT_FD_PMT_1_0_V

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

View Text

SELECT PMT.PAYMENT_INSTRUCTION_ID
, PMT.PAYMENT_ID
, PMT.INTERNAL_BANK_ACCOUNT_ID
, PMT.LEGAL_ENTITY_ID
, REQ.CALLING_APP_ID
, FNDAPP.APPLICATION_SHORT_NAME
, PMT.PAYMENT_SERVICE_REQUEST_ID
, PMT.PAYMENT_FUNCTION
, PAYMENT_FUNCTION_LOOKUP.MEANING
, PMT.ORG_ID
, PMT.ORG_TYPE
, ORG_TYPE_LOOKUP.MEANING
, CE_SP.NAME
, PMT.DOCUMENT_CATEGORY_CODE
, FND_DOC_SEQ.NAME
, PMT.DOCUMENT_SEQUENCE_VALUE
, PMT.PAYMENT_REFERENCE_NUMBER
, PMT.PAPER_DOCUMENT_NUMBER
, PMT.PAYMENT_DATE
, PMT.PAYMENT_DUE_DATE
, PMT.MATURITY_DATE
, PMT.PAYMENT_STATUS
, PAYMENT_STATUS_LOOKUP.MEANING
, PMT.PAYEE_PARTY_ID
, PMT.PARTY_SITE_ID
, PMT.EXTERNAL_BANK_ACCOUNT_ID
, PMT.PAYMENT_AMOUNT
, PMT.PAYMENT_CURRENCY_CODE
, IBY_FD_EXTRACT_GEN_PVT.GET_PAYMENT_AMOUNT_TEXT(PMT.PAYMENT_ID)
, PMT.PAYMENT_METHOD_CODE
, PAYMENT_METHODS.PAYMENT_METHOD_NAME
, PAYMENT_METHODS.ATTRIBUTE_CATEGORY
, PMT.EXCLUSIVE_PAYMENT_FLAG
, PMT.SETTLEMENT_PRIORITY
, SETTLEMENT_PRIORITY_LOOKUP.MEANING
, IBY_FD_EXTRACT_GEN_PVT.GET_PAYMENT_AMOUNT_WITHHELD(PMT.PAYMENT_ID)
, PMT.DISCOUNT_AMOUNT_TAKEN
, PMT.BANK_CHARGE_BEARER
, BANK_CHARGE_BEARER_LOOKUP.MEANING
, PMT.BANK_CHARGE_AMOUNT
, PMT.DELIVERY_CHANNEL_CODE
, DELIVERY_CHANNELS.MEANING
, DELIVERY_CHANNELS.FORMAT_VALUE
, PMT.BANK_INSTRUCTION1_CODE
, BANK_INSTRUCTIONS1.MEANING
, BANK_INSTRUCTIONS1.FORMAT_VALUE
, PMT.BANK_INSTRUCTION2_CODE
, BANK_INSTRUCTIONS2.MEANING
, BANK_INSTRUCTIONS2.FORMAT_VALUE
, PMT.BANK_INSTRUCTION_DETAILS
, PMT.PAYMENT_TEXT_MESSAGE1
, PMT.PAYMENT_TEXT_MESSAGE2
, PMT.PAYMENT_TEXT_MESSAGE3
, PMT.PAYMENT_DETAILS
, PMT.UNIQUE_REMITTANCE_IDENTIFIER
, PMT.URI_CHECK_DIGIT
, PMT.PAYMENT_REASON_CODE
, PAYMENT_REASONS.MEANING
, PAYMENT_REASONS.FORMAT_VALUE
, PMT.PAYMENT_REASON_COMMENTS
, PMT.REMITTANCE_MESSAGE1
, PMT.REMITTANCE_MESSAGE2
, PMT.REMITTANCE_MESSAGE3
, PMT.DECLARE_PAYMENT_FLAG
, PMT.DECLARATION_AMOUNT
, PMT.DECLARATION_CURRENCY_CODE
, IBY_FD_EXTRACT_GEN_PVT.GET_ALLOTMENT_CODE(PMT.PAYMENT_ID)
, IBY_FD_EXTRACT_GEN_PVT.TOP_OFFSET_ELIGIBILITY_FLAG(PMT.PAYMENT_ID)
, PMT.ATTRIBUTE_CATEGORY
FROM IBY_PAYMENTS_ALL PMT
, IBY_PAY_SERVICE_REQUESTS REQ
, FND_APPLICATION FNDAPP
, FND_DOCUMENT_SEQUENCES FND_DOC_SEQ
, IBY_PAYMENT_METHODS_VL PAYMENT_METHODS
, IBY_DELIVERY_CHANNELS_VL DELIVERY_CHANNELS
, IBY_BANK_INSTRUCTIONS_VL BANK_INSTRUCTIONS1
, IBY_BANK_INSTRUCTIONS_VL BANK_INSTRUCTIONS2
, IBY_PAYMENT_REASONS_VL PAYMENT_REASONS
, FND_LOOKUPS PAYMENT_FUNCTION_LOOKUP
, FND_LOOKUPS PAYMENT_STATUS_LOOKUP
, FND_LOOKUPS SETTLEMENT_PRIORITY_LOOKUP
, FND_LOOKUPS BANK_CHARGE_BEARER_LOOKUP
, FND_LOOKUPS ORG_TYPE_LOOKUP
, CE_SECURITY_PROFILES_GT CE_SP
WHERE PMT.PAYMENT_SERVICE_REQUEST_ID = REQ.PAYMENT_SERVICE_REQUEST_ID
AND REQ.CALLING_APP_ID = FNDAPP.APPLICATION_ID
AND PMT.DOCUMENT_SEQUENCE_ID = FND_DOC_SEQ.DOC_SEQUENCE_ID(+)
AND PMT.PAYMENT_METHOD_CODE = PAYMENT_METHODS.PAYMENT_METHOD_CODE
AND PMT.ORG_ID = CE_SP.ORGANIZATION_ID
AND PMT.ORG_TYPE = CE_SP.ORGANIZATION_TYPE
AND PMT.DELIVERY_CHANNEL_CODE = DELIVERY_CHANNELS.DELIVERY_CHANNEL_CODE(+)
AND PMT.BANK_INSTRUCTION1_CODE = BANK_INSTRUCTIONS1.BANK_INSTRUCTION_CODE(+)
AND PMT.BANK_INSTRUCTION2_CODE = BANK_INSTRUCTIONS2.BANK_INSTRUCTION_CODE(+)
AND PMT.PAYMENT_REASON_CODE = PAYMENT_REASONS.PAYMENT_REASON_CODE(+)
AND PMT.PAYMENT_FUNCTION = PAYMENT_FUNCTION_LOOKUP.LOOKUP_CODE
AND PAYMENT_FUNCTION_LOOKUP.LOOKUP_TYPE = 'IBY_PAYMENT_FUNCTIONS'
AND PMT.PAYMENT_STATUS = PAYMENT_STATUS_LOOKUP.LOOKUP_CODE
AND PAYMENT_STATUS_LOOKUP.LOOKUP_TYPE = 'IBY_PAYMENT_STATUSES'
AND PMT.SETTLEMENT_PRIORITY = SETTLEMENT_PRIORITY_LOOKUP.LOOKUP_CODE(+)
AND SETTLEMENT_PRIORITY_LOOKUP.LOOKUP_TYPE(+) = 'IBY_SETTLEMENT_PRIORITY'
AND PMT.BANK_CHARGE_BEARER = BANK_CHARGE_BEARER_LOOKUP.LOOKUP_CODE(+)
AND BANK_CHARGE_BEARER_LOOKUP.LOOKUP_TYPE(+) = 'IBY_BANK_CHARGE_BEARER'
AND PMT.ORG_TYPE = ORG_TYPE_LOOKUP.LOOKUP_CODE
AND ORG_TYPE_LOOKUP.LOOKUP_TYPE = 'IBY_ORGANIZATION_TYPES'

Columns