IBY_FD_PAYMENTS_V

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name

COMPLETED_PMTS_GROUP_ID PAYMENT_REASON_COMMENTS PAYMENT_DATE ANTICIPATED_VALUE_DATE DECLARATION_AMOUNT DECLARATION_CURRENCY_CODE DISCOUNT_AMOUNT_TAKEN BANK_CHARGE_AMOUNT SETTLEMENT_PRIORITY PAYMENT_ID PAYMENT_METHOD_CODE PAYMENT_SERVICE_REQUEST_ID PROCESS_TYPE PAYMENT_STATUS PAYMENTS_COMPLETE_FLAG PAYMENT_FUNCTION PAYMENT_AMOUNT PAYMENT_CURRENCY_CODE STOP_CONFIRMED_BY STOP_CONFIRM_DATE STOP_CONFIRM_REASON STOP_CONFIRM_REFERENCE STOP_RELEASED_BY STOP_RELEASE_DATE STOP_RELEASE_REASON STOP_RELEASE_REFERENCE STOP_REQUEST_DATE STOP_REQUEST_PLACED_BY STOP_REQUEST_REASON STOP_REQUEST_REFERENCE VOIDED_BY VOID_DATE VOID_REASON ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 STOP_CONFIRMED_FLAG STOP_RELEASED_FLAG STOP_REQUEST_PLACED_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN LAST_UPDATE_DATE OBJECT_VERSION_NUMBER PAYEE_PARTY_ID PARTY_SITE_ID PARTY_SITE_NAME PAYEE_SUPPLIER_ID SUPPLIER_SITE_ID PAYMENT_REASON_CODE REMIT_TO_LOCATION_ID ORG_ID ORG_TYPE LEGAL_ENTITY_ID DECLARE_PAYMENT_FLAG DELIVERY_CHANNEL_CODE EXT_PAYEE_ID PAYMENT_INSTRUCTION_ID PAYMENT_PROFILE_ID PREGROUPED_PAYMENT_FLAG REMITTANCE_MESSAGE1 REMITTANCE_MESSAGE2 PAYMENT_DETAILS BANK_CHARGE_BEARER SEPARATE_REMIT_ADVICE_REQ_FLAG INTERNAL_BANK_ACCOUNT_ID BILL_PAYABLE_FLAG EXCLUSIVE_PAYMENT_FLAG REMITTANCE_MESSAGE3 PAYMENT_REFERENCE_NUMBER PAPER_DOCUMENT_NUMBER BANK_ASSIGNED_REF_CODE EXTERNAL_BANK_ACCOUNT_ID UNIQUE_REMITTANCE_IDENTIFIER URI_CHECK_DIGIT BANK_INSTRUCTION1_CODE BANK_INSTRUCTION2_CODE BANK_INSTRUCTION_DETAILS PAYMENT_TEXT_MESSAGE1 PAYMENT_TEXT_MESSAGE2 PAYMENT_TEXT_MESSAGE3 MATURITY_DATE PAYMENT_DUE_DATE DOCUMENT_CATEGORY_CODE DOCUMENT_SEQUENCE_ID EXT_BRANCH_NUMBER DOCUMENT_SEQUENCE_VALUE EXT_BANK_NUMBER BENEFICIARY_PARTY EXT_BANK_ACCOUNT_NAME EXT_BANK_ACCOUNT_NUMBER EXT_BANK_ACCOUNT_TYPE EXT_BANK_ACCOUNT_IBAN_NUMBER PAYEE_NAME PAYEE_ADDRESS1 PAYEE_ADDRESS2 PAYEE_ADDRESS3 PAYEE_ADDRESS4 PAYEE_CITY PAYEE_POSTAL_CODE PAYEE_STATE PAYEE_PROVINCE PAYEE_COUNTY PAYEE_COUNTRY PAYMENT_DOCUMENT_ID ADDRESS_SOURCE EMPLOYEE_ADDRESS_CODE EMPLOYEE_PERSON_ID EMPLOYEE_PAYMENT_FLAG EMPLOYEE_ADDRESS_ID REQUEST_ID INV_EXT_PAYEE_ID INV_PAYEE_PARTY_ID INV_PARTY_SITE_ID INV_SUPPLIER_SITE_ID INV_PAYEE_PARTY_NAME INV_PAYEE_ADDRESS1 INV_PAYEE_ADDRESS2 INV_PAYEE_ADDRESS3 INV_PAYEE_ADDRESS4 INV_PAYEE_CITY INV_PAYEE_POSTAL_CODE INV_PAYEE_STATE INV_PAYEE_PROVINCE INV_PAYEE_COUNTY INV_PAYEE_COUNTRY RELATIONSHIP_ID PAYMENT_MODE_CODE PAYMENT_INSTRUMENT_ID BEP_TRXN_RESPONSE_ID

