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_TGT_MODEL_PUBLICATIONS_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PUBLICATION_ID	NUMBER	(9)	Yes
MODEL_ID	NUMBER	(15)
SERVER_ID	NUMBER	(9)	Yes
ORGANIZATION_ID	NUMBER	(9)
TOP_ITEM_ID	NUMBER	(9)
PRODUCT_KEY	VARCHAR2	(255)
PUBLICATION_MODE	VARCHAR2	(1)	Yes
UI_DEF_ID	NUMBER	(9)
UI_STYLE	VARCHAR2	(3)	Yes
APPLICABLE_FROM	DATE		Yes
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)		stores Page layout for the published UI
CONTAINER	VARCHAR2	(2000)		stores container jsp for the published UI
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
,      MODEL_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_TGT_MODEL_PUBLICATIONS_V;

Dependencies

[top of page]

APPS.CZ_TGT_MODEL_PUBLICATIONS_V references the following:

APPS: CZ_MODEL_PUBLICATIONS

APPS.CZ_TGT_MODEL_PUBLICATIONS_V is not referenced by any database object