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]

VIEW: APPS.CZ_SRC_MODEL_PUBLICATIONS_V

Object Details

Object Name:	CZ_SRC_MODEL_PUBLICATIONS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CZ.CZ_SRC_MODEL_PUBLICATIONS_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PUBLICATION_ID	NUMBER	(9)	Yes	Identifies a publication for this record
OBJECT_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"
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
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
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
PAGE_LAYOUT	VARCHAR2	(2000)
CONTAINER	VARCHAR2	(2000)
DISABLED_FLAG	VARCHAR2	(1)	Yes	Date on which the publication (export) process finished.

Query Text

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


SELECT PUBLICATION_ID
,      OBJECT_ID
,      SERVER_ID
,      ORGANIZATION_ID
,      TOP_ITEM_ID
,      PRODUCT_KEY
,      PUBLICATION_MODE
,      UI_DEF_ID
,      UI_STYLE
,      APPLICABLE_FROM
,      APPLICABLE_UNTIL
,      EXPORT_STATUS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      PAGE_LAYOUT
,      CONTAINER
,      DISABLED_FLAG
FROM APPS.CZ_SRC_MODEL_PUBLICATIONS_V;

Dependencies

[top of page]

APPS.CZ_SRC_MODEL_PUBLICATIONS_V references the following:

APPS: CZ_MODEL_PUBLICATIONS

APPS.CZ_SRC_MODEL_PUBLICATIONS_V is not referenced by any database object