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_SIGNATURE_SYSPROPS_V

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Mandatory
DETAILED_SIGNATURE_ID	NUMBER		Yes
DETAILED_SIGNATURE_TYPE	VARCHAR2	(3)	Yes
DETAILED_SIGNATURE_NAME	VARCHAR2	(30)
SYS_PROP_NAME	VARCHAR2	(255)
SYS_PROP_RETTYPE_ID	NUMBER
SYS_PROP_RETCOLL_FLAG	VARCHAR2	(1)
SYS_PROP_RETMUTABLE_FLAG	VARCHAR2	(1)	Yes
SYS_PROP_RETTYPE_NAME	VARCHAR2	(30)
PROPATTACH_SIG_NAME	VARCHAR2	(30)
PROPATTACH_SIGNATURE_ID	NUMBER		Yes
SYS_PROP_RULE_ID	NUMBER	(9)	Yes
SYS_PROP_SIGNATURE_ID	NUMBER
SYS_PROP_SIGNATURE_NAME	VARCHAR2	(30)
RULE_TYPE_CODE	VARCHAR2	(255)	Yes
RULE_TYPE	NUMBER	(9)	Yes
RULE_TYPE_LABEL	VARCHAR2	(255)
SYS_PROP_SEQ_NBR	NUMBER	(9)	Yes
SYS_PROP_TOKEN	VARCHAR2	(30)
ALL_NUMERIC_SIGS_FLAG	VARCHAR2	(1)
INSTANCE_SET_FLAG	VARCHAR2	(1)
P_MODEL_ID	NUMBER	(15)	Yes

Query Text

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


SELECT DETAILED_SIGNATURE_ID
,      DETAILED_SIGNATURE_TYPE
,      DETAILED_SIGNATURE_NAME
,      SYS_PROP_NAME
,      SYS_PROP_RETTYPE_ID
,      SYS_PROP_RETCOLL_FLAG
,      SYS_PROP_RETMUTABLE_FLAG
,      SYS_PROP_RETTYPE_NAME
,      PROPATTACH_SIG_NAME
,      PROPATTACH_SIGNATURE_ID
,      SYS_PROP_RULE_ID
,      SYS_PROP_SIGNATURE_ID
,      SYS_PROP_SIGNATURE_NAME
,      RULE_TYPE_CODE
,      RULE_TYPE
,      RULE_TYPE_LABEL
,      SYS_PROP_SEQ_NBR
,      SYS_PROP_TOKEN
,      ALL_NUMERIC_SIGS_FLAG
,      INSTANCE_SET_FLAG
,      P_MODEL_ID
FROM APPS.CZ_SIGNATURE_SYSPROPS_V;

Dependencies

[top of page]

APPS.CZ_SIGNATURE_SYSPROPS_V references the following:

APPS: CZ_DEVL_PROJECTS; CZ_MODEL_PROP_ENGTYP_COMPAT_V; CZ_RULES; CZ_RULETYPECODES_LKV; CZ_SIGNATURES; CZ_TYPE_RELATIONSHIPS; FND_PROFILE - show dependent code

APPS.CZ_SIGNATURE_SYSPROPS_V is referenced by following:

APPS: CZ_COMMON_CHILDND_SYSPROPS_V; CZ_NODE_ALL_PROPERTIES_V