VIEW: CZ.CZ_DEVL_PROJECTS#

Source

View Text - Preformatted

select DEVL_PROJECT_ID DEVL_PROJECT_ID, INTL_TEXT_ID INTL_TEXT_ID, NAME NAME, GSL_FILENAME GSL_FILENAME, VERSION VERSION, DESC_TEXT DESC_TEXT, ORIG_SYS_REF ORIG_SYS_REF, PUBLISHED PUBLISHED, 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, LAST_STRUCT_UPDATE LAST_STRUCT_UPDATE, LAST_LOGIC_UPDATE LAST_LOGIC_UPDATE, PERSISTENT_PROJECT_ID PERSISTENT_PROJECT_ID, MODEL_TYPE MODEL_TYPE, PRODUCT_KEY PRODUCT_KEY, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, BOM_CAPTION_RULE_ID BOM_CAPTION_RULE_ID, NONBOM_CAPTION_RULE_ID NONBOM_CAPTION_RULE_ID, BOM_CAPTION_TEXT_ID BOM_CAPTION_TEXT_ID, NONBOM_CAPTION_TEXT_ID NONBOM_CAPTION_TEXT_ID, CHECKOUT_TIME CHECKOUT_TIME, POST_MIGR_CHANGE_FLAG POST_MIGR_CHANGE_FLAG, MIGRATION_GROUP_ID MIGRATION_GROUP_ID, MAX_PERSISTENT_REC_ID MAX_PERSISTENT_REC_ID, UI_TIMESTAMP_STRUCT_UPDATE UI_TIMESTAMP_STRUCT_UPDATE, CONFIG_ENGINE_TYPE CONFIG_ENGINE_TYPE, IMPORT_ENABLED IMPORT_ENABLED from "CZ"."CZ_DEVL_PROJECTS"

View Text - HTML Formatted

SELECT DEVL_PROJECT_ID DEVL_PROJECT_ID
, INTL_TEXT_ID INTL_TEXT_ID
, NAME NAME
, GSL_FILENAME GSL_FILENAME
, VERSION VERSION
, DESC_TEXT DESC_TEXT
, ORIG_SYS_REF ORIG_SYS_REF
, PUBLISHED PUBLISHED
, 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
, LAST_STRUCT_UPDATE LAST_STRUCT_UPDATE
, LAST_LOGIC_UPDATE LAST_LOGIC_UPDATE
, PERSISTENT_PROJECT_ID PERSISTENT_PROJECT_ID
, MODEL_TYPE MODEL_TYPE
, PRODUCT_KEY PRODUCT_KEY
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, BOM_CAPTION_RULE_ID BOM_CAPTION_RULE_ID
, NONBOM_CAPTION_RULE_ID NONBOM_CAPTION_RULE_ID
, BOM_CAPTION_TEXT_ID BOM_CAPTION_TEXT_ID
, NONBOM_CAPTION_TEXT_ID NONBOM_CAPTION_TEXT_ID
, CHECKOUT_TIME CHECKOUT_TIME
, POST_MIGR_CHANGE_FLAG POST_MIGR_CHANGE_FLAG
, MIGRATION_GROUP_ID MIGRATION_GROUP_ID
, MAX_PERSISTENT_REC_ID MAX_PERSISTENT_REC_ID
, UI_TIMESTAMP_STRUCT_UPDATE UI_TIMESTAMP_STRUCT_UPDATE
, CONFIG_ENGINE_TYPE CONFIG_ENGINE_TYPE
, IMPORT_ENABLED IMPORT_ENABLED
FROM "CZ"."CZ_DEVL_PROJECTS"