View: OKC_XPRT_RULE_DEPENDENCIES_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_XPRT_RULE_DEPENDENCIES_V

View Text

SELECT DISTINCT RULE_CLAUSE_OUTCOME.RULE_ID
, RULE_CLAUSE_CONDN.CONDITION_ID DEP_CLAUSE_COND_ID
FROM (SELECT RULCOND.RULE_ID
, RULCOND.CONDITION_ID
, CONDVAL.OBJECT_VALUE_CODE CONDVALUE
, RULCOND.DOC_ID
, RULCOND.DOC_TYPE
FROM OKC_XPRT_RULE_EVAL_RESULT_T RULCOND
, OKC_XPRT_RULE_COND_VALS_ACT_V CONDVAL WHERE RULCOND.DOC_ID = OKC_XPRT_RULES_ENGINE_PVT.GETDOCID AND RULCOND.DOC_TYPE = OKC_XPRT_RULES_ENGINE_PVT.GETDOCTYPE AND RULCOND.CONDITION_ID IS NOT NULL AND RULCOND.CONDITION_TYPE = 'CLAUSE' AND CONDVAL.RULE_CONDITION_ID = RULCOND.CONDITION_ID) RULE_CLAUSE_CONDN
, (SELECT RUL.RULE_ID
, OUTCOME.OBJECT_VALUE_ID OUTCOMEVALUE
, RUL.DOC_ID
, RUL.DOC_TYPE
, RUL.RESULT
FROM OKC_XPRT_RULE_EVAL_RESULT_T RUL
, OKC_XPRT_RULE_OUTCOMES_ACT_V OUTCOME WHERE RUL.DOC_ID = OKC_XPRT_RULES_ENGINE_PVT.GETDOCID AND RUL.DOC_TYPE = OKC_XPRT_RULES_ENGINE_PVT.GETDOCTYPE AND RUL.CONDITION_ID IS NULL AND RUL.RULE_ID = OUTCOME.RULE_ID AND OUTCOME.OBJECT_TYPE = 'CLAUSE') RULE_CLAUSE_OUTCOME
WHERE TO_CHAR(RULE_CLAUSE_OUTCOME.OUTCOMEVALUE) = RULE_CLAUSE_CONDN.CONDVALUE
AND RULE_CLAUSE_OUTCOME.DOC_ID = RULE_CLAUSE_CONDN.DOC_ID
AND RULE_CLAUSE_OUTCOME.DOC_TYPE = RULE_CLAUSE_CONDN.DOC_TYPE

Columns