[Home] [Help] [Dependency Information]
Object Name: | CZ_MODEL_PUBLICATIONS |
---|---|
Object Type: | TABLE |
Owner: | CZ |
FND Design Data: | CZ.CZ_MODEL_PUBLICATIONS |
Subobject Name: | |
Status: | VALID |
This table is used to record model publications. Each top model that is published is described in a single record along with applicability and other parameters. Child models included by reference are not recorded in this table.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CZ_MODEL_PUBLICATIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_SEED | SOURCE_TARGET_FLAG |
CZ_MODEL_PUBLICATIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED |
MODEL_ID
SERVER_ID MODEL_LAST_STRUCT_UPDATE EXPORT_STATUS SOURCE_TARGET_FLAG DELETED_FLAG |
CZ_MODEL_PUBLICATIONS_U1 | NORMAL | NONUNIQUE | APPS_TS_SEED |
PUBLICATION_ID
DELETED_FLAG OBJECT_TYPE OBJECT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PUBLICATION_ID | NUMBER | (9) | Yes | Identifies a publication for this record |
MODEL_ID | NUMBER | (15) | Associates this record with a configurator Model/Project | |
SERVER_ID | NUMBER | (9) | Yes | Associates this record with a database-server instance |
ORGANIZATION_ID | NUMBER | (9) | Organization ID for this published model if imported from BOM | |
TOP_ITEM_ID | NUMBER | (9) | Bill top item identifier for this model if applicable | |
PRODUCT_KEY | VARCHAR2 | (255) | String value used as an identifier for the published model/project. Generally not used for imported models, which are referenced through organization ID and inventory item ID | |
PUBLICATION_MODE | VARCHAR2 | (1) | Yes | Flag indicating the mode of publication. DEFAULT'T' indicates "Testing"; 'P' indicates "Production"; 'M' indicates migration record |
UI_DEF_ID | NUMBER | (9) | Identifies a User Interface for this record | |
UI_STYLE | VARCHAR2 | (3) | Yes | Specifies the style of the published user interface (DENORMALIZATION): 0 - Components Tree (default); 1 - Navigation Tree; 2 - Wizard; 3 - Model Tree; -1 - Migration Record |
APPLICABLE_FROM | DATE | Yes | Indicates the configuration date beginning on which this publication becomes applicable. | |
APPLICABLE_UNTIL | DATE | Yes | Indicates the date at which this publication is no longer applicable (EXCLUSIVE). | |
EXPORT_STATUS | VARCHAR2 | (3) | Export status as from the CZ_XFR_MODEL_EXPORTS table for this model (dependent on child models' export status). 'PEN' - export is pending; 'PRC' - export is being processed; 'OK' - export has completed; 'PUP' - update is pending; 'ERR' - export has failed; 'OBS' - indicate that the target server has been changed to a source server and the publication records for that server is obsolete | |
DELETED_FLAG | VARCHAR2 | (1) | Yes | Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved |
MODEL_LAST_STRUCT_UPDATE | DATE | Copied from CZ_DEVL_PROJECTS at publication export. Indicates the last time that the structure of this model/project was modified. Used to determine currency of user interfaces and generated logic | ||
MODEL_LAST_LOGIC_UPDATE | DATE | Copied from CZ_DEVL_PROJECTS at publication export. Indicates the last time that rule data in this model/project was modified. Used to determine currency of a publication. | ||
MODEL_LAST_UPDATED | DATE | Copied from CZ_DEVL_PROJECTS at publication export. Last time model/project record itself was updated. | ||
CREATED_BY | NUMBER | (9) | Yes | Standard field recording the ID of the user that created this record |
CREATION_DATE | DATE | Yes | Standard field recording the date this record was created | |
LAST_UPDATED_BY | NUMBER | (9) | Yes | Standard field recording the ID of the user that last updated this record |
LAST_UPDATE_DATE | DATE | Yes | Standard field recording the date/time this record was last updated | |
USER_STR01 | VARCHAR2 | (255) | Standard extension field (string) | |
USER_STR02 | VARCHAR2 | (255) | Standard extension field (string) | |
USER_STR03 | VARCHAR2 | (255) | Standard extension field (string) | |
USER_STR04 | VARCHAR2 | (255) | Standard extension field (string) | |
USER_NUM01 | NUMBER | (9) | Standard extension field (numeric) | |
USER_NUM02 | NUMBER | (9) | Standard extension field (numeric) | |
USER_NUM03 | NUMBER | (9) | Standard extension field (numeric) | |
USER_NUM04 | NUMBER | (9) | Standard extension field (numeric) | |
MODEL_PERSISTENT_ID | NUMBER | Copied from CZ_DEVL_PROJECTS at publication export. Persistent ID of the model published. | ||
SOURCE_TARGET_FLAG | VARCHAR2 | (1) | Yes | S - indicates this is a 'source' publication 'owned' by Developer; T - indicates this is a 'target' publication created by procsand used by Runtime; 'M' for source migration record and 'R' indicating target migration record |
REMOTE_PUBLICATION_ID | NUMBER | (9) | [15f] Holds the ID of this same publication on a remote server. | |
SOURCE_MODEL_ID | NUMBER | In target publication records, will contain the source devl_project_id. | ||
SOURCE_UI_DEF_ID | NUMBER | In target publication records, will contain the source devl_project_id. | ||
OBJECT_TYPE | VARCHAR2 | (3) | Yes | stores type of publication |
OBJECT_ID | NUMBER | Yes | key to CZ_UI_TEMPLATES or CZ_DEVL_PROJECTS | |
PAGE_LAYOUT | VARCHAR2 | (2000) | stores Page layout for the published UI | |
CONTAINER | VARCHAR2 | (2000) | stores container jsp for the published UI | |
CHECKOUT_USER | VARCHAR2 | (40) | It is used for locking a publication | |
LAST_UPDATE_LOGIN | NUMBER | Records the login ID under which this record was last updated | ||
DISABLED_FLAG | VARCHAR2 | (1) | Yes | Date on which the publication (export) process finished. |
PUBLISHED | DATE | Date on which the publication (export) process finished. | ||
CONVERTED_TARGET_FLAG | VARCHAR2 | (1) | Marks a publication as a remote publication to an instance that has been converted to Development. Value of '1' indicates that the target server for this publication has been converted to Development. | |
MIGRATION_GROUP_ID | NUMBER | All the entities in a given migration request will have the same migration_group_id. But each of the object in a migration request would have their own entry. | ||
MIGRATION_TGT_FOLDER | NUMBER | Stores the migration target folders specified as a parameter to the migration request | ||
MIGRATION_TGT_PATH | VARCHAR2 | (4000) | The full remote Repository path to the target folder | |
CONC_PROG_REQ_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT PUBLICATION_ID
, MODEL_ID
, SERVER_ID
, ORGANIZATION_ID
, TOP_ITEM_ID
, PRODUCT_KEY
, PUBLICATION_MODE
, UI_DEF_ID
, UI_STYLE
, APPLICABLE_FROM
, APPLICABLE_UNTIL
, EXPORT_STATUS
, DELETED_FLAG
, MODEL_LAST_STRUCT_UPDATE
, MODEL_LAST_LOGIC_UPDATE
, MODEL_LAST_UPDATED
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, USER_STR01
, USER_STR02
, USER_STR03
, USER_STR04
, USER_NUM01
, USER_NUM02
, USER_NUM03
, USER_NUM04
, MODEL_PERSISTENT_ID
, SOURCE_TARGET_FLAG
, REMOTE_PUBLICATION_ID
, SOURCE_MODEL_ID
, SOURCE_UI_DEF_ID
, OBJECT_TYPE
, OBJECT_ID
, PAGE_LAYOUT
, CONTAINER
, CHECKOUT_USER
, LAST_UPDATE_LOGIN
, DISABLED_FLAG
, PUBLISHED
, CONVERTED_TARGET_FLAG
, MIGRATION_GROUP_ID
, MIGRATION_TGT_FOLDER
, MIGRATION_TGT_PATH
, CONC_PROG_REQ_ID
FROM CZ.CZ_MODEL_PUBLICATIONS;
CZ.CZ_MODEL_PUBLICATIONS does not reference any database object
CZ.CZ_MODEL_PUBLICATIONS is referenced by following:
|
|
|