IBY_FNDCPT_USER_CC_PF

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
ROW_ID LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER BEP_ACCOUNT_ID USER_CC_PROFILE_CODE SYS_CC_PROFILE_CODE INACTIVE_DATE CREATED_BY CREATION_DATE QUERY_TRANS_CONFIG_ID ONLINE_AUTH_TRANS_CONFIG_ID SETTLEMENT_TRANS_CONFIG_ID USER_CC_PROFILE_NAME START_DATE END_DATE

Name

ROW_ID

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

BEP_ACCOUNT_ID

USER_CC_PROFILE_CODE

SYS_CC_PROFILE_CODE

INACTIVE_DATE

CREATED_BY

CREATION_DATE

QUERY_TRANS_CONFIG_ID

ONLINE_AUTH_TRANS_CONFIG_ID

SETTLEMENT_TRANS_CONFIG_ID

USER_CC_PROFILE_NAME

START_DATE

END_DATE

Query

SQL_Statement
SELECT B.ROWID ROW_ID, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.BEP_ACCOUNT_ID, B.USER_CC_PROFILE_CODE, B.SYS_CC_PROFILE_CODE, B.INACTIVE_DATE, B.CREATED_BY, B.CREATION_DATE, B.QUERY_TRANS_CONFIG_ID, B.ONLINE_AUTH_TRANS_CONFIG_ID, B.SETTLEMENT_TRANS_CONFIG_ID, T.USER_CC_PROFILE_NAME, B.START_DATE, B.END_DATE from IBY_FNDCPT_USER_CC_PF_TL T, IBY_FNDCPT_USER_CC_PF_B B where B.USER_CC_PROFILE_CODE = T.USER_CC_PROFILE_CODE and T.LANGUAGE = userenv('LANG')

SQL_Statement

SELECT B.ROWID ROW_ID, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.BEP_ACCOUNT_ID, B.USER_CC_PROFILE_CODE, B.SYS_CC_PROFILE_CODE, B.INACTIVE_DATE, B.CREATED_BY, B.CREATION_DATE, B.QUERY_TRANS_CONFIG_ID, B.ONLINE_AUTH_TRANS_CONFIG_ID, B.SETTLEMENT_TRANS_CONFIG_ID, T.USER_CC_PROFILE_NAME, B.START_DATE, B.END_DATE from IBY_FNDCPT_USER_CC_PF_TL T, IBY_FNDCPT_USER_CC_PF_B B where B.USER_CC_PROFILE_CODE = T.USER_CC_PROFILE_CODE and T.LANGUAGE = userenv('LANG')