eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_XPRT_RULE_EVAL_RESULT_T

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 7125: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul

7121: AND nvl(ver.provision_yn, '*') = 'N';
7122:
7123: CURSOR c_expert_deviations IS
7124: SELECT null line_number, rul.rule_id
7125: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul
7126: WHERE rultmp.doc_id = p_document_id
7127: AND rultmp.doc_type = p_document_type
7128: AND rultmp.condition_id IS NULL
7129: 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'

Line 11005: DELETE okc_xprt_rule_eval_result_t WHERE doc_id = p_document_id and doc_type = p_document_type;

11001: WHERE document_id = p_document_id
11002: AND document_type = p_document_type;
11003:
11004: --purging the temp tables used for evaluating contract expert rules engine
11005: DELETE okc_xprt_rule_eval_result_t WHERE doc_id = p_document_id and doc_type = p_document_type;
11006: DELETE okc_xprt_rule_eval_condval_t WHERE doc_id = p_document_id and doc_type = p_document_type;
11007:
11008: --
11009: -- Display appropriate message on page depending on whether articles where inserted