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_TEMPLATE_RULES

Line 200: okc_xprt_template_rules trule

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
203: and tuse.template_id = trule.template_id
204: and trule.rule_id = rhdr.rule_id

Line 426: okc_xprt_template_rules trule

422: AND var.variable_code IN ( SELECT rcon.object_code variable_code -- LHS of Condition from Template rule
423: FROM okc_xprt_rule_hdrs_all rhdr,
424: okc_xprt_rule_conditions rcon,
425: okc_template_usages tuse,
426: okc_xprt_template_rules trule
427: WHERE tuse.document_id = p_doc_id
428: AND tuse.document_type = p_doc_type
429: AND tuse.template_id = trule.template_id
430: AND trule.rule_id = rhdr.rule_id

Line 441: okc_xprt_template_rules trule

437: SELECT rcon.object_value_code variable_code -- RHS of Condition from Template rule
438: FROM okc_xprt_rule_hdrs_all rhdr,
439: okc_xprt_rule_conditions rcon,
440: okc_template_usages tuse,
441: okc_xprt_template_rules trule
442: WHERE tuse.document_id = p_doc_id
443: AND tuse.document_type = p_doc_type
444: AND tuse.template_id = trule.template_id
445: AND trule.rule_id = rhdr.rule_id

Line 687: okc_xprt_template_rules trule

683: (SELECT distinct rcon.object_code variable_code -- LHS of Condition from Template rule
684: FROM okc_xprt_rule_hdrs_all rhdr,
685: okc_xprt_rule_conditions rcon,
686: okc_template_usages tuse,
687: okc_xprt_template_rules trule
688: WHERE tuse.document_id = p_doc_id
689: AND tuse.document_type = p_doc_type
690: AND tuse.template_id = trule.template_id
691: AND trule.rule_id = rhdr.rule_id

Line 702: okc_xprt_template_rules trule

698: SELECT distinct rcon.object_value_code variable_code -- RHS of Condition from Template rule
699: FROM okc_xprt_rule_hdrs_all rhdr,
700: okc_xprt_rule_conditions rcon,
701: okc_template_usages tuse,
702: okc_xprt_template_rules trule
703: WHERE tuse.document_id = p_doc_id
704: AND tuse.document_type = p_doc_type
705: AND tuse.template_id = trule.template_id
706: AND trule.rule_id = rhdr.rule_id

Line 1032: okc_xprt_template_rules trule

1028: WHERE OBJECT_CODE = 'OKC$S_ITEM'
1029: AND rule_id IN (SELECT rhdr.rule_id
1030: FROM okc_xprt_rule_hdrs_all rhdr,
1031: okc_template_usages tuse,
1032: okc_xprt_template_rules trule
1033: WHERE tuse.document_id = p_doc_id
1034: AND tuse.document_type = p_doc_type
1035: AND tuse.template_id = trule.template_id
1036: AND trule.rule_id = rhdr.rule_id