View: CSC_CONDITION_LINE_DETAILS_V

Product:	CSC - Customer Care
Description:	Each Condition Line expresses a Boolean condition. Multiple Condition Lines may be and'd or or'd together and nested using parenthesis.
Implementation/DBA Data:	APPS.CSC_CONDITION_LINE_DETAILS_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
, DECODE(CNL_TYPE
, 'GEX'
, OAA.NAME
, 'CEX'
, CSC_CORE_UTILS_PVT.GET_COUNTER_NAME(NVL(OCL.LEFT_CTR_MASTER_ID
, OCL.LEFT_COUNTER_ID))
, 'FEX'
, DECODE(OPD.PACKAGE_NAME
, NULL
, OPD.PROCEDURE_NAME
, OPD.PACKAGE_NAME||'.'||OPD.PROCEDURE_NAME) ) LEFT_VALUE
, DECODE(CNL_TYPE
, 'FEX'
, NULL
, OCL.RELATIONAL_OPERATOR) RELATIONAL_OPERATOR
, DECODE(CNL_TYPE
, 'GEX'
, OCL.RIGHT_OPERAND
, 'CEX'
, CSC_CORE_UTILS_PVT.GET_COUNTER_NAME(NVL(TO_NUMBER(OCL.RIGHT_OPERAND)
, NVL(OCL.RIGHT_CTR_MASTER_ID
, OCL.RIGHT_COUNTER_ID))) ) RIGHT_OPERAND
, OCL.RIGHT_PARENTHESIS RIGHT_PARENTHESIS
, OCL.LOGICAL_OPERATOR LOGICAL_OPERATOR
FROM OKC_ACTION_ATTRIBUTES_V OAA
, OKC_CONDITION_LINES_V OCL
, OKC_PROCESS_DEFS_V OPD
WHERE OAA.ID(+) = OCL.AAE_ID
AND OCL.PDF_ID = OPD.ID(+)

Columns