View: CZ_DATA_SUBTYPES_V

Product:	CZ - Configurator
Description:
Implementation/DBA Data:	APPS.CZ_DATA_SUBTYPES_V

View Text

SELECT SUBJECT_TYPE AS SUPERTYPE_ID
, SUBSIG.NAME AS SUPERTYPE_NAME
, OBJSIG.NAME AS SUBTYPE_NAME
, OBJECT_TYPE AS SUBTYPE_ID
, SUBSIG.SIGNATURE_TYPE AS SUPERTYPE_SIG_TYPE
, SUBSIG.JAVA_DATA_TYPE AS SUPERTYPE_JAVA_DATA_TYPE
, SUBSIG.DESCRIPTION AS SUPERTYPE_DESCRIPTION
, SUBSIG.SEEDED_FLAG AS SUPERTYPE_SEEDED_FLAG
, OBJSIG.SIGNATURE_TYPE AS SUBTYPE_SIG_TYPE
, OBJSIG.JAVA_DATA_TYPE AS SUBTYPE_JAVA_DATA_TYPE
, OBJSIG.DESCRIPTION AS SUBTYPE_DESCRIPTION
, OBJSIG.SEEDED_FLAG AS SUBTYPE_SEEDED_FLAG
, REL_TYPE_CODE
, TYPREL.SEEDED_FLAG AS REL_SEEDED_FLAG
, TYPREL.LAST_UPDATED_BY AS REL_LAST_UPDATED_BY
, TYPREL.LAST_UPDATE_DATE AS REL_LAST_UPDATE_DATE
, TYPREL.CREATION_DATE AS REL_CREATION_DATE
, TYPREL.CREATED_BY AS REL_CREATED_BY
, TYPREL.LAST_UPDATE_LOGIN AS REL_LAST_UPDATE_LOGIN
FROM CZ_TYPE_RELATIONSHIPS TYPREL
, CZ_SIGNATURES SUBSIG
, CZ_SIGNATURES OBJSIG
WHERE TYPREL.REL_TYPE_CODE = 'CNV'
AND SUBJECT_TYPE = SUBSIG.SIGNATURE_ID
AND SUBSIG.DELETED_FLAG = '0'

Columns