IBY_FNDCPT_USER_EFT_PF

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
ROW_ID LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER BEP_ACCOUNT_ID VERIFY_TRANS_CONFIG_ID USER_EFT_PROFILE_CODE SYS_EFT_PROFILE_CODE CREATION_DATE LAST_UPDATED_BY INACTIVE_DATE CREATED_BY FUNDS_XFER_TRANS_CONFIG_ID QUERY_TRANS_CONFIG_ID USER_EFT_PROFILE_NAME START_DATE END_DATE

Name

ROW_ID

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

BEP_ACCOUNT_ID

VERIFY_TRANS_CONFIG_ID

USER_EFT_PROFILE_CODE

SYS_EFT_PROFILE_CODE

CREATION_DATE

LAST_UPDATED_BY

INACTIVE_DATE

CREATED_BY

FUNDS_XFER_TRANS_CONFIG_ID

QUERY_TRANS_CONFIG_ID

USER_EFT_PROFILE_NAME

START_DATE

END_DATE

Query

SQL_Statement
SELECT B.ROWID ROW_ID, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.BEP_ACCOUNT_ID, B.VERIFY_TRANS_CONFIG_ID, B.USER_EFT_PROFILE_CODE, B.SYS_EFT_PROFILE_CODE, B.CREATION_DATE, B.LAST_UPDATED_BY, B.INACTIVE_DATE, B.CREATED_BY, B.FUNDS_XFER_TRANS_CONFIG_ID, B.QUERY_TRANS_CONFIG_ID, T.USER_EFT_PROFILE_NAME, B.START_DATE, B.END_DATE from IBY_FNDCPT_USER_EFT_PF_TL T, IBY_FNDCPT_USER_EFT_PF_B B where B.USER_EFT_PROFILE_CODE = T.USER_EFT_PROFILE_CODE and T.LANGUAGE = userenv('LANG')

SQL_Statement

SELECT B.ROWID ROW_ID, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.BEP_ACCOUNT_ID, B.VERIFY_TRANS_CONFIG_ID, B.USER_EFT_PROFILE_CODE, B.SYS_EFT_PROFILE_CODE, B.CREATION_DATE, B.LAST_UPDATED_BY, B.INACTIVE_DATE, B.CREATED_BY, B.FUNDS_XFER_TRANS_CONFIG_ID, B.QUERY_TRANS_CONFIG_ID, T.USER_EFT_PROFILE_NAME, B.START_DATE, B.END_DATE from IBY_FNDCPT_USER_EFT_PF_TL T, IBY_FNDCPT_USER_EFT_PF_B B where B.USER_EFT_PROFILE_CODE = T.USER_EFT_PROFILE_CODE and T.LANGUAGE = userenv('LANG')