MOW_ASGN_OBJECTS_VL

Details

• Schema: FUSION

• Object owner: MOW

• Object type: VIEW

Columns

Name

ASGN_OBJECT_GUID REF_ROW_GUID RECORD_STATUS OWNER_MODULE PARENT_OBJECT_GUID PARENT_GUID1 PARENT_GUID2 PARENT_GUID3 PARENT_GUID4 PARENT_GUID5 ASGN_OBJECT_CODE DISPLAY_NAME WORK_OBJECT_FLAG CANDIDATE_OBJECT_FLAG WORK_OBJECT_IDENTIFIER_ATTR PRIMARY_KEY_ATTR1 PRIMARY_KEY_ATTR2 PRIMARY_KEY_ATTR3 APP_MODULE_NAME APP_MODULE_CONFIG_NAME VIEW_OBJECT_DEFN FACT_ALIAS VIEW_OBJECT_INSTANCE VIEW_CRITERIA_NAME CAND_OBJECT_REFRESH_INTERVAL CAND_OBJECT_INITIAL_POOL_SIZE CAND_OBJECT_MAX_POOL_SIZE DESC_TEXT INACTIVE_FLAG CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT B.ASGN_OBJECT_GUID, B.REF_ROW_GUID, B.RECORD_STATUS, B.OWNER_MODULE, B.PARENT_OBJECT_GUID, B.PARENT_GUID1, B.PARENT_GUID2, B.PARENT_GUID3, B.PARENT_GUID4, B.PARENT_GUID5, B.ASGN_OBJECT_CODE, T.DISPLAY_NAME, B.WORK_OBJECT_FLAG, B.CANDIDATE_OBJECT_FLAG, B.WORK_OBJECT_IDENTIFIER_ATTR, B.PRIMARY_KEY_ATTR1, B.PRIMARY_KEY_ATTR2, B.PRIMARY_KEY_ATTR3, B.APP_MODULE_NAME, B.APP_MODULE_CONFIG_NAME, B.VIEW_OBJECT_DEFN, B.FACT_ALIAS, B.VIEW_OBJECT_INSTANCE, B.VIEW_CRITERIA_NAME, B.CAND_OBJECT_REFRESH_INTERVAL, B.CAND_OBJECT_INITIAL_POOL_SIZE, B.CAND_OBJECT_MAX_POOL_SIZE, T.DESC_TEXT, B.INACTIVE_FLAG, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER FROM MOW_ASGN_OBJECTS_B B, MOW_ASGN_OBJECTS_TL T WHERE B. ASGN_OBJECT_GUID = T. ASGN_OBJECT_GUID AND T.LANGUAGE = USERENV ('LANG')