VIEW: APPS.CE_DOCUMENTS_PAYABLE

Source

View Text - Preformatted

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 ,I.DESTINATION_PARTY_ID AS REMIT_PAYEE_PARTY_ID ,I.DESTINATION_PARTY_SITE_ID AS REMIT_PARTY_SITE_ID ,NULL AS REMIT_SUPPLIER_SITE_ID ,I.DESTINATION_PARTY_ID AS REMIT_BENEFICIARY_PARTY ,NULL AS RELATIONSHIP_ID ,'TCA' ,NULL ,NULL ,'N' ,NULL ,NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , NULL , 'N' FROM CE_PAYMENT_TRANSACTIONS I

View Text - HTML Formatted

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
, I.DESTINATION_PARTY_ID AS REMIT_PAYEE_PARTY_ID
, I.DESTINATION_PARTY_SITE_ID AS REMIT_PARTY_SITE_ID
, NULL AS REMIT_SUPPLIER_SITE_ID
, I.DESTINATION_PARTY_ID AS REMIT_BENEFICIARY_PARTY
, NULL AS RELATIONSHIP_ID
, 'TCA'
, NULL
, NULL
, 'N'
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 'N'
FROM CE_PAYMENT_TRANSACTIONS I