CE_DOCUMENTS_PAYABLE

Details

• Schema: FUSION

• Object owner: CE

• Object type: VIEW

Columns

Name

DOC_CURRENCY_PAYMENT_AMOUNT PAY_GROUP_CODE INVOICING_ORG_TYPE INVOICING_ORG_ID REMIT_ADDRESS_ID PAY_PROC_TRXN_TYPE_CODE CALLING_APP_ID CALLING_APP_DOC_UNIQUE_REF1 CALLING_APP_DOC_UNIQUE_REF2 CALLING_APP_DOC_UNIQUE_REF3 CALLING_APP_DOC_UNIQUE_REF4 CALLING_APP_DOC_UNIQUE_REF5 CALLING_APP_DOC_REF_NUMBER PO_NUMBER CALL_APP_PAY_SERVICE_REQ_CODE PAYMENT_FUNCTION PAYMENT_DATE ANTICIPATED_VALUE_DATE DOCUMENT_DATE DOCUMENT_TYPE DOCUMENT_DESCRIPTION DOCUMENT_CURRENCY_CODE DOCUMENT_AMOUNT DOCUMENT_CURRENCY_TAX_AMOUNT DOCUMENT_CURR_CHARGE_AMOUNT PAYMENT_CURRENCY_CODE PAYMENT_AMOUNT AMOUNT_WITHHELD PAYMENT_CURR_DISCOUNT_TAKEN DISCOUNT_DATE PAYMENT_DUE_DATE PAYMENT_METHOD_CODE PAYMENT_PROFILE_ID EXCLUSIVE_PAYMENT_FLAG INTERNAL_BANK_ACCOUNT_ID EXTERNAL_BANK_ACCOUNT_ID PAYEE_PARTY_ID PARTY_SITE_ID SUPPLIER_SITE_ID ORG_ID ORG_TYPE LEGAL_ENTITY_ID BANK_CHARGE_BEARER INTEREST_RATE PAYMENT_GROUPING_NUMBER PAYMENT_REASON_CODE PAYMENT_REASON_COMMENTS REMITTANCE_MESSAGE1 SETTLEMENT_PRIORITY REMITTANCE_MESSAGE2 REMITTANCE_MESSAGE3 UNIQUE_REMITTANCE_IDENTIFIER URI_CHECK_DIGIT DELIVERY_CHANNEL_CODE DOCUMENT_SEQUENCE_ID DOCUMENT_SEQUENCE_VALUE DOCUMENT_CATEGORY_CODE ALLOW_REMOVING_DOCUMENT_FLAG REMIT_TO_LOCATION_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER PAYMENT_FORMAT_CODE BANK_ASSIGNED_REF_CODE BENEFICIARY_PARTY REMIT_PAYEE_PARTY_ID REMIT_PARTY_SITE_ID REMIT_SUPPLIER_SITE_ID REMIT_BENEFICIARY_PARTY ADDRESS_SOURCE AFFECTS_REJECTION_LEVEL EMPLOYEE_ADDRESS_CODE RELATIONSHIP_ID DOC_CURR_AMOUNT_WITHHELD DOC_CURR_DISCOUNT_TAKEN EMPLOYEE_PAYMENT_FLAG EMPLOYEE_PERSON_ID EMPLOYEE_ADDRESS_ID ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE_DATE1 GLOBAL_ATTRIBUTE_DATE2 GLOBAL_ATTRIBUTE_DATE3 GLOBAL_ATTRIBUTE_DATE4 GLOBAL_ATTRIBUTE_DATE5 GLOBAL_ATTRIBUTE_NUMBER1 GLOBAL_ATTRIBUTE_NUMBER2 GLOBAL_ATTRIBUTE_NUMBER3 GLOBAL_ATTRIBUTE_NUMBER4 GLOBAL_ATTRIBUTE_NUMBER5 SET_OF_BOOKS_ID PAYMENT_MODE_CODE PAYMENT_INSTRUMENT_ID

Query

SQL_Statement

