VIEW: APPS.CZ_RULETEMPLS_BYLABEL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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