IBY_FNDCPT_SYS_EFT_PF

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
ROW_ID QUERY_ACK_RDR_CODE INACTIVE_DATE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER FUNDS_XFER_ACK_RDR_CODE QUERY_FORMAT_CODE QUERY_TRANS_PRTCL_CODE GROUP_BY_ORG SYS_EFT_PROFILE_CODE GROUP_BY_LEGAL_ENTITY PAYMENT_SYSTEM_ID GROUP_BY_INT_BANK_ACCOUNT VERIFY_FORMAT_CODE GROUP_BY_SETTLEMENT_CURR VERIFY_TRANS_PRTCL_CODE GROUP_BY_SETTLEMENT_DATE VERIFY_ACK_RDR_CODE LIMIT_BY_AMT_CURR FUNDS_XFER_FORMAT_CODE LIMIT_BY_EXCH_RATE_TYPE FUNDS_XFER_TRANS_PRTCL_CODE LIMIT_BY_TOTAL_AMT SYS_EFT_PROFILE_NAME LIMIT_BY_SETTLEMENT_NUM SETTLE_REQUIRE_VRFY_FLAG AUTOMATIC_PN_SUBMIT_FLAG OVERRIDE_PAYER_DELIVERY_FLAG PAYER_NOTIFICATION_FORMAT PAYER_NOTIFICATION_DEL_METHOD SETTLEMENT_COMPLETE_POINT DESCRIPTION ACCOMPANY_LETTER_FORMAT 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 REQUIRES_PRE_NOTIFICATION SETTLEMENT_FILE_DIRECTORY SETTLEMENT_FILE_EXTENSION SETTLEMENT_FILE_PREFIX BATCH_BOOKING_FLAG ACK_INFER_TYPE LOGICAL_GROUPING_MODE LOCALINSTR SERVICE_LEVEL PURPOSE_CODE EXTERNAL_SETTLEMENT_FLAG

Name

ROW_ID

QUERY_ACK_RDR_CODE

INACTIVE_DATE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

FUNDS_XFER_ACK_RDR_CODE

QUERY_FORMAT_CODE

QUERY_TRANS_PRTCL_CODE

GROUP_BY_ORG

SYS_EFT_PROFILE_CODE

GROUP_BY_LEGAL_ENTITY

PAYMENT_SYSTEM_ID

GROUP_BY_INT_BANK_ACCOUNT

VERIFY_FORMAT_CODE

GROUP_BY_SETTLEMENT_CURR

VERIFY_TRANS_PRTCL_CODE

GROUP_BY_SETTLEMENT_DATE

VERIFY_ACK_RDR_CODE

LIMIT_BY_AMT_CURR

FUNDS_XFER_FORMAT_CODE

LIMIT_BY_EXCH_RATE_TYPE

FUNDS_XFER_TRANS_PRTCL_CODE

LIMIT_BY_TOTAL_AMT

SYS_EFT_PROFILE_NAME

LIMIT_BY_SETTLEMENT_NUM

SETTLE_REQUIRE_VRFY_FLAG

AUTOMATIC_PN_SUBMIT_FLAG

OVERRIDE_PAYER_DELIVERY_FLAG

PAYER_NOTIFICATION_FORMAT

PAYER_NOTIFICATION_DEL_METHOD

SETTLEMENT_COMPLETE_POINT

DESCRIPTION

ACCOMPANY_LETTER_FORMAT

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

REQUIRES_PRE_NOTIFICATION

SETTLEMENT_FILE_DIRECTORY

SETTLEMENT_FILE_EXTENSION

SETTLEMENT_FILE_PREFIX

BATCH_BOOKING_FLAG

ACK_INFER_TYPE

LOGICAL_GROUPING_MODE

LOCALINSTR

SERVICE_LEVEL

PURPOSE_CODE

EXTERNAL_SETTLEMENT_FLAG

Query

