DBA Data[Home] [Help]

VIEW: APPS.IGWFV_GRNT_PRPSL_ROUT_RULE_LNE

Source

View Text - Preformatted

SELECT RULES_ALL.RULE_NAME, RULE_LINES.EXPRESSION_SEQUENCE_NUMBER, RULE_LINES.EXPRESSION_TYPE, RULE_LINES.LBRACKETS, RULE_LINES.LVALUE, RULE_LINES.OPERATOR, RULE_LINES.RVALUE, RULE_LINES.RVALUE_ID, RULE_LINES.RBRACKETS, RULE_LINES.LOGICAL_OPERATOR, RULE_LINES.RULE_ID, RULE_LINES.EXPRESSION_ID, RULE_LINES.LAST_UPDATE_DATE, RULE_LINES.LAST_UPDATED_BY, RULE_LINES.CREATION_DATE, RULE_LINES.CREATED_BY from IGW_BUSINESS_RULE_LINES RULE_LINES , IGW_BUSINESS_RULES_ALL RULES_ALL WHERE RULES_ALL.RULE_ID = RULE_LINES.RULE_ID with read only
View Text - HTML Formatted

SELECT RULES_ALL.RULE_NAME
, RULE_LINES.EXPRESSION_SEQUENCE_NUMBER
, RULE_LINES.EXPRESSION_TYPE
, RULE_LINES.LBRACKETS
, RULE_LINES.LVALUE
, RULE_LINES.OPERATOR
, RULE_LINES.RVALUE
, RULE_LINES.RVALUE_ID
, RULE_LINES.RBRACKETS
, RULE_LINES.LOGICAL_OPERATOR
, RULE_LINES.RULE_ID
, RULE_LINES.EXPRESSION_ID
, RULE_LINES.LAST_UPDATE_DATE
, RULE_LINES.LAST_UPDATED_BY
, RULE_LINES.CREATION_DATE
, RULE_LINES.CREATED_BY
FROM IGW_BUSINESS_RULE_LINES RULE_LINES
, IGW_BUSINESS_RULES_ALL RULES_ALL
WHERE RULES_ALL.RULE_ID = RULE_LINES.RULE_ID WITH READ ONLY