[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 |
APPS.CSC_CONDITION_EXPRESSION_V