VIEW: APPS.CZ_COMPAT_TEMPL_SIGS_V

Source

View Text - Preformatted

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' )

View Text - HTML Formatted

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' )