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