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

VIEW: APPS.CZ_DATA_SUBTYPES_V

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


CZ_DATA_SUBTYPES_V lists all of the data types with their subtypes


[View Source]

Columns
Name Datatype Length Mandatory Comments
SUPERTYPE_ID NUMBER
Yes
SUPERTYPE_NAME VARCHAR2 (30)
SUBTYPE_NAME VARCHAR2 (30)
SUBTYPE_ID NUMBER
Yes
SUPERTYPE_SIG_TYPE VARCHAR2 (3) Yes
SUPERTYPE_JAVA_DATA_TYPE VARCHAR2 (2000)
SUPERTYPE_DESCRIPTION VARCHAR2 (2000)
SUPERTYPE_SEEDED_FLAG VARCHAR2 (1) Yes
SUBTYPE_SIG_TYPE VARCHAR2 (3) Yes
SUBTYPE_JAVA_DATA_TYPE VARCHAR2 (2000)
SUBTYPE_DESCRIPTION VARCHAR2 (2000)
SUBTYPE_SEEDED_FLAG VARCHAR2 (1) Yes
REL_TYPE_CODE VARCHAR2 (3) Yes
REL_SEEDED_FLAG VARCHAR2 (1) Yes
REL_LAST_UPDATED_BY NUMBER
Yes
REL_LAST_UPDATE_DATE DATE
Yes
REL_CREATION_DATE DATE
Yes
REL_CREATED_BY NUMBER
Yes
REL_LAST_UPDATE_LOGIN NUMBER

Query Text

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


SELECT SUPERTYPE_ID
,      SUPERTYPE_NAME
,      SUBTYPE_NAME
,      SUBTYPE_ID
,      SUPERTYPE_SIG_TYPE
,      SUPERTYPE_JAVA_DATA_TYPE
,      SUPERTYPE_DESCRIPTION
,      SUPERTYPE_SEEDED_FLAG
,      SUBTYPE_SIG_TYPE
,      SUBTYPE_JAVA_DATA_TYPE
,      SUBTYPE_DESCRIPTION
,      SUBTYPE_SEEDED_FLAG
,      REL_TYPE_CODE
,      REL_SEEDED_FLAG
,      REL_LAST_UPDATED_BY
,      REL_LAST_UPDATE_DATE
,      REL_CREATION_DATE
,      REL_CREATED_BY
,      REL_LAST_UPDATE_LOGIN
FROM APPS.CZ_DATA_SUBTYPES_V;

Dependencies

[top of page]

APPS.CZ_DATA_SUBTYPES_V references the following:

SchemaAPPS
SynonymCZ_SIGNATURES
SynonymCZ_TYPE_RELATIONSHIPS

APPS.CZ_DATA_SUBTYPES_V is not referenced by any database object