[Home] [Help]
View: CSC_CONDITION_FUNCTION_V
View Text
SELECT OCL.ID ID
, OCL.SORTSEQ SORTSEQ
, OCL.LEFT_PARENTHESIS LEFT_PARENTHESIS
, OCL.PDF_ID PDF_ID
, OCL.RIGHT_PARENTHESIS RIGHT_PARENTHESIS
, OCL.LOGICAL_OPERATOR LOGICAL_OPERATOR
, OCL.AAE_ID AAE_ID
, OCL.CNH_ID CNH_ID
, OCL.CNL_TYPE CNL_TYPE
, DECODE(OPD.PACKAGE_NAME
, NULL
, OPD.PROCEDURE_NAME
, OPD.PACKAGE_NAME||'.'||OPD.PROCEDURE_NAME ) NAME
FROM OKC_PROCESS_DEFS_V OPD
, OKC_CONDITION_LINES_V OCL
WHERE OCL.PDF_ID = OPD.ID
AND OCL.CNL_TYPE = 'FEX'
Columns
Name |
ID |
SORTSEQ |
LEFT_PARENTHESIS |
PDF_ID |
RIGHT_PARENTHESIS |
LOGICAL_OPERATOR |
AAE_ID |
CNH_ID |
CNL_TYPE |
NAME |