PSC_OPA_ENTITY_VL

Details

• Schema: FUSION

• Object owner: PSC_TS

• Object type: VIEW

Columns

Name

ENTITY_MODEL_NAME ENTITY_NAME VIEW_OBJECT_ID IS_TOP_LEVEL OPA_HIDDEN SUPPORTS_DYNAMIC_LOAD DYN_LOAD_ADF_VO_ID CAN_BE_INPUT CAN_BE_OUTPUT SUPPORTS_ATTACHMENT PARENT_EO_NAME BELONGS_TO_TECHSTACK CARDINALITY_WITH_PARENT NOTIFICATION_ID OWNER_ID DESCRIPTION OPA_LINK_NAME OPA_NAME CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER SEED_DATA_LOCK DELETED_FLAG MODULE_ID

Query

SQL_Statement

SELECT B.ENTITY_MODEL_NAME, B.ENTITY_NAME, B.VIEW_OBJECT_ID, B.IS_TOP_LEVEL, B.OPA_HIDDEN, B.SUPPORTS_DYNAMIC_LOAD, B.DYN_LOAD_ADF_VO_ID, B.CAN_BE_INPUT, B.CAN_BE_OUTPUT, B.SUPPORTS_ATTACHMENT, B.PARENT_EO_NAME, B.BELONGS_TO_TECHSTACK, B.CARDINALITY_WITH_PARENT, B.NOTIFICATION_ID, B.OWNER_ID, L.DESCRIPTION, L.OPA_LINK_NAME, L.OPA_NAME, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.SEED_DATA_LOCK, B.DELETED_FLAG, B.MODULE_ID FROM PSC_OPA_ENTITY_B B, PSC_OPA_ENTITY_TL L WHERE B.ENTITY_MODEL_NAME = L.ENTITY_MODEL_NAME AND B.ENTITY_NAME = L.ENTITY_NAME AND L.LANGUAGE = USERENV('LANG')