[Home] [Help]
View: CSC_CONDITION_EXPRESSION_V
View Text
SELECT OCL.AAE_ID AAE_ID
, DECODE(OCL.CNL_TYPE
, 'GEX'
, 'EXPRESSION'
, 'FEX'
, 'FUNCTION'
, 'CEX'
, 'COUNTER') CONDITION_TYPE
, OCL.CNL_TYPE CNL_TYPE
, OCL.DESCRIPTION DESCRIPTION
, OCL.PDF_ID PDF_ID
, OCL.CNH_ID CNH_ID
, OCL.SORTSEQ SORTSEQ
, OCL.LEFT_PARENTHESIS LEFT_PARENTHESIS
, OAA.NAME LEFT_VALUE
, OCL.RELATIONAL_OPERATOR RELATIONAL_OPERATOR
, OCL.RIGHT_OPERAND RIGHT_OPERAND
, OCL.RIGHT_PARENTHESIS RIGHT_PARENTHESIS
, OCL.LOGICAL_OPERATOR LOGICAL_OPERATOR
FROM OKC_ACTION_ATTRIBUTES_V OAA
, OKC_CONDITION_LINES_V OCL
WHERE OAA.ID = OCL.AAE_ID
Columns
Name |
AAE_ID |
CONDITION_TYPE |
CNL_TYPE |
DESCRIPTION |
PDF_ID |
CNH_ID |
SORTSEQ |
LEFT_PARENTHESIS |
LEFT_VALUE |
RELATIONAL_OPERATOR |
RIGHT_OPERAND |
RIGHT_PARENTHESIS |
LOGICAL_OPERATOR |