DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CZ_COMPAT_TEMPL_SIGS_V

Object Details
Object Name: CZ_COMPAT_TEMPL_SIGS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCZ.CZ_COMPAT_TEMPL_SIGS_V
Subobject Name:
Status: VALID


CZ_COMPAT_TEMPL_SIGS_V lists each template signature with the set of those template signatures that are directly-compatible with it in terms of argument types


[View Source]

Columns
Name Datatype Length Mandatory Comments
PARENT_SIGNATURE_ID NUMBER
Yes
PARENT_SIGNATURE_TYPE VARCHAR2 (3) Yes
PARENT_DATA_TYPE NUMBER
Yes
PARENT_MUTABLE_FLAG VARCHAR2 (1) Yes
PARENT_COLLECTION_FLAG VARCHAR2 (1)
PARENT_SIGNATURE_NAME VARCHAR2 (30)
PARENT_SIGNATURE_DESC VARCHAR2 (2000)
SUBTEMPL_SIGNATURE_ID NUMBER
Yes
SUBTEMPL_SIGNATURE_TYPE VARCHAR2 (3) Yes
SUBTEMPL_DATA_TYPE NUMBER
Yes
SUBTEMPL_MUTABLE_FLAG VARCHAR2 (1) Yes
SUBTEMPL_COLLECTION_FLAG VARCHAR2 (1)
SUBTEMPL_SIGNATURE_NAME VARCHAR2 (30)
SUBTEMPL_SIGNATURE_DESC VARCHAR2 (2000)
ARGUMENT_COUNT NUMBER
Yes
Query Text

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


SELECT PARENT_SIGNATURE_ID
,      PARENT_SIGNATURE_TYPE
,      PARENT_DATA_TYPE
,      PARENT_MUTABLE_FLAG
,      PARENT_COLLECTION_FLAG
,      PARENT_SIGNATURE_NAME
,      PARENT_SIGNATURE_DESC
,      SUBTEMPL_SIGNATURE_ID
,      SUBTEMPL_SIGNATURE_TYPE
,      SUBTEMPL_DATA_TYPE
,      SUBTEMPL_MUTABLE_FLAG
,      SUBTEMPL_COLLECTION_FLAG
,      SUBTEMPL_SIGNATURE_NAME
,      SUBTEMPL_SIGNATURE_DESC
,      ARGUMENT_COUNT
FROM APPS.CZ_COMPAT_TEMPL_SIGS_V;

Dependencies

[top of page]

APPS.CZ_COMPAT_TEMPL_SIGS_V references the following:

SchemaAPPS
SynonymCZ_SIGNATURES
SynonymCZ_SIGNATURE_ARGUMENTS
SynonymCZ_TYPE_RELATIONSHIPS
APPS.CZ_COMPAT_TEMPL_SIGS_V is referenced by following:

SchemaAPPS
ViewCZ_RULETEMPLS_BYLABEL_V