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 425: okc_template_usages tuse,

421: AND bvar.clm_source IS NULL --CLM Changes
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

Line 440: okc_template_usages tuse,

436: UNION
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

Line 686: okc_template_usages tuse,

682: AND var.variable_code IN
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

Line 701: okc_template_usages tuse,

697: UNION
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

Line 1014: FROM okc_template_usages u,

1010: WHERE b.document_type = p_doc_type;
1011:
1012: CURSOR csr_get_org_id (p_doc_type VARCHAR2, p_doc_id NUMBER) IS
1013: SELECT t.org_id org_id
1014: FROM okc_template_usages u,
1015: okc_terms_templates_all t
1016: WHERE u.document_type = p_doc_type
1017: AND u.document_id = p_doc_id
1018: AND u.template_id = t.template_id;

Line 1031: okc_template_usages tuse,

1027: FROM OKC_XPRT_RULE_CONDITIONS
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