SQL_Statement
SELECT B.ROWID ROW_ID, 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.OBJECT_VERSION_NUMBER, B.FUNDS_XFER_ACK_RDR_CODE, B.QUERY_FORMAT_CODE, B.QUERY_TRANS_PRTCL_CODE, B.GROUP_BY_ORG, B.SYS_EFT_PROFILE_CODE, B.GROUP_BY_LEGAL_ENTITY, B.PAYMENT_SYSTEM_ID, B.GROUP_BY_INT_BANK_ACCOUNT, B.VERIFY_FORMAT_CODE, B.GROUP_BY_SETTLEMENT_CURR, B.VERIFY_TRANS_PRTCL_CODE, B.GROUP_BY_SETTLEMENT_DATE, B.VERIFY_ACK_RDR_CODE, B.LIMIT_BY_AMT_CURR, B.FUNDS_XFER_FORMAT_CODE, B.LIMIT_BY_EXCH_RATE_TYPE, B.FUNDS_XFER_TRANS_PRTCL_CODE, B.LIMIT_BY_TOTAL_AMT, T.SYS_EFT_PROFILE_NAME, B.LIMIT_BY_SETTLEMENT_NUM, B.SETTLE_REQUIRE_VRFY_FLAG, 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.ACCOMPANY_LETTER_FORMAT, 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.REQUIRES_PRE_NOTIFICATION, B.SETTLEMENT_FILE_DIRECTORY, B.SETTLEMENT_FILE_EXTENSION, B.SETTLEMENT_FILE_PREFIX, B.BATCH_BOOKING_FLAG, B.ACK_INFER_TYPE, B.LOGICAL_GROUPING_MODE, B.LOCALINSTR, B.SERVICE_LEVEL , B.PURPOSE_CODE, B.EXTERNAL_SETTLEMENT_FLAG FROM IBY_FNDCPT_SYS_EFT_PF_TL T, IBY_FNDCPT_SYS_EFT_PF_B B WHERE B.SYS_EFT_PROFILE_CODE = T.SYS_EFT_PROFILE_CODE AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.ROWID ROW_ID,

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.OBJECT_VERSION_NUMBER,

B.FUNDS_XFER_ACK_RDR_CODE,

B.QUERY_FORMAT_CODE,

B.QUERY_TRANS_PRTCL_CODE,

B.GROUP_BY_ORG,

B.SYS_EFT_PROFILE_CODE,

B.GROUP_BY_LEGAL_ENTITY,

B.PAYMENT_SYSTEM_ID,

B.GROUP_BY_INT_BANK_ACCOUNT,

B.VERIFY_FORMAT_CODE,

B.GROUP_BY_SETTLEMENT_CURR,

B.VERIFY_TRANS_PRTCL_CODE,

B.GROUP_BY_SETTLEMENT_DATE,

B.VERIFY_ACK_RDR_CODE,

B.LIMIT_BY_AMT_CURR,

B.FUNDS_XFER_FORMAT_CODE,

B.LIMIT_BY_EXCH_RATE_TYPE,

B.FUNDS_XFER_TRANS_PRTCL_CODE,

B.LIMIT_BY_TOTAL_AMT,

T.SYS_EFT_PROFILE_NAME,

B.LIMIT_BY_SETTLEMENT_NUM,

B.SETTLE_REQUIRE_VRFY_FLAG,

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.ACCOMPANY_LETTER_FORMAT,

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.REQUIRES_PRE_NOTIFICATION,

B.SETTLEMENT_FILE_DIRECTORY,

B.SETTLEMENT_FILE_EXTENSION,

B.SETTLEMENT_FILE_PREFIX,

B.BATCH_BOOKING_FLAG,

B.ACK_INFER_TYPE,

B.LOGICAL_GROUPING_MODE,

B.LOCALINSTR,

B.SERVICE_LEVEL ,

B.PURPOSE_CODE,

B.EXTERNAL_SETTLEMENT_FLAG

FROM

IBY_FNDCPT_SYS_EFT_PF_TL T,

IBY_FNDCPT_SYS_EFT_PF_B B

WHERE

B.SYS_EFT_PROFILE_CODE = T.SYS_EFT_PROFILE_CODE AND T.LANGUAGE = USERENV('LANG')