DBA Data[Home] [Help]

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 425: okc_xprt_template_rules trule

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
429: AND trule.rule_id = rhdr.rule_id

Line 440: okc_xprt_template_rules trule

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
444: AND trule.rule_id = rhdr.rule_id

Line 686: okc_xprt_template_rules trule

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
690: AND trule.rule_id = rhdr.rule_id

Line 701: okc_xprt_template_rules trule

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
705: AND trule.rule_id = rhdr.rule_id