IBY_FNDCPT_SYS_CC_PF_VL

Details

• Schema: FUSION

• Object owner: IBY

• Object type: VIEW

Columns

Name

ROW_ID SETTLEMENT_TRANS_PRTCL_CODE SETTLEMENT_ACK_RDR_CODE QUERY_FORMAT_CODE QUERY_TRANS_PRTCL_CODE QUERY_ACK_RDR_CODE INACTIVE_DATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN GROUP_BY_ORG OBJECT_VERSION_NUMBER GROUP_BY_LEGAL_ENTITY ONLINE_AUTH_FORMAT_CODE GROUP_BY_INT_BANK_ACCOUNT ONLINE_AUTH_TRANS_PRTCL_CODE GROUP_BY_SETTLEMENT_CURR ONLINE_AUTH_ACK_RDR_CODE GROUP_BY_SETTLEMENT_DATE SETTLEMENT_FORMAT_CODE LIMIT_BY_AMT_CURR SYS_CC_PROFILE_CODE LIMIT_BY_EXCH_RATE_TYPE PAYMENT_SYSTEM_ID LIMIT_BY_TOTAL_AMT SYS_CC_PROFILE_NAME LIMIT_BY_SETTLEMENT_NUM AUTOMATIC_PN_SUBMIT_FLAG OVERRIDE_PAYER_DELIVERY_FLAG PAYER_NOTIFICATION_FORMAT PAYER_NOTIFICATION_DEL_METHOD SETTLEMENT_COMPLETE_POINT DESCRIPTION ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 START_DATE END_DATE PAYER_NOTIFICATION_CONDITION PAYER_NOTIFY_INVOICES_COUNT SETTLEMENT_FILE_DIRECTORY SETTLEMENT_FILE_EXTENSION SETTLEMENT_FILE_PREFIX EXTERNAL_SETTLEMENT_FLAG

Query

SQL_Statement

SELECT B.ROWID ROW_ID, B.SETTLEMENT_TRANS_PRTCL_CODE, B.SETTLEMENT_ACK_RDR_CODE, B.QUERY_FORMAT_CODE, B.QUERY_TRANS_PRTCL_CODE, B.QUERY_ACK_RDR_CODE, B.INACTIVE_DATE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.GROUP_BY_ORG, B.OBJECT_VERSION_NUMBER, B.GROUP_BY_LEGAL_ENTITY, B.ONLINE_AUTH_FORMAT_CODE, B.GROUP_BY_INT_BANK_ACCOUNT, B.ONLINE_AUTH_TRANS_PRTCL_CODE, B.GROUP_BY_SETTLEMENT_CURR, B.ONLINE_AUTH_ACK_RDR_CODE, B.GROUP_BY_SETTLEMENT_DATE, B.SETTLEMENT_FORMAT_CODE, B.LIMIT_BY_AMT_CURR, B.SYS_CC_PROFILE_CODE, B.LIMIT_BY_EXCH_RATE_TYPE, B.PAYMENT_SYSTEM_ID, B.LIMIT_BY_TOTAL_AMT, T.SYS_CC_PROFILE_NAME, B.LIMIT_BY_SETTLEMENT_NUM, B.AUTOMATIC_PN_SUBMIT_FLAG, B.OVERRIDE_PAYER_DELIVERY_FLAG, B.PAYER_NOTIFICATION_FORMAT, B.PAYER_NOTIFICATION_DEL_METHOD, B.SETTLEMENT_COMPLETE_POINT, T.DESCRIPTION, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, B.START_DATE, B.END_DATE, B.PAYER_NOTIFICATION_CONDITION, B.PAYER_NOTIFY_INVOICES_COUNT, B.SETTLEMENT_FILE_DIRECTORY, B.SETTLEMENT_FILE_EXTENSION, B.SETTLEMENT_FILE_PREFIX, B.EXTERNAL_SETTLEMENT_FLAG FROM IBY_FNDCPT_SYS_CC_PF_TL T, IBY_FNDCPT_SYS_CC_PF_B B WHERE B.SYS_CC_PROFILE_CODE = T.SYS_CC_PROFILE_CODE AND T.LANGUAGE = USERENV('LANG')