eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: CZ.CZ_MODEL_PUBLICATIONS#

Source

View Text - Preformatted


select PUBLICATION_ID PUBLICATION_ID, MODEL_ID MODEL_ID, SERVER_ID SERVER_ID, ORGANIZATION_ID ORGANIZATION_ID, TOP_ITEM_ID TOP_ITEM_ID, PRODUCT_KEY PRODUCT_KEY, PUBLICATION_MODE PUBLICATION_MODE, UI_DEF_ID UI_DEF_ID, UI_STYLE UI_STYLE, APPLICABLE_FROM APPLICABLE_FROM, APPLICABLE_UNTIL APPLICABLE_UNTIL, EXPORT_STATUS EXPORT_STATUS, DELETED_FLAG DELETED_FLAG, MODEL_LAST_STRUCT_UPDATE MODEL_LAST_STRUCT_UPDATE, MODEL_LAST_LOGIC_UPDATE MODEL_LAST_LOGIC_UPDATE, MODEL_LAST_UPDATED MODEL_LAST_UPDATED, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, USER_STR01 USER_STR01, USER_STR02 USER_STR02, USER_STR03 USER_STR03, USER_STR04 USER_STR04, USER_NUM01 USER_NUM01, USER_NUM02 USER_NUM02, USER_NUM03 USER_NUM03, USER_NUM04 USER_NUM04, MODEL_PERSISTENT_ID MODEL_PERSISTENT_ID, SOURCE_TARGET_FLAG SOURCE_TARGET_FLAG, REMOTE_PUBLICATION_ID REMOTE_PUBLICATION_ID, SOURCE_MODEL_ID SOURCE_MODEL_ID, SOURCE_UI_DEF_ID SOURCE_UI_DEF_ID, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, PAGE_LAYOUT PAGE_LAYOUT, CONTAINER CONTAINER, CHECKOUT_USER CHECKOUT_USER, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, DISABLED_FLAG DISABLED_FLAG, PUBLISHED PUBLISHED, CONVERTED_TARGET_FLAG CONVERTED_TARGET_FLAG, MIGRATION_GROUP_ID MIGRATION_GROUP_ID, MIGRATION_TGT_FOLDER MIGRATION_TGT_FOLDER, MIGRATION_TGT_PATH MIGRATION_TGT_PATH, CONC_PROG_REQ_ID CONC_PROG_REQ_ID from "CZ"."CZ_MODEL_PUBLICATIONS"

View Text - HTML Formatted

SELECT PUBLICATION_ID PUBLICATION_ID
, MODEL_ID MODEL_ID
, SERVER_ID SERVER_ID
, ORGANIZATION_ID ORGANIZATION_ID
, TOP_ITEM_ID TOP_ITEM_ID
, PRODUCT_KEY PRODUCT_KEY
, PUBLICATION_MODE PUBLICATION_MODE
, UI_DEF_ID UI_DEF_ID
, UI_STYLE UI_STYLE
, APPLICABLE_FROM APPLICABLE_FROM
, APPLICABLE_UNTIL APPLICABLE_UNTIL
, EXPORT_STATUS EXPORT_STATUS
, DELETED_FLAG DELETED_FLAG
, MODEL_LAST_STRUCT_UPDATE MODEL_LAST_STRUCT_UPDATE
, MODEL_LAST_LOGIC_UPDATE MODEL_LAST_LOGIC_UPDATE
, MODEL_LAST_UPDATED MODEL_LAST_UPDATED
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, USER_STR01 USER_STR01
, USER_STR02 USER_STR02
, USER_STR03 USER_STR03
, USER_STR04 USER_STR04
, USER_NUM01 USER_NUM01
, USER_NUM02 USER_NUM02
, USER_NUM03 USER_NUM03
, USER_NUM04 USER_NUM04
, MODEL_PERSISTENT_ID MODEL_PERSISTENT_ID
, SOURCE_TARGET_FLAG SOURCE_TARGET_FLAG
, REMOTE_PUBLICATION_ID REMOTE_PUBLICATION_ID
, SOURCE_MODEL_ID SOURCE_MODEL_ID
, SOURCE_UI_DEF_ID SOURCE_UI_DEF_ID
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, PAGE_LAYOUT PAGE_LAYOUT
, CONTAINER CONTAINER
, CHECKOUT_USER CHECKOUT_USER
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, DISABLED_FLAG DISABLED_FLAG
, PUBLISHED PUBLISHED
, CONVERTED_TARGET_FLAG CONVERTED_TARGET_FLAG
, MIGRATION_GROUP_ID MIGRATION_GROUP_ID
, MIGRATION_TGT_FOLDER MIGRATION_TGT_FOLDER
, MIGRATION_TGT_PATH MIGRATION_TGT_PATH
, CONC_PROG_REQ_ID CONC_PROG_REQ_ID
FROM "CZ"."CZ_MODEL_PUBLICATIONS"