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_RULES_ENGINE_PVT dependencies on OKC_XPRT_RULE_HDRS_ALL_V

Line 78: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_hdrs_all_v rule

74: PROCEDURE populate_rule_cond_eval_table IS
75:
76: CURSOR c_rules IS
77: SELECT rule.rule_id, rule.condition_expr_code
78: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_hdrs_all_v rule
79: WHERE rultmpl.template_id = p_template_id
80: AND rule.rule_id = rultmpl.rule_id
81: UNION ALL
82: SELECT rule.rule_id, rule.condition_expr_code

Line 83: FROM okc_xprt_rule_hdrs_all_v rule

79: WHERE rultmpl.template_id = p_template_id
80: AND rule.rule_id = rultmpl.rule_id
81: UNION ALL
82: SELECT rule.rule_id, rule.condition_expr_code
83: FROM okc_xprt_rule_hdrs_all_v rule
84: WHERE rule.org_id = (SELECT org_id FROM okc_terms_templates_all WHERE template_id = p_template_id)
85: AND rule.intent = (SELECT intent FROM okc_terms_templates_all WHERE template_id = p_template_id)
86: AND rule.org_wide_flag = 'Y';
87:

Line 90: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_hdrs_all_v rule, okc_xprt_rule_cond_active_v cond

86: AND rule.org_wide_flag = 'Y';
87:
88: CURSOR c_rule_conditions IS
89: SELECT cond.rule_id, cond.rule_condition_id, cond.object_type condition_type, cond.object_code, rule.condition_expr_code, cond.object_value_type, cond.object_value_code, cond.operator
90: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_hdrs_all_v rule, okc_xprt_rule_cond_active_v cond
91: WHERE rultmpl.template_id = p_template_id
92: AND rule.rule_id = rultmpl.rule_id
93: AND cond.rule_id = rule.rule_id
94: UNION ALL

Line 96: FROM okc_xprt_rule_hdrs_all_v rule, okc_xprt_rule_cond_active_v cond

92: AND rule.rule_id = rultmpl.rule_id
93: AND cond.rule_id = rule.rule_id
94: UNION ALL
95: SELECT cond.rule_id, cond.rule_condition_id, cond.object_type condition_type, cond.object_code, rule.condition_expr_code, cond.object_value_type, cond.object_value_code, cond.operator
96: FROM okc_xprt_rule_hdrs_all_v rule, okc_xprt_rule_cond_active_v cond
97: WHERE rule.org_id = (SELECT org_id FROM okc_terms_templates_all WHERE template_id = p_template_id)
98: AND rule.intent = (SELECT intent FROM okc_terms_templates_all WHERE template_id = p_template_id)
99: AND rule.org_wide_flag = 'Y'
100: AND cond.rule_id = rule.rule_id;

Line 295: FROM okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_question_orders q

291: AND q.template_id = p_template_id
292: AND outcome.object_value_id = q.question_id
293: UNION
294: SELECT distinct to_char(outcome.object_value_id), q.mandatory_flag display_flag
295: FROM okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_question_orders q
296: WHERE rul.org_wide_flag = 'Y'
297: AND outcome.rule_id = rul.rule_id
298: AND outcome.object_type = 'QUESTION'
299: AND q.template_id = p_template_id

Line 337: FROM okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q

333: AND q.template_id = p_template_id
334: AND outcome.object_value_id = q.question_id
335: UNION
336: SELECT distinct to_char(outcome.object_value_id), resp.response, q.mandatory_flag display_flag
337: FROM okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q
338: WHERE rul.org_wide_flag = 'Y'
339: AND outcome.rule_id = rul.rule_id
340: AND outcome.object_type = 'QUESTION'
341: AND resp.doc_id (+) = p_doc_id