View: CZ_COMPAT_TEMPL_SIGS_V

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

View Text

SELECT PARSIG.SIGNATURE_ID AS PARENT_SIGNATURE_ID
, PARSIG.SIGNATURE_TYPE AS PARENT_SIGNATURE_TYPE
, PARSIG.DATA_TYPE AS PARENT_DATA_TYPE
, PARSIG.MUTABLE_FLAG AS PARENT_MUTABLE_FLAG
, PARSIG.COLLECTION_FLAG AS PARENT_COLLECTION_FLAG
, PARSIG.NAME AS PARENT_SIGNATURE_NAME
, PARSIG.DESCRIPTION AS PARENT_SIGNATURE_DESC
, SUBSIG.SIGNATURE_ID AS SUBTEMPL_SIGNATURE_ID
, SUBSIG.SIGNATURE_TYPE AS SUBTEMPL_SIGNATURE_TYPE
, SUBSIG.DATA_TYPE AS SUBTEMPL_DATA_TYPE
, SUBSIG.MUTABLE_FLAG AS SUBTEMPL_MUTABLE_FLAG
, SUBSIG.COLLECTION_FLAG AS SUBTEMPL_COLLECTION_FLAG
, SUBSIG.NAME AS SUBTEMPL_SIGNATURE_NAME
, SUBSIG.DESCRIPTION AS SUBTEMPL_SIGNATURE_DESC
, PARSIG.ARGUMENT_COUNT
FROM CZ_SIGNATURES PARSIG
, CZ_SIGNATURES SUBSIG
, CZ_TYPE_RELATIONSHIPS RETCNV
WHERE PARSIG.DELETED_FLAG = '0'
AND PARSIG.SIGNATURE_TYPE IN ('TPL'
, 'JME')
AND PARSIG.SIGNATURE_TYPE = SUBSIG.SIGNATURE_TYPE
AND PARSIG.ARGUMENT_COUNT = SUBSIG.ARGUMENT_COUNT
AND PARSIG.MUTABLE_FLAG = SUBSIG.MUTABLE_FLAG
AND PARSIG.COLLECTION_FLAG >= SUBSIG.COLLECTION_FLAG
AND SUBSIG.DELETED_FLAG = '0'
AND PARSIG.DATA_TYPE = RETCNV.SUBJECT_TYPE
AND SUBSIG.DATA_TYPE = RETCNV.OBJECT_TYPE
AND RETCNV.REL_TYPE_CODE = 'CNV'
AND RETCNV.DELETED_FLAG = '0'
AND PARSIG.ARGUMENT_COUNT = ( SELECT COUNT (*) AS MATCHING_ARGS
FROM CZ_SIGNATURE_ARGUMENTS PARARG
, CZ_SIGNATURE_ARGUMENTS SUBARG
, CZ_TYPE_RELATIONSHIPS ARGCNV
WHERE ARGCNV.REL_TYPE_CODE = 'CNV'
AND ARGCNV.DELETED_FLAG = '0'
AND PARARG.DELETED_FLAG = '0'
AND PARARG.ARGUMENT_SIGNATURE_ID = PARSIG.SIGNATURE_ID
AND PARARG.ARGUMENT_INDEX = SUBARG.ARGUMENT_INDEX
AND SUBARG.ARGUMENT_SIGNATURE_ID = SUBSIG.SIGNATURE_ID
AND PARARG.MUTABLE_FLAG = SUBARG.MUTABLE_FLAG
AND PARARG.COLLECTION_FLAG <= SUBARG.COLLECTION_FLAG
AND PARARG.DATA_TYPE = ARGCNV.SUBJECT_TYPE
AND SUBARG.DATA_TYPE = ARGCNV.OBJECT_TYPE
AND SUBARG.DELETED_FLAG = '0' )

Columns