Product: | CE - Cash Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.CE_DOCUMENTS_PAYABLE |
SELECT I.TRANSACTION_TYPE AS PAY_PROC_TRXN_TYPE_CODE
, '260' CALLING_APP_ID
, I.TRXN_REFERENCE_NUMBER AS CALLING_APP_UNIQUE_REF1
, NULL AS CALLING_APP_DOC_UNIQUE_REF2
, NULL AS CALLING_APP_DOC_UNIQUE_REF3
, NULL AS CALLING_APP_DOC_UNIQUE_REF4
, NULL AS CALLING_APP_DOC_UNIQUE_REF5
, I.TRXN_REFERENCE_NUMBER AS CALLING_APP_DOC_REF_NUMBER
, NULL AS PO_NUMBER
, I.PAYMENT_REQUEST_NUMBER AS CALL_APP_PAY_SERVICE_REQ_CODE
, 'CASH_PAYMENT' AS PAYMENT_FUNCTION
, I.TRANSACTION_DATE AS PAYMENT_DATE
, I.ANTICIPATED_VALUE_DATE AS ANTICIPATED_VALUE_DATE
, I.TRANSACTION_DATE AS DOCUMENT_DATE
, I.TRANSACTION_TYPE AS DOCUMENT_TYPE
, I.TRANSACTION_DESCRIPTION AS DOCUMENT_DESCRIPTION
, I.PAYMENT_CURRENCY_CODE AS DOCUMENT_CURRENCY_CODE
, I.PAYMENT_AMOUNT AS DOCUMENT_AMOUNT
, NULL AS DOCUMENT_CURRENCY_TAX_AMOUNT
, NULL AS DOCUMENT_CURR_CHARGE_AMOUNT
, I.PAYMENT_CURRENCY_CODE AS PAYMENT_CURRENCY_CODE
, I.PAYMENT_AMOUNT AS PAYMENT_AMOUNT
, NULL AS AMOUNT_WITHHELD
, NULL AS PAYMENT_CURR_DISCOUNT_TAKEN
, NULL AS DISCOUNT_DATE
, NULL AS PAYMENT_DUE_DATE
, I.PAYMENT_METHOD_CODE AS PAYMENT_METHOD_CODE
, NULL AS PAYMENT_PROFILE_ID
, 'Y' AS EXCLUSIVE_PAYMENT_FLAG
, I.SOURCE_BANK_ACCOUNT_ID AS INTERNAL_BANK_ACCOUNT_ID
, I.EXT_BANK_ACCOUNT_ID AS EXTERNAL_BANK_ACCOUNT_ID
, I.DESTINATION_PARTY_ID AS PAYEE_PARTY_ID
, I.DESTINATION_PARTY_SITE_ID AS PARTY_SITE_ID
, NULL AS SUPPLIER_SITE_ID
, I.SOURCE_LEGAL_ENTITY_ID AS ORG_ID
, 'LEGAL_ENTITY' AS ORG_TYPE
, I.SOURCE_LEGAL_ENTITY_ID AS LEGAL_ENTITY_ID
, I.BANK_CHARGE_BEARER AS BANK_CHARGE_BEARER
, NULL AS INTEREST_RATE
, NULL AS PAYMENT_GROUPING_NUMBER
, I.PAYMENT_REASON_CODE AS PAYMENT_REASON_CODE
, I.PAYMENT_REASON_COMMENTS AS PAYMENT_REASON_COMMENTS
, NULL AS SETTLEMENT_PRIORITY
, I.REMITTANCE_MESSAGE1 AS REMITTANCE_MESSAGE1
, I.REMITTANCE_MESSAGE2 AS REMITTANCE_MESSAGE2
, I.REMITTANCE_MESSAGE3 AS REMITTANCE_MESSAGE3
, NULL AS UNIQUE_REMITTANCE_IDENTIFIER
, NULL AS URI_CHECK_DIGIT
, NULL AS DELIVERY_CHANNEL_CODE
, I.DOC_SEQUENCE_ID AS DOCUMENT_SEQUENCE_ID
, I.DOC_SEQUENCE_VALUE AS DOCUMENT_SEQUENCE_VALUE
, I.DOC_CATEGORY_CODE AS DOCUMENT_CATEGORY_CODE
, I.ATTRIBUTE_CATEGORY AS ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1 AS ATTRIBUTE1
, I.ATTRIBUTE2 AS ATTRIBUTE2
, I.ATTRIBUTE3 AS ATTRIBUTE3
, I.ATTRIBUTE4 AS ATTRIBUTE4
, I.ATTRIBUTE5 AS ATTRIBUTE5
, I.ATTRIBUTE6 AS ATTRIBUTE6
, I.ATTRIBUTE7 AS ATTRIBUTE7
, I.ATTRIBUTE8 AS ATTRIBUTE8
, I.ATTRIBUTE9 AS ATTRIBUTE9
, I.ATTRIBUTE10 AS ATTRIBUTE10
, I.ATTRIBUTE11 AS ATTRIBUTE11
, I.ATTRIBUTE12 AS ATTRIBUTE12
, I.ATTRIBUTE13 AS ATTRIBUTE13
, I.ATTRIBUTE14 AS ATTRIBUTE14
, I.ATTRIBUTE15 AS ATTRIBUTE15
, 'Y' AS ALLOW_REMOVING_DOCUMENT_FLAG
, NULL AS REMIT_TO_LOCATION_ID
, I.CREATED_BY AS CREATED_BY
, I.CREATION_DATE AS CREATION_DATE
, I.LAST_UPDATED_BY AS LAST_UPDATED_BY
, I.LAST_UPDATE_DATE AS LAST_UPDATE_DATE
, I.LAST_UPDATE_LOGIN AS LAST_UPDATE_LOGIN
, I.OBJECT_VERSION_NUMBER AS OBJECT_VERSION_NUMBER
, NULL AS PAYMENT_FORMAT_CODE
, NULL AS BANK_ASSIGNED_REF_CODE
, I.DESTINATION_PARTY_ID AS BENEFICIARY_PARTY
, 'TCA'
, NULL
, NULL
, 'N'
, NULL
FROM CE_PAYMENT_TRANSACTIONS I