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_TEMPLATE_USAGES

Line 199: okc_template_usages tuse,

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

Line 424: okc_template_usages tuse,

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
427: AND tuse.document_type = p_doc_type
428: AND tuse.template_id = trule.template_id

Line 439: okc_template_usages tuse,

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
442: AND tuse.document_type = p_doc_type
443: AND tuse.template_id = trule.template_id

Line 685: okc_template_usages tuse,

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
688: AND tuse.document_type = p_doc_type
689: AND tuse.template_id = trule.template_id

Line 700: okc_template_usages tuse,

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
703: AND tuse.document_type = p_doc_type
704: AND tuse.template_id = trule.template_id

Line 965: FROM okc_template_usages u,

961: WHERE b.document_type = p_doc_type;
962:
963: CURSOR csr_get_org_id (p_doc_type VARCHAR2, p_doc_id NUMBER) IS
964: SELECT t.org_id org_id
965: FROM okc_template_usages u,
966: okc_terms_templates_all t
967: WHERE u.document_type = p_doc_type
968: AND u.document_id = p_doc_id
969: AND u.template_id = t.template_id;