VIEW: APPS.OKC_XPRT_RULE_DEPENDENCIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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