PSC_COM_SCOPE_CFG

Details

Schema: FUSION
Object owner: PSC_CC
Object type: VIEW

Columns

Name
SCOPE_CONFIG_ID SCOPE_CONFIG_DESCR VO_NAME BO_NAME PARENT_BO_NAME SERVICE_NAME SERVICE_LABEL ALT_KEY_NAME DEFAULT_SCOPE EFFDT_MIGRATION_MODE ROW_IDENTIFIER SEED_DATA_LOCK DELETED_FLAG OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

SCOPE_CONFIG_ID

SCOPE_CONFIG_DESCR

VO_NAME

BO_NAME

PARENT_BO_NAME

SERVICE_NAME

SERVICE_LABEL

ALT_KEY_NAME

DEFAULT_SCOPE

EFFDT_MIGRATION_MODE

ROW_IDENTIFIER

SEED_DATA_LOCK

DELETED_FLAG

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT B.SCOPE_CONFIG_ID, L.SCOPE_CONFIG_DESCR, B.VO_NAME, B.BO_NAME, B.PARENT_BO_NAME, B.SERVICE_NAME, L.SERVICE_LABEL, B.ALT_KEY_NAME, B.DEFAULT_SCOPE, B.EFFDT_MIGRATION_MODE, B.ROW_IDENTIFIER, B.SEED_DATA_LOCK, B.DELETED_FLAG, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM PSC_COM_SCOPE_CFG_B B, PSC_COM_SCOPE_CFG_TL L WHERE B.SCOPE_CONFIG_ID = L.SCOPE_CONFIG_ID AND L.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.SCOPE_CONFIG_ID,

L.SCOPE_CONFIG_DESCR,

B.VO_NAME,

B.BO_NAME,

B.PARENT_BO_NAME,

B.SERVICE_NAME,

L.SERVICE_LABEL,

B.ALT_KEY_NAME,

B.DEFAULT_SCOPE,

B.EFFDT_MIGRATION_MODE,

B.ROW_IDENTIFIER,

B.SEED_DATA_LOCK,

B.DELETED_FLAG,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN

FROM

PSC_COM_SCOPE_CFG_B B,

PSC_COM_SCOPE_CFG_TL L

WHERE

B.SCOPE_CONFIG_ID = L.SCOPE_CONFIG_ID AND L.LANGUAGE = USERENV('LANG')