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_XRULE_VALUES_PVT dependencies on OKC_XPRT_RULE_HDRS_ALL

Line 191: from okc_xprt_rule_hdrs_all

187: IS
188:
189: cursor org_line_rule_csr (p_org_id number) is
190: select 'X'
191: from okc_xprt_rule_hdrs_all
192: where org_wide_flag = 'Y'
193: and line_level_flag = 'Y'
194: and org_id = p_org_id;
195:

Line 198: from okc_xprt_rule_hdrs_all rhdr,

194: and org_id = p_org_id;
195:
196: cursor template_line_rule_csr (p_doc_id number, p_doc_type varchar2) is
197: select 'X'
198: from okc_xprt_rule_hdrs_all rhdr,
199: okc_template_usages tuse,
200: okc_xprt_template_rules trule
201: where tuse.document_id = p_doc_id
202: and tuse.document_type = p_doc_type

Line 422: FROM okc_xprt_rule_hdrs_all rhdr,

418: AND art.document_type = p_doc_type -- Added for Bug 4728565
419: AND var.variable_code = bvar.variable_code
420: AND bvar.variable_source = 'M'
421: AND var.variable_code IN ( SELECT rcon.object_code variable_code -- LHS of Condition from Template rule
422: FROM okc_xprt_rule_hdrs_all rhdr,
423: okc_xprt_rule_conditions rcon,
424: okc_template_usages tuse,
425: okc_xprt_template_rules trule
426: WHERE tuse.document_id = p_doc_id

Line 437: FROM okc_xprt_rule_hdrs_all rhdr,

433: AND SUBSTR(rcon.object_code,1,3) <> 'OKC'
434: GROUP BY rcon.object_code
435: UNION
436: SELECT rcon.object_value_code variable_code -- RHS of Condition from Template rule
437: FROM okc_xprt_rule_hdrs_all rhdr,
438: okc_xprt_rule_conditions rcon,
439: okc_template_usages tuse,
440: okc_xprt_template_rules trule
441: WHERE tuse.document_id = p_doc_id

Line 452: FROM okc_xprt_rule_hdrs_all rhdr,

448: AND SUBSTR(rcon.object_value_code,1,3) <> 'OKC'
449: GROUP BY rcon.object_value_code
450: UNION
451: SELECT rcon.object_code variable_code -- LHS of Condition from Global Rule
452: FROM okc_xprt_rule_hdrs_all rhdr,
453: okc_xprt_rule_conditions rcon
454: WHERE rhdr.rule_id = rcon.rule_id
455: AND rhdr.org_id = p_org_id
456: AND rhdr.intent = p_intent

Line 464: FROM okc_xprt_rule_hdrs_all rhdr,

460: AND SUBSTR(rcon.object_code,1,3) <> 'OKC'
461: GROUP BY rcon.object_code
462: UNION
463: SELECT rcon.object_value_code variable_code -- RHS of Condition from Global Rule
464: FROM okc_xprt_rule_hdrs_all rhdr,
465: okc_xprt_rule_conditions rcon
466: WHERE rhdr.rule_id = rcon.rule_id
467: AND rhdr.org_id = p_org_id
468: AND rhdr.intent = p_intent

Line 575: okc_xprt_rule_hdrs_all r,

571: SELECT 'CONSTANT$' || v.object_value_code constant_id, --
572: q.default_value
573: FROM okc_xprt_rule_cond_vals v,
574: okc_xprt_rule_conditions c,
575: okc_xprt_rule_hdrs_all r,
576: okc_xprt_questions_b q
577: WHERE v.rule_condition_id = c.rule_condition_id
578: AND c.rule_id = r.rule_id
579: AND to_char(q.question_id) = v.object_value_code

Line 683: FROM okc_xprt_rule_hdrs_all rhdr,

679: FROM okc_bus_variables_b var
680: WHERE var.variable_source = 'P'
681: AND var.variable_code IN
682: (SELECT distinct rcon.object_code variable_code -- LHS of Condition from Template rule
683: FROM okc_xprt_rule_hdrs_all rhdr,
684: okc_xprt_rule_conditions rcon,
685: okc_template_usages tuse,
686: okc_xprt_template_rules trule
687: WHERE tuse.document_id = p_doc_id

Line 698: FROM okc_xprt_rule_hdrs_all rhdr,

694: AND SUBSTR(rcon.object_code,1,3) <> 'OKC'
695: GROUP BY rcon.object_code
696: UNION
697: SELECT distinct rcon.object_value_code variable_code -- RHS of Condition from Template rule
698: FROM okc_xprt_rule_hdrs_all rhdr,
699: okc_xprt_rule_conditions rcon,
700: okc_template_usages tuse,
701: okc_xprt_template_rules trule
702: WHERE tuse.document_id = p_doc_id

Line 713: FROM okc_xprt_rule_hdrs_all rhdr,

709: AND SUBSTR(rcon.object_value_code,1,3) <> 'OKC'
710: GROUP BY rcon.object_value_code
711: UNION
712: SELECT distinct rcon.object_code variable_code -- LHS of Condition from Global Rule
713: FROM okc_xprt_rule_hdrs_all rhdr,
714: okc_xprt_rule_conditions rcon
715: WHERE rhdr.rule_id = rcon.rule_id
716: AND rhdr.org_id = p_org_id
717: AND rhdr.intent = p_intent

Line 725: FROM okc_xprt_rule_hdrs_all rhdr,

721: AND SUBSTR(rcon.object_code,1,3) <> 'OKC'
722: GROUP BY rcon.object_code
723: UNION
724: SELECT distinct rcon.object_value_code variable_code -- RHS of Condition from Global Rule
725: FROM okc_xprt_rule_hdrs_all rhdr,
726: okc_xprt_rule_conditions rcon
727: WHERE rhdr.rule_id = rcon.rule_id
728: AND rhdr.org_id = p_org_id
729: AND rhdr.intent = p_intent