VIEW: CZ.CZ_CONFIG_HDRS#

Source

View Text - Preformatted

select CONFIG_STATUS CONFIG_STATUS, CONFIG_HDR_ID CONFIG_HDR_ID, NAME NAME, CONFIG_REV_NBR CONFIG_REV_NBR, COMPONENT_ID COMPONENT_ID, DESC_TEXT DESC_TEXT, UI_DEF_ID UI_DEF_ID, OPPORTUNITY_HDR_ID OPPORTUNITY_HDR_ID, MODEL_IDENTIFIER MODEL_IDENTIFIER, CONFIG_NOTE CONFIG_NOTE, CONFIG_DATE_CREATED CONFIG_DATE_CREATED, USER_ID_CREATED USER_ID_CREATED, USER_ID_FOR_WHOM_CREATED USER_ID_FOR_WHOM_CREATED, NUMBER_QUOTES_USED_IN NUMBER_QUOTES_USED_IN, USER_NUM01 USER_NUM01, USER_NUM02 USER_NUM02, USER_NUM03 USER_NUM03, USER_NUM04 USER_NUM04, USER_STR01 USER_STR01, USER_STR02 USER_STR02, USER_STR03 USER_STR03, USER_STR04 USER_STR04, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, DELETED_FLAG DELETED_FLAG, EFF_FROM EFF_FROM, EFF_TO EFF_TO, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, SECURITY_MASK SECURITY_MASK, EFF_MASK EFF_MASK, CHECKOUT_USER CHECKOUT_USER, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PERSISTENT_COMPONENT_ID PERSISTENT_COMPONENT_ID, EFFECTIVE_USAGE_ID EFFECTIVE_USAGE_ID, EFFECTIVE_DATE EFFECTIVE_DATE, CONFIG_MODEL_LOOKUP_DATE CONFIG_MODEL_LOOKUP_DATE, CONFIG_DELTA_SPEC CONFIG_DELTA_SPEC, COMPONENT_INSTANCE_TYPE COMPONENT_INSTANCE_TYPE, MODEL_INSTANTIATION_TYPE MODEL_INSTANTIATION_TYPE, BASELINE_REV_NBR BASELINE_REV_NBR, HAS_FAILURES HAS_FAILURES, MODEL_POST_MIGR_CHG_FLAG MODEL_POST_MIGR_CHG_FLAG, TO_BE_DELETED_FLAG TO_BE_DELETED_FLAG, AUTO_COMPLETION_FLAG AUTO_COMPLETION_FLAG, CONFIG_ENGINE_TYPE CONFIG_ENGINE_TYPE from "CZ"."CZ_CONFIG_HDRS"

View Text - HTML Formatted

SELECT CONFIG_STATUS CONFIG_STATUS
, CONFIG_HDR_ID CONFIG_HDR_ID
, NAME NAME
, CONFIG_REV_NBR CONFIG_REV_NBR
, COMPONENT_ID COMPONENT_ID
, DESC_TEXT DESC_TEXT
, UI_DEF_ID UI_DEF_ID
, OPPORTUNITY_HDR_ID OPPORTUNITY_HDR_ID
, MODEL_IDENTIFIER MODEL_IDENTIFIER
, CONFIG_NOTE CONFIG_NOTE
, CONFIG_DATE_CREATED CONFIG_DATE_CREATED
, USER_ID_CREATED USER_ID_CREATED
, USER_ID_FOR_WHOM_CREATED USER_ID_FOR_WHOM_CREATED
, NUMBER_QUOTES_USED_IN NUMBER_QUOTES_USED_IN
, USER_NUM01 USER_NUM01
, USER_NUM02 USER_NUM02
, USER_NUM03 USER_NUM03
, USER_NUM04 USER_NUM04
, USER_STR01 USER_STR01
, USER_STR02 USER_STR02
, USER_STR03 USER_STR03
, USER_STR04 USER_STR04
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DELETED_FLAG DELETED_FLAG
, EFF_FROM EFF_FROM
, EFF_TO EFF_TO
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, SECURITY_MASK SECURITY_MASK
, EFF_MASK EFF_MASK
, CHECKOUT_USER CHECKOUT_USER
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PERSISTENT_COMPONENT_ID PERSISTENT_COMPONENT_ID
, EFFECTIVE_USAGE_ID EFFECTIVE_USAGE_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, CONFIG_MODEL_LOOKUP_DATE CONFIG_MODEL_LOOKUP_DATE
, CONFIG_DELTA_SPEC CONFIG_DELTA_SPEC
, COMPONENT_INSTANCE_TYPE COMPONENT_INSTANCE_TYPE
, MODEL_INSTANTIATION_TYPE MODEL_INSTANTIATION_TYPE
, BASELINE_REV_NBR BASELINE_REV_NBR
, HAS_FAILURES HAS_FAILURES
, MODEL_POST_MIGR_CHG_FLAG MODEL_POST_MIGR_CHG_FLAG
, TO_BE_DELETED_FLAG TO_BE_DELETED_FLAG
, AUTO_COMPLETION_FLAG AUTO_COMPLETION_FLAG
, CONFIG_ENGINE_TYPE CONFIG_ENGINE_TYPE
FROM "CZ"."CZ_CONFIG_HDRS"