APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_XPRT_RULE_OUTCOMES_ACT_V

Line 3230: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome

3226: -- that are in the OKC rules engine
3227:
3228: CURSOR c_expert_articles_from_ruleng IS
3229: SELECT distinct outcome.object_value_id
3230: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome
3231: WHERE rultmp.doc_id = p_document_id
3232: AND rultmp.doc_type = p_document_type
3233: AND rultmp.condition_id IS NULL
3234: AND nvl(rultmp.result, '*' ) = 'Y'

Line 3296: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome

3292: AND NVL(kart.SUMMARY_AMEND_OPERATION_CODE, '?') <> 'DELETED'
3293: --AND (nvl(nvl(kart.ref_article_id, kart.sav_sae_id), -1) not in (
3294: AND (kart.orig_article_id NOT IN (
3295: SELECT distinct outcome.object_value_id
3296: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome
3297: WHERE rultmp.doc_id = p_document_id
3298: AND rultmp.doc_type = p_document_type
3299: AND rultmp.condition_id IS NULL
3300: AND nvl(rultmp.result, '*' ) = 'Y'

Line 3850: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome

3846: --cursors used for new OKC rules engine
3847:
3848: CURSOR c_all_expert_articles IS
3849: SELECT distinct outcome.object_value_id
3850: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome
3851: WHERE rultmp.doc_id = p_document_id
3852: AND rultmp.doc_type = p_document_type
3853: AND rultmp.condition_id IS NULL
3854: AND nvl(rultmp.result, '*' ) = 'Y'

Line 3862: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_article_versions ver

3858: AND outcome.object_type = 'CLAUSE';
3859:
3860: CURSOR c_expert_nonprovision_articles IS
3861: SELECT distinct outcome.object_value_id
3862: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_article_versions ver
3863: WHERE rultmp.doc_id = p_document_id
3864: AND rultmp.doc_type = p_document_type
3865: AND rultmp.condition_id IS NULL
3866: AND nvl(rultmp.result, '*' ) = 'Y'

Line 7098: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome

7094: --cursors used for new OKC rules engine
7095:
7096: CURSOR c_all_expert_articles IS
7097: SELECT distinct outcome.object_value_id
7098: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome
7099: WHERE rultmp.doc_id = p_document_id
7100: AND rultmp.doc_type = p_document_type
7101: AND rultmp.condition_id IS NULL
7102: AND nvl(rultmp.result, '*' ) = 'Y'

Line 7110: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_article_versions ver

7106: AND outcome.object_type = 'CLAUSE';
7107:
7108: CURSOR c_expert_nonprovision_articles IS
7109: SELECT distinct outcome.object_value_id
7110: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_article_versions ver
7111: WHERE rultmp.doc_id = p_document_id
7112: AND rultmp.doc_type = p_document_type
7113: AND rultmp.condition_id IS NULL
7114: AND nvl(rultmp.result, '*' ) = 'Y'

Line 10883: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome

10879: -- Currsor to Select the Expert Articles
10880:
10881: CURSOR c_get_expert_articles IS
10882: SELECT distinct outcome.object_value_id
10883: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome
10884: WHERE rultmp.doc_id = p_document_id
10885: AND rultmp.doc_type = p_document_type
10886: AND rultmp.condition_id IS NULL
10887: AND nvl(rultmp.result, '*' ) = 'Y'