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_SIGNATURE_ARGUMENTS

Object Details

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

CZ_SIGNATURE_ARGUMENTS records the formal parameters required for using a Rule Template, Event, or Java Method via the Signature that those objects implement.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Primary Key: CZ_SIGNATURE_ARGUMENTS_PK

ARGUMENT_SIGNATURE_ID
ARGUMENT_INDEX

Indexes

Index	Type	Uniqueness	Tablespace	Column
CZ_SIGNATURE_ARGUMENTS_PK	NORMAL	UNIQUE	APPS_TS_SEED	ARGUMENT_SIGNATURE_ID ARGUMENT_INDEX

Columns

Name	Datatype	Length	Mandatory	Comments
ARGUMENT_SIGNATURE_ID	NUMBER		Yes	PK. The signature that this argument participates in
ARGUMENT_INDEX	NUMBER		Yes	PK. The index of this argument in the signature
ARGUMENT_NAME	VARCHAR2	(30)	Yes	Name of the argument to be used in the template text as a substitution. Must be unique across all arguments of the same signature.
DATA_TYPE	NUMBER		Yes	Argument data type:
DATATYPE_SIGNATURE_ID	NUMBER			In case of DATA_SIGNATURE this points to the signature, templates of which are allowed to fill in the argument
ARGUMENT_LIST_FLAG	VARCHAR2	(1)	Yes	Modifier to the argument type:
DELETED_FLAG	VARCHAR2	(1)	Yes	Standard flag; '0' indicates the record is active, '1' means deleted. Other values are reserved
MUTABLE_FLAG	VARCHAR2	(1)	Yes	Denormalization
JAVA_DATA_TYPE	VARCHAR2	(2000)		If case of DATA_JAVA, this is the name of the java argument type
LAST_UPDATE_LOGIN	NUMBER			Records the login ID under which this record was last updated
CREATION_DATE	DATE		Yes	Standard field recording the date this record was created
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
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

Query Text

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


SELECT ARGUMENT_SIGNATURE_ID
,      ARGUMENT_INDEX
,      ARGUMENT_NAME
,      DATA_TYPE
,      DATATYPE_SIGNATURE_ID
,      ARGUMENT_LIST_FLAG
,      DELETED_FLAG
,      MUTABLE_FLAG
,      JAVA_DATA_TYPE
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATED_BY
,      LAST_UPDATED_BY
,      SEEDED_FLAG
,      COLLECTION_FLAG
FROM CZ.CZ_SIGNATURE_ARGUMENTS;

Dependencies

[top of page]

CZ.CZ_SIGNATURE_ARGUMENTS does not reference any database object

CZ.CZ_SIGNATURE_ARGUMENTS is referenced by following:

APPS: CZ_SIGNATURE_ARGUMENTS; CZ_SIGNATURE_ARGUMENTS_T1