SELECT I.PAYMENT_AMOUNT AS DOC_CURRENCY_PAYMENT_AMOUNT, NULL AS PAY_GROUP_CODE, 'OPERATING_UNIT' AS INVOICING_ORG_TYPE, I.FROM_ORG_ID AS INVOICING_ORG_ID, NULL AS REMIT_ADDRESS_ID, I.TRANSFER_TYPE_CODE AS PAY_PROC_TRXN_TYPE_CODE, '260' AS CALLING_APP_ID, I.TRANSFER_ID AS CALLING_APP_DOC_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.TRANSFER_ID AS CALLING_APP_DOC_REF_NUMBER, NULL AS PO_NUMBER, I.PAYMENT_REQUEST_ID AS CALL_APP_PAY_SERVICE_REQ_CODE, I.PAYMENT_FUNCTION_CODE AS PAYMENT_FUNCTION, I.TRANSACTION_DATE AS PAYMENT_DATE, I.TRANSACTION_DATE AS ANTICIPATED_VALUE_DATE, I.TRANSACTION_DATE AS DOCUMENT_DATE, I.TRANSFER_TYPE_CODE AS DOCUMENT_TYPE, I.MEMO 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, I.PROFILE_ID AS PAYMENT_PROFILE_ID, 'Y' AS EXCLUSIVE_PAYMENT_FLAG , I.FROM_BANK_ACCT_ID AS INTERNAL_BANK_ACCOUNT_ID, I.EXT_BANK_ACCT_ID AS EXTERNAL_BANK_ACCOUNT_ID, I.PAYEE_PARTY_ID AS PAYEE_PARTY_ID, I.PAYEE_PARTY_SITE_ID AS PARTY_SITE_ID, NULL AS SUPPLIER_SITE_ID, I.FROM_ORG_ID AS ORG_ID, 'OPERATING_UNIT' AS ORG_TYPE, NULL AS LEGAL_ENTITY_ID, NULL AS BANK_CHARGE_BEARER, NULL AS INTEREST_RATE, NULL AS PAYMENT_GROUPING_NUMBER , NULL AS PAYMENT_REASON_CODE , NULL AS PAYMENT_REASON_COMMENTS , NULL AS REMITTANCE_MESSAGE1 , NULL AS SETTLEMENT_PRIORITY , NULL AS REMITTANCE_MESSAGE2 , NULL AS REMITTANCE_MESSAGE3 , NULL AS UNIQUE_REMITTANCE_IDENTIFIER , NULL AS URI_CHECK_DIGIT , NULL AS DELIVERY_CHANNEL_CODE , NULL AS DOCUMENT_SEQUENCE_ID , NULL AS DOCUMENT_SEQUENCE_VALUE , NULL AS DOCUMENT_CATEGORY_CODE , 'Y' AS ALLOW_REMOVING_DOCUMENT_FLAG , PS.LOCATION_ID 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.PAYEE_PARTY_ID AS BENEFICIARY_PARTY , I.PAYEE_PARTY_ID AS REMIT_PAYEE_PARTY_ID , I.PAYEE_PARTY_SITE_ID AS REMIT_PARTY_SITE_ID , NULL AS REMIT_SUPPLIER_SITE_ID , I.PAYEE_PARTY_ID AS REMIT_BENEFICIARY_PARTY , 'TCA' AS ADDRESS_SOURCE, 'N' AS AFFECTS_REJECTION_LEVEL, NULL AS EMPLOYEE_ADDRESS_CODE, NULL AS RELATIONSHIP_ID, NULL AS DOC_CURR_AMOUNT_WITHHELD, NULL AS DOC_CURR_DISCOUNT_TAKEN, 'N' AS EMPLOYEE_PAYMENT_FLAG, NULL AS EMPLOYEE_PERSON_ID, NULL AS EMPLOYEE_ADDRESS_ID, 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, NULL AS GLOBAL_ATTRIBUTE_CATEGORY, NULL AS GLOBAL_ATTRIBUTE1, NULL AS GLOBAL_ATTRIBUTE2, NULL AS GLOBAL_ATTRIBUTE3, NULL AS GLOBAL_ATTRIBUTE4, NULL AS GLOBAL_ATTRIBUTE5, NULL AS GLOBAL_ATTRIBUTE6, NULL AS GLOBAL_ATTRIBUTE7, NULL AS GLOBAL_ATTRIBUTE8, NULL AS GLOBAL_ATTRIBUTE9, NULL AS GLOBAL_ATTRIBUTE10, NULL AS GLOBAL_ATTRIBUTE11, NULL AS GLOBAL_ATTRIBUTE12, NULL AS GLOBAL_ATTRIBUTE13, NULL AS GLOBAL_ATTRIBUTE14, NULL AS GLOBAL_ATTRIBUTE15, NULL AS GLOBAL_ATTRIBUTE16, NULL AS GLOBAL_ATTRIBUTE17, NULL AS GLOBAL_ATTRIBUTE18, NULL AS GLOBAL_ATTRIBUTE19, NULL AS GLOBAL_ATTRIBUTE20, NULL AS GLOBAL_ATTRIBUTE_DATE1, NULL AS GLOBAL_ATTRIBUTE_DATE2, NULL AS GLOBAL_ATTRIBUTE_DATE3, NULL AS GLOBAL_ATTRIBUTE_DATE4, NULL AS GLOBAL_ATTRIBUTE_DATE5, NULL AS GLOBAL_ATTRIBUTE_NUMBER1, NULL AS GLOBAL_ATTRIBUTE_NUMBER2, NULL AS GLOBAL_ATTRIBUTE_NUMBER3, NULL AS GLOBAL_ATTRIBUTE_NUMBER4, NULL AS GLOBAL_ATTRIBUTE_NUMBER5, NULL AS SET_OF_BOOKS_ID, NULL AS PAYMENT_MODE_CODE, NULL AS PAYMENT_INSTRUMENT_ID FROM CE_BAT_TRANSFERS I, HZ_PARTY_SITES PS where I.PAYEE_PARTY_SITE_ID = PS.PARTY_SITE_ID(+)