View: CZ_RULE_EXPRESSION_V

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

View Text

SELECT RUL.RULE_ID
, RUL.NAME AS RULE_NAME
, RUL.RULE_TYPE
, RUL.RULE_FOLDER_TYPE
, DECODE (RUL.RULE_TYPE
, 24
, 'EXPLICIT COMPATIBILITY'
, 30
, 'DESIGN CHART'
, 100
, 'TEMPLATE DEFINITION'
, 200
, 'EXPRESSION RULE'
, 300
, 'JAVA METHOD'
, 400
, 'EVENT BINDING'
, 500
, 'SYSTEM PROPERTY'
, 600
, 'JAVA SYSTEM PROPERTY'
, 700
, 'CAPTION'
, 9999
, 'UNRESOLVED/UNPARSED'
, 'RULE TYPE ' || TO_CHAR (RUL.RULE_TYPE) || ' UNKNOWN' ) AS RULE_TYPE_DESC
, EXPR_NODE_ID
, EXPR_PARENT_ID
, EXPR_TYPE
, DECODE (EXPR_TYPE
, 200
, /* EXPR_OPERATOR */ (SELECT NAME
FROM CZ_RULES
WHERE RULE_ID = EXN.TEMPLATE_ID)
, 201
, /* EXPR_LITERAL */ EXN.DATA_VALUE
, 202
, /* EXPR_FIELD_NAME */ EXN.FIELD_NAME
, 203
, /* EXPR_COLUMN */ 'COLUMN NOT USED'
, 204
, /* EXPR_FEAT_PROP */ 'FIELD NAME: ' || EXN.FIELD_NAME || '
, NODE ID ' || TO_CHAR (EXN.PS_NODE_ID) || '
, PROPERTY ID ' || TO_CHAR (EXN.PROPERTY_ID)
, 205
, /* EXPR_PSNODE */ DECODE (PS_NODE_ID
, NULL
, 'NO PSNODE ID'
, (SELECT 'PSN: ' || TO_CHAR (PS_NODE_ID) || ': ' || NAME
FROM CZ_PS_NODES PSN
WHERE PSN.PS_NODE_ID = EXN.PS_NODE_ID ))
, 206
, /* EXPR_REFNODE */ DECODE (PS_NODE_ID
, NULL
, 'NO PSNODE ID'
, (SELECT 'PSN: ' || TO_CHAR (PS_NODE_ID) || ': ' || NAME
FROM CZ_PS_NODES PSN
WHERE PSN.PS_NODE_ID = EXN.PS_NODE_ID ))
, 207
, /* EXPR_PROP */ (SELECT 'PROP: ' || TO_CHAR (PROPERTY_ID) || ': ' || NAME
FROM CZ_PROPERTIES
WHERE PROPERTY_ID = EXN.PROPERTY_ID)
, 208
, /* EXPR_PUNCT */ DECODE (EXPR_SUBTYPE
, 0
, 'LEFT_PAREN'
, 1
, 'RIGHT_PAREN'
, 2
, 'COMMA'
, 'UNRECOGNIZED PUNCTUATION' )
, 209
, /* EXPR_COMP_COUNT */ DECODE (PS_NODE_ID
, NULL
, 'NO PSNODE ID'
, (SELECT 'PSN: ' || TO_CHAR (PS_NODE_ID) || ': ' || NAME
FROM CZ_PS_NODES PSN
WHERE PSN.PS_NODE_ID = EXN.PS_NODE_ID ))
, 210
, /* EXPR_SYS_PROP */ 'EXPR_SUBTYPE: ' || (SELECT NAME
FROM CZ_RULES
WHERE RULE_ID = EXN.EXPR_SUBTYPE) || ' TEMPLATE_ID: ' || (SELECT NAME
FROM CZ_RULES
WHERE RULE_ID = EXN.TEMPLATE_ID)
, 211
, /* EXPR_CONSTANT */ ''
, 216
, /* EXPR_JAVA_METHOD */ ''
, 217
, /* EXPR_EVENT_ARGUMENT */ ''
, 218
, /* EPR_SYS_ARGUMENT */ ''
, 220
, /* EXPR_JAVA_SYS_PROP */ ''
, 221
, /* EXPR_ARGUMENT */ 'ARG (' || TO_CHAR (EXN.ARGUMENT_INDEX) || ')'
, 222
, /* EXPR_TEMPLATE */ ''
, 223
, /* EXPR_FOR_ALL */ ''
, 224
, /* EXPR_ITERATOR */ ''
, 225
, /* EXPR_WHERE */ ''
, 226
, /* EXPR_COMPATIBLE */ ''
, 227
, /* EXPR_EVENT */ ''
, 'EXPR NODE TYPE NOT RECOGIZED' ) AS EXPRNODE_DESC
, EXTY.VALUE_LABEL AS EXPR_TYPE_DESC
, EXN.DATA_VALUE
, EXN.DATA_NUM_VALUE
, EXN.EXPRESS_ID
FROM CZ_RULES RUL
, CZ_EXPRESSION_NODES EXN
, CZ_EXNEXPRTYPE_LKV EXTY
, CZ_CREATERULEOBJECT_LKV RTY
WHERE RUL.RULE_ID = EXN.RULE_ID
AND EXN.EXPR_TYPE = EXTY.NUMERIC_ID_VALUE(+)
AND EXN.DELETED_FLAG = '0'
AND RTY.NUMERIC_ID_VALUE(+) = RUL.RULE_TYPE ORDER BY RUL.RULE_ID
, EXPR_PARENT_ID
, EXN.SEQ_NBR

Columns