1. Tables and Views for Financials
  2. IBY_BEP_ACCT_OPT_NAME_VL

IBY_BEP_ACCT_OPT_NAME_VL

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: VIEW

Columns

Name

ROW_ID

BEPID

ACCOUNT_OPTION_CODE

ACCOUNT_OPTION_DATATYPE

SECURED_FLAG

UNIQUE_PER_BATCH_FLAG

TOKEN_PROFILE_FLAG

TOPOLOGY_MGR_CODE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

DISPLAY_ORDER

ACCOUNT_OPTION_NAME

Query

SQL_Statement

SELECT

B.ROWID ROW_ID,

B.BEPID,

B.ACCOUNT_OPTION_CODE,

B.ACCOUNT_OPTION_DATATYPE,

B.SECURED_FLAG,

B.UNIQUE_PER_BATCH_FLAG,

B.TOKEN_PROFILE_FLAG,

B.TOPOLOGY_MGR_CODE,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER,

B.DISPLAY_ORDER,

T.ACCOUNT_OPTION_NAME

FROM

IBY_BEP_ACCT_OPT_NAME_TL T,

IBY_BEP_ACCT_OPT_NAME_B B

WHERE

B.BEPID = T.BEPID

AND B.ACCOUNT_OPTION_CODE = T.ACCOUNT_OPTION_CODE

AND T.LANGUAGE = userenv('LANG')