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_SIGNATURES

Object Details

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

CZ_SIGNATURES is the principal data type repository for Configurator. Signatures describe the various types of model nodes, the structure of rule templates, and the elements in user interfaces, among other entities.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_SIGNATURES_PK

SIGNATURE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_SIGNATURES_PK	NORMAL	UNIQUE	APPS_TS_SEED	SIGNATURE_ID
CZ_SIGNATURES_U1	NORMAL	UNIQUE	APPS_TS_SEED	DELETED_FLAG SIGNATURE_TYPE SIGNATURE_ID
CZ_SIGNATURES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	DATA_TYPE SIGNATURE_TYPE DELETED_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
SIGNATURE_ID	NUMBER		Yes	PK
DATA_TYPE	NUMBER		Yes	Return data type: 1 = DATA_LOGIC 2 = DATA_NUMERIC 3 = DATA_TEXT
TOP_LEVEL_CONSTRAINT_FLAG	VARCHAR2	(1)		pecifies if the templates having this signature are only allowed as top-level constraints: 1=top-level only 0=nested only
ARGUMENT_COUNT	NUMBER		Yes	Specifies the number of arguments for this signature. Used for validation of number of records in CZ_SIGNATURE_ARGUMENTS
ORIG_SYS_REF	VARCHAR2	(255)		by which an imported record can be identified in its source database
DELETED_FLAG	VARCHAR2	(1)	Yes	Other values are reserved
SIGNATURE_TYPE	VARCHAR2	(3)	Yes	Allowable values are 'TPL' (template),'PDT' (data type?), 'EVT' (event)
JAVA_DATA_TYPE	VARCHAR2	(2000)		In case of DATA_JAVA, this is the name of the java return type
EVENT_BINDING_SCOPE	NUMBER			When signature_type is EVT, this bitfield defines the allowed execution scopes for the event type:
NAME	VARCHAR2	(30)		Name of the signature
DESCRIPTION	VARCHAR2	(2000)
LAST_UPDATE_LOGIN	NUMBER			Records the login ID under which this record was last updated
LAST_UPDATE_DATE	DATE		Yes	Standard field recording the date/time this record was last updated
CREATED_BY	NUMBER	(15)	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	(15)	Yes	Standard field recording the ID of the user that last updated this record
SEEDED_FLAG	VARCHAR2	(1)	Yes	'1' indicates this is a seeded expr node
COLLECTION_FLAG	VARCHAR2	(1)		Denormalization
MUTABLE_FLAG	VARCHAR2	(1)	Yes	Denormalization
CONFIG_ENGINE_TYPE	VARCHAR2	(1)

Query Text

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


SELECT SIGNATURE_ID
,      DATA_TYPE
,      TOP_LEVEL_CONSTRAINT_FLAG
,      ARGUMENT_COUNT
,      ORIG_SYS_REF
,      DELETED_FLAG
,      SIGNATURE_TYPE
,      JAVA_DATA_TYPE
,      EVENT_BINDING_SCOPE
,      NAME
,      DESCRIPTION
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      SEEDED_FLAG
,      COLLECTION_FLAG
,      MUTABLE_FLAG
,      CONFIG_ENGINE_TYPE
FROM CZ.CZ_SIGNATURES;

Dependencies

[top of page]

CZ.CZ_SIGNATURES does not reference any database object

CZ.CZ_SIGNATURES is referenced by following:

APPS: CZ_SIGNATURES; CZ_SIGNATURES_T1