eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CZ_RULE_EXPRESSION_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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