IBY_FNDCPT_SYS_DC_PF

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
ROW_ID ONLINE_DEB_FORMAT_CODE ONLINE_DEB_TRANS_PRTCL_CODE ONLINE_DEB_ACK_RDR_CODE SETTLEMENT_REQ_FLAG SETTLEMENT_FORMAT_CODE SETTLEMENT_TRANS_PRTCL_CODE SETTLEMENT_ACK_RDR_CODE QUERY_FORMAT_CODE QUERY_TRANS_PRTCL_CODE QUERY_ACK_RDR_CODE INACTIVE_DATE GROUP_BY_ORG CREATED_BY GROUP_BY_LEGAL_ENTITY CREATION_DATE GROUP_BY_INT_BANK_ACCOUNT LAST_UPDATED_BY GROUP_BY_SETTLEMENT_CURR LAST_UPDATE_DATE GROUP_BY_SETTLEMENT_DATE LAST_UPDATE_LOGIN LIMIT_BY_AMT_CURR OBJECT_VERSION_NUMBER LIMIT_BY_EXCH_RATE_TYPE SYS_DC_PROFILE_CODE LIMIT_BY_TOTAL_AMT LIMIT_BY_SETTLEMENT_NUM PAYMENT_SYSTEM_ID SYS_DC_PROFILE_NAME 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

Name

ROW_ID

ONLINE_DEB_FORMAT_CODE

ONLINE_DEB_TRANS_PRTCL_CODE

ONLINE_DEB_ACK_RDR_CODE

SETTLEMENT_REQ_FLAG

SETTLEMENT_FORMAT_CODE

SETTLEMENT_TRANS_PRTCL_CODE

SETTLEMENT_ACK_RDR_CODE

QUERY_FORMAT_CODE

QUERY_TRANS_PRTCL_CODE

QUERY_ACK_RDR_CODE

INACTIVE_DATE

GROUP_BY_ORG

CREATED_BY

GROUP_BY_LEGAL_ENTITY

CREATION_DATE

GROUP_BY_INT_BANK_ACCOUNT

LAST_UPDATED_BY

GROUP_BY_SETTLEMENT_CURR

LAST_UPDATE_DATE

GROUP_BY_SETTLEMENT_DATE

LAST_UPDATE_LOGIN

LIMIT_BY_AMT_CURR

OBJECT_VERSION_NUMBER

LIMIT_BY_EXCH_RATE_TYPE

SYS_DC_PROFILE_CODE

LIMIT_BY_TOTAL_AMT

LIMIT_BY_SETTLEMENT_NUM

PAYMENT_SYSTEM_ID

SYS_DC_PROFILE_NAME

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.ONLINE_DEB_FORMAT_CODE, B.ONLINE_DEB_TRANS_PRTCL_CODE, B.ONLINE_DEB_ACK_RDR_CODE, B.SETTLEMENT_REQ_FLAG, B.SETTLEMENT_FORMAT_CODE, 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.GROUP_BY_ORG, B.CREATED_BY, B.GROUP_BY_LEGAL_ENTITY, B.CREATION_DATE, B.GROUP_BY_INT_BANK_ACCOUNT, B.LAST_UPDATED_BY, B.GROUP_BY_SETTLEMENT_CURR, B.LAST_UPDATE_DATE, B.GROUP_BY_SETTLEMENT_DATE, B.LAST_UPDATE_LOGIN, B.LIMIT_BY_AMT_CURR, B.OBJECT_VERSION_NUMBER, B.LIMIT_BY_EXCH_RATE_TYPE, B.SYS_DC_PROFILE_CODE, B.LIMIT_BY_TOTAL_AMT, B.LIMIT_BY_SETTLEMENT_NUM, B.PAYMENT_SYSTEM_ID, T.SYS_DC_PROFILE_NAME, 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_DC_PF_TL T, IBY_FNDCPT_SYS_DC_PF_B B WHERE B.SYS_DC_PROFILE_CODE = T.SYS_DC_PROFILE_CODE AND T.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.ROWID ROW_ID,

B.ONLINE_DEB_FORMAT_CODE,

B.ONLINE_DEB_TRANS_PRTCL_CODE,

B.ONLINE_DEB_ACK_RDR_CODE,

B.SETTLEMENT_REQ_FLAG,

B.SETTLEMENT_FORMAT_CODE,

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

B.CREATED_BY,

B.GROUP_BY_LEGAL_ENTITY,

B.CREATION_DATE,

B.GROUP_BY_INT_BANK_ACCOUNT,

B.LAST_UPDATED_BY,

B.GROUP_BY_SETTLEMENT_CURR,

B.LAST_UPDATE_DATE,

B.GROUP_BY_SETTLEMENT_DATE,

B.LAST_UPDATE_LOGIN,

B.LIMIT_BY_AMT_CURR,

B.OBJECT_VERSION_NUMBER,

B.LIMIT_BY_EXCH_RATE_TYPE,

B.SYS_DC_PROFILE_CODE,

B.LIMIT_BY_TOTAL_AMT,

B.LIMIT_BY_SETTLEMENT_NUM,

B.PAYMENT_SYSTEM_ID,

T.SYS_DC_PROFILE_NAME,

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_DC_PF_TL T,

IBY_FNDCPT_SYS_DC_PF_B B

WHERE

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