Query

SQL_Statement

SELECT IBY_PAY.COMPLETED_PMTS_GROUP_ID,IBY_PAY.PAYMENT_REASON_COMMENTS,IBY_PAY.PAYMENT_DATE,IBY_PAY.ANTICIPATED_VALUE_DATE,IBY_PAY.DECLARATION_AMOUNT,IBY_PAY.DECLARATION_CURRENCY_CODE,IBY_PAY.DISCOUNT_AMOUNT_TAKEN,IBY_PAY.BANK_CHARGE_AMOUNT,IBY_PAY.SETTLEMENT_PRIORITY,IBY_PAY.PAYMENT_ID,IBY_PAY.PAYMENT_METHOD_CODE,IBY_PAY.PAYMENT_SERVICE_REQUEST_ID,IBY_PAY.PROCESS_TYPE,IBY_PAY.PAYMENT_STATUS,IBY_PAY.PAYMENTS_COMPLETE_FLAG,IBY_PAY.PAYMENT_FUNCTION,IBY_PAY.PAYMENT_AMOUNT,IBY_PAY.PAYMENT_CURRENCY_CODE,IBY_PAY.STOP_CONFIRMED_BY,IBY_PAY.STOP_CONFIRM_DATE,IBY_PAY.STOP_CONFIRM_REASON,IBY_PAY.STOP_CONFIRM_REFERENCE,IBY_PAY.STOP_RELEASED_BY,IBY_PAY.STOP_RELEASE_DATE,IBY_PAY.STOP_RELEASE_REASON,IBY_PAY.STOP_RELEASE_REFERENCE,IBY_PAY.STOP_REQUEST_DATE,IBY_PAY.STOP_REQUEST_PLACED_BY,IBY_PAY.STOP_REQUEST_REASON,IBY_PAY.STOP_REQUEST_REFERENCE,IBY_PAY.VOIDED_BY,IBY_PAY.VOID_DATE,IBY_PAY.VOID_REASON,IBY_PAY.ATTRIBUTE_CATEGORY,IBY_PAY.ATTRIBUTE1,IBY_PAY.ATTRIBUTE2,IBY_PAY.ATTRIBUTE3,IBY_PAY.ATTRIBUTE4,IBY_PAY.ATTRIBUTE5,IBY_PAY.ATTRIBUTE6,IBY_PAY.ATTRIBUTE7,IBY_PAY.ATTRIBUTE8,IBY_PAY.ATTRIBUTE9,IBY_PAY.ATTRIBUTE10,IBY_PAY.ATTRIBUTE11,IBY_PAY.ATTRIBUTE12,IBY_PAY.ATTRIBUTE13,IBY_PAY.ATTRIBUTE14,IBY_PAY.ATTRIBUTE15,IBY_PAY.STOP_CONFIRMED_FLAG,IBY_PAY.STOP_RELEASED_FLAG,IBY_PAY.STOP_REQUEST_PLACED_FLAG,IBY_PAY.CREATED_BY,IBY_PAY.CREATION_DATE,IBY_PAY.LAST_UPDATED_BY,IBY_PAY.LAST_UPDATE_LOGIN,IBY_PAY.LAST_UPDATE_DATE,IBY_PAY.OBJECT_VERSION_NUMBER,IBY_PAY.PAYEE_PARTY_ID,IBY_PAY.PARTY_SITE_ID,IBY_PAY.PARTY_SITE_NAME,IBY_PAY.PAYEE_SUPPLIER_ID,IBY_PAY.SUPPLIER_SITE_ID,IBY_PAY.PAYMENT_REASON_CODE,IBY_PAY.REMIT_TO_LOCATION_ID,IBY_PAY.ORG_ID,IBY_PAY.ORG_TYPE,IBY_PAY.LEGAL_ENTITY_ID,IBY_PAY.DECLARE_PAYMENT_FLAG,IBY_PAY.DELIVERY_CHANNEL_CODE,IBY_PAY.EXT_PAYEE_ID,IBY_PAY.PAYMENT_INSTRUCTION_ID,IBY_PAY.PAYMENT_PROFILE_ID,IBY_PAY.PREGROUPED_PAYMENT_FLAG,IBY_PAY.REMITTANCE_MESSAGE1,IBY_PAY.REMITTANCE_MESSAGE2,IBY_PAY.PAYMENT_DETAILS,IBY_PAY.BANK_CHARGE_BEARER,IBY_PAY.SEPARATE_REMIT_ADVICE_REQ_FLAG,IBY_PAY.INTERNAL_BANK_ACCOUNT_ID,IBY_PAY.BILL_PAYABLE_FLAG,IBY_PAY.EXCLUSIVE_PAYMENT_FLAG,IBY_PAY.REMITTANCE_MESSAGE3,IBY_PAY.PAYMENT_REFERENCE_NUMBER,IBY_PAY.PAPER_DOCUMENT_NUMBER,IBY_PAY.BANK_ASSIGNED_REF_CODE,IBY_PAY.EXTERNAL_BANK_ACCOUNT_ID,IBY_PAY.UNIQUE_REMITTANCE_IDENTIFIER,IBY_PAY.URI_CHECK_DIGIT,IBY_PAY.BANK_INSTRUCTION1_CODE,IBY_PAY.BANK_INSTRUCTION2_CODE,IBY_PAY.BANK_INSTRUCTION_DETAILS,IBY_PAY.PAYMENT_TEXT_MESSAGE1,IBY_PAY.PAYMENT_TEXT_MESSAGE2,IBY_PAY.PAYMENT_TEXT_MESSAGE3,IBY_PAY.MATURITY_DATE,IBY_PAY.PAYMENT_DUE_DATE,IBY_PAY.DOCUMENT_CATEGORY_CODE,IBY_PAY.DOCUMENT_SEQUENCE_ID,IBY_PAY.EXT_BRANCH_NUMBER,IBY_PAY.DOCUMENT_SEQUENCE_VALUE,IBY_PAY.EXT_BANK_NUMBER,IBY_PAY.BENEFICIARY_PARTY,IBY_PAY.EXT_BANK_ACCOUNT_NAME,IBY_PAY.EXT_BANK_ACCOUNT_NUMBER,IBY_PAY.EXT_BANK_ACCOUNT_TYPE,IBY_PAY.EXT_BANK_ACCOUNT_IBAN_NUMBER,IBY_PAY.PAYEE_NAME,IBY_PAY.PAYEE_ADDRESS1,IBY_PAY.PAYEE_ADDRESS2,IBY_PAY.PAYEE_ADDRESS3,IBY_PAY.PAYEE_ADDRESS4,IBY_PAY.PAYEE_CITY,IBY_PAY.PAYEE_POSTAL_CODE,IBY_PAY.PAYEE_STATE,IBY_PAY.PAYEE_PROVINCE,IBY_PAY.PAYEE_COUNTY,IBY_PAY.PAYEE_COUNTRY,I.PAYMENT_DOCUMENT_ID,IBY_PAY.ADDRESS_SOURCE,IBY_PAY.EMPLOYEE_ADDRESS_CODE,IBY_PAY.EMPLOYEE_PERSON_ID,IBY_PAY.EMPLOYEE_PAYMENT_FLAG,IBY_PAY.EMPLOYEE_ADDRESS_ID,IBY_PAY.REQUEST_ID,IBY_PAY.INV_EXT_PAYEE_ID,IBY_PAY.INV_PAYEE_PARTY_ID,IBY_PAY.INV_PARTY_SITE_ID,IBY_PAY.INV_SUPPLIER_SITE_ID,IBY_PAY.INV_PAYEE_PARTY_NAME,IBY_PAY.INV_PAYEE_ADDRESS1,IBY_PAY.INV_PAYEE_ADDRESS2,IBY_PAY.INV_PAYEE_ADDRESS3,IBY_PAY.INV_PAYEE_ADDRESS4,IBY_PAY.INV_PAYEE_CITY,IBY_PAY.INV_PAYEE_POSTAL_CODE,IBY_PAY.INV_PAYEE_STATE,IBY_PAY.INV_PAYEE_PROVINCE,IBY_PAY.INV_PAYEE_COUNTY,IBY_PAY.INV_PAYEE_COUNTRY, IBY_FD_EXTRACT_GEN_PVT.Get_Relationship_Id(IBY_PAY.PAYEE_PARTY_ID,IBY_PAY.PARTY_SITE_ID,IBY_PAY.INV_SUPPLIER_SITE_ID,IBY_PAY.PAYMENT_DATE) RELATIONSHIP_ID ,IBY_PAY.PAYMENT_MODE_CODE, IBY_PAY.PAYMENT_INSTRUMENT_ID, IBY_PAY.BEP_TRXN_RESPONSE_ID FROM IBY_PAYMENTS_ALL IBY_PAY,IBY_PAY_INSTRUCTIONS_ALL I WHERE iby_pay.payment_instruction_id = i.payment_instruction_id(+)