VIEW: APPS.CZ_DATA_SUBTYPES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'