View: CZ_RULETEMPLS_BYLABEL_V

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

View Text

SELECT CSIG.PARENT_SIGNATURE_ID
, RUL.NAME AS RULE_NAME
, RUL.RULE_TYPE
, CSIG.ARGUMENT_COUNT
, DECODE (MAX (RULE_ID)
, MIN (RULE_ID)
, DECODE (RULE_TYPE
, 100
, 200
, 500
, 210
, 501
, 220 )
, DECODE (RULE_TYPE
, 100
, 229
, 500
, 228
, 501
, 229 ) ) AS USE_EXPR_TYPE
, DECODE (MAX (RULE_ID)
, MIN (RUL.RULE_ID)
, MAX (RULE_ID)
, TO_NUMBER (NULL)) AS AVAIL_RULE_ID
, DECODE (MAX (CSIG.SUBTEMPL_SIGNATURE_ID)
, MIN (CSIG.SUBTEMPL_SIGNATURE_ID)
, MAX (CSIG.SUBTEMPL_SIGNATURE_ID)
, TO_NUMBER (NULL) ) AS AVAIL_SUBTEMPL_SIGNATURE_ID
, DECODE (MAX (RUL.TEMPLATE_TOKEN)
, MIN (RUL.TEMPLATE_TOKEN)
, MAX (RUL.TEMPLATE_TOKEN)
, TO_NUMBER (NULL) ) AS AVAIL_TEMPLATE_TOKEN
, DECODE (CSIG.ARGUMENT_COUNT
, 0
, 1
, SIGN (COUNT (CARG.ARGUMENT_INDEX))) AS HAS_NONBOOLEAN_ARGUMENTS
, MAX (RUL.DESC_TEXT) AS AVAIL_DESCRIPTION
, MIN (RUL.SEQ_NBR) AS SEQ_NBR
FROM CZ_SIGNATURE_ARGUMENTS CARG
, CZ_RULES RUL
, CZ_COMPAT_TEMPL_SIGS_V CSIG
WHERE RUL.SIGNATURE_ID = CSIG.SUBTEMPL_SIGNATURE_ID
AND CSIG.SUBTEMPL_SIGNATURE_ID = CARG.ARGUMENT_SIGNATURE_ID (+)
AND '0' = CARG.DELETED_FLAG (+)
AND 3 != CARG.DATA_TYPE(+)
AND RUL.RULE_TYPE IN (100
, 500
, 501)
AND RUL.DELETED_FLAG = '0' GROUP BY RUL.NAME
, CSIG.PARENT_SIGNATURE_ID
, RUL.RULE_TYPE
, CSIG.ARGUMENT_COUNT

Columns