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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: CZ.CZ_DEVL_PROJECTS

Object Details

Object Name:	CZ_DEVL_PROJECTS
Object Type:	TABLE
Owner:	CZ
FND Design Data:	CZ.CZ_DEVL_PROJECTS
Subobject Name:
Status:	VALID

CZ_DEVL_PROJECTS stores information about projects. The project is the workspace in Oracle Configurator Developer for building configurations.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_DEVL_PROJECTS_PK

DEVL_PROJECT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_DEVL_PROJECTS_UPK	NORMAL	UNIQUE	APPS_TS_SEED	DEVL_PROJECT_ID
CZ_DEVL_PROJECTS_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	INTL_TEXT_ID
CZ_DEVL_PROJECTS_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	DELETED_FLAG DEVL_PROJECT_ID INTL_TEXT_ID NAME
CZ_DEVL_PROJECTS_N3	NORMAL	NONUNIQUE	APPS_TS_SEED	ORIG_SYS_REF DELETED_FLAG
CZ_DEVL_PROJECTS_N4	NORMAL	NONUNIQUE	APPS_TS_SEED	INVENTORY_ITEM_ID ORGANIZATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DEVL_PROJECT_ID	NUMBER	(15)	Yes	Project unique identifier
INTL_TEXT_ID	NUMBER	(15)		International text identifier
NAME	VARCHAR2	(255)	Yes	Project name
GSL_FILENAME	VARCHAR2	(255)		OBSOLETE
VERSION	NUMBER	(10)		UNUSED
DESC_TEXT	VARCHAR2	(2000)		Project description
ORIG_SYS_REF	VARCHAR2	(255)		BOM explosion original system reference: ORGANIZATION_ID:TOP_ITEM_ID. Used for imported models only
PUBLISHED	DATE			UNUSED
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
DELETED_FLAG	VARCHAR2	(1)	Yes	Flag indicating if record was deleted by the user. If deleted_flag=1 the record will be purged
EFF_FROM	DATE			Not currently used
EFF_TO	DATE			Not currently used
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
SECURITY_MASK	VARCHAR2	(40)		Not currently used
EFF_MASK	VARCHAR2	(40)		Not currently used
CHECKOUT_USER	VARCHAR2	(100)		Not currently used
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
LAST_STRUCT_UPDATE	DATE		Yes	Indicates the last time that the structure of this model/project was modified. Used to determine currency of user interfaces and generated logic
LAST_LOGIC_UPDATE	DATE			Indicates the last time that rule data in this model/project was modified. Used to determine currency of generated logic
PERSISTENT_PROJECT_ID	NUMBER		Yes	Persistent ID (preserved in copies) of this project/model
MODEL_TYPE	VARCHAR2	(1)	Yes	Defines the type of the Configuration Model: S - solution model; P - PTO model; A - ATO model; C - non-BOM model (the default value)
PRODUCT_KEY	VARCHAR2	(255)		Holds product key used for publication of model. Will be populated for all BOM models, is optional for all other models.
ORGANIZATION_ID	NUMBER			Org ID of model's root BOM item, if applicable.
INVENTORY_ITEM_ID	NUMBER			Inventory item ID of model's root BOM item, if applicable.
BOM_CAPTION_RULE_ID	NUMBER			Specify a default display caption rule for bom nodes.
NONBOM_CAPTION_RULE_ID	NUMBER			Specify a default display caption rule for non-bom nodes.
BOM_CAPTION_TEXT_ID	NUMBER			FK to cz_localized_texts.intl_text_id. Referenced text record will hold a text expression for the display name of the model's BOM nodes.
NONBOM_CAPTION_TEXT_ID	NUMBER			FK to cz_localized_texts.intl_text_id. Referenced text record will hold a text expression for the display name of the model's non-BOM nodes.
CHECKOUT_TIME	DATE			Column is used to note the date and time on which the model has been locked.This column is populated with the SYSDATE when the column checkout user is populated with the username at the time of locking a model.
POST_MIGR_CHANGE_FLAG	VARCHAR2	(1)		Migration indicator flag, used to assess the currency of a previously migrated model on the target instance.L or NULL - Local modelN - Migrated model, not changedR - Migrated model, revisedZ - Migrated model, re-migrated from previous target to a new target
MIGRATION_GROUP_ID	NUMBER			Records, for migrated models, the migration group with which it was migrated
MAX_PERSISTENT_REC_ID	NUMBER			If not null, newly generated ps_node_id(s) in the model cannot be less than this value
UI_TIMESTAMP_STRUCT_UPDATE	DATE			High-water mark of CZ_PS_NODES.UI_TIMESTAMP_XXX values for the Model
CONFIG_ENGINE_TYPE	VARCHAR2	(1)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DEVL_PROJECT_ID
,      INTL_TEXT_ID
,      NAME
,      GSL_FILENAME
,      VERSION
,      DESC_TEXT
,      ORIG_SYS_REF
,      PUBLISHED
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELETED_FLAG
,      EFF_FROM
,      EFF_TO
,      CREATED_BY
,      LAST_UPDATED_BY
,      SECURITY_MASK
,      EFF_MASK
,      CHECKOUT_USER
,      LAST_UPDATE_LOGIN
,      LAST_STRUCT_UPDATE
,      LAST_LOGIC_UPDATE
,      PERSISTENT_PROJECT_ID
,      MODEL_TYPE
,      PRODUCT_KEY
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      BOM_CAPTION_RULE_ID
,      NONBOM_CAPTION_RULE_ID
,      BOM_CAPTION_TEXT_ID
,      NONBOM_CAPTION_TEXT_ID
,      CHECKOUT_TIME
,      POST_MIGR_CHANGE_FLAG
,      MIGRATION_GROUP_ID
,      MAX_PERSISTENT_REC_ID
,      UI_TIMESTAMP_STRUCT_UPDATE
,      CONFIG_ENGINE_TYPE
FROM CZ.CZ_DEVL_PROJECTS;

Dependencies

[top of page]

CZ.CZ_DEVL_PROJECTS does not reference any database object

CZ.CZ_DEVL_PROJECTS is referenced by following:

APPS: CZ_DEVL_PROJECTS; CZ_DEVL_PROJECTS_T1; CZ_DEVL_PROJECTS_T2; CZ_DEVL_PROJECTS_T3; CZ_DEVL_PROJECTS_TP1