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_QUESTION_ORDERS

Line 271: FROM okc_xprt_rule_eval_result_t cond, okc_xprt_question_orders q

267: PROCEDURE populate_doc_questions IS
268:
269: CURSOR c_question is
270: SELECT distinct cond.object_code, q.mandatory_flag display_flag
271: FROM okc_xprt_rule_eval_result_t cond, okc_xprt_question_orders q
272: WHERE cond.doc_id = p_doc_id
273: AND cond.doc_type = p_doc_type
274: AND cond.condition_type = 'QUESTION'
275: AND q.template_id = p_template_id

Line 279: FROM okc_xprt_rule_eval_result_t cond, okc_xprt_question_orders q

275: AND q.template_id = p_template_id
276: AND cond.object_code = q.question_id
277: UNION
278: SELECT distinct cond.object_value_code, q.mandatory_flag display_flag
279: FROM okc_xprt_rule_eval_result_t cond, okc_xprt_question_orders q
280: WHERE cond.doc_id = p_doc_id
281: AND cond.doc_type = p_doc_type
282: AND cond.object_value_type = 'QUESTION'
283: AND q.template_id = p_template_id

Line 287: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_question_orders q

283: AND q.template_id = p_template_id
284: AND cond.object_value_code = q.question_id
285: UNION
286: SELECT distinct to_char(outcome.object_value_id), q.mandatory_flag display_flag
287: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_question_orders q
288: WHERE rultmpl.template_id = p_template_id
289: AND outcome.rule_id = rultmpl.rule_id
290: AND outcome.object_type = 'QUESTION'
291: AND q.template_id = p_template_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 304: FROM okc_xprt_rule_eval_result_t cond, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q

300: AND outcome.object_value_id = q.question_id;
301:
302: CURSOR c_question_and_response is
303: SELECT distinct cond.object_code, resp.response, q.mandatory_flag display_flag
304: FROM okc_xprt_rule_eval_result_t cond, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q
305: WHERE cond.doc_id = p_doc_id
306: AND cond.doc_type = p_doc_type
307: AND cond.condition_type = 'QUESTION'
308: AND resp.doc_id (+) = cond.doc_id

Line 315: FROM okc_xprt_rule_eval_result_t cond, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q

311: AND q.template_id = p_template_id
312: AND cond.object_code = q.question_id
313: UNION
314: SELECT distinct cond.object_value_code, resp.response, q.mandatory_flag display_flag
315: FROM okc_xprt_rule_eval_result_t cond, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q
316: WHERE cond.doc_id = p_doc_id
317: AND cond.doc_type = p_doc_type
318: AND cond.object_value_type = 'QUESTION'
319: AND resp.doc_id (+) = cond.doc_id

Line 326: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q

322: AND q.template_id = p_template_id
323: AND cond.object_value_code = q.question_id
324: UNION
325: SELECT distinct to_char(outcome.object_value_id), resp.response, q.mandatory_flag display_flag
326: FROM okc_xprt_template_rules rultmpl, okc_xprt_rule_outcomes_act_v outcome, okc_xprt_doc_ques_response resp, okc_xprt_question_orders q
327: WHERE rultmpl.template_id = p_template_id
328: AND outcome.rule_id = rultmpl.rule_id
329: AND outcome.object_type = 'QUESTION'
330: AND resp.doc_id (+) = p_doc_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