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.

[Home] [Help]

APPS.OKC_XPRT_XRULE_VALUES_PVT dependencies on OKC_XPRT_RULE_CONDITIONS

Line 423: okc_xprt_rule_conditions rcon,

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

Line 438: okc_xprt_rule_conditions rcon,

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

Line 453: okc_xprt_rule_conditions rcon

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
457: AND rhdr.org_wide_flag = 'Y'

Line 465: okc_xprt_rule_conditions rcon

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
469: AND rhdr.org_wide_flag = 'Y'

Line 574: okc_xprt_rule_conditions c,

570: CURSOR csr_constants (p_intent VARCHAR2) IS
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

Line 684: okc_xprt_rule_conditions rcon,

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

Line 699: okc_xprt_rule_conditions rcon,

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

Line 714: okc_xprt_rule_conditions rcon

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
718: AND rhdr.org_wide_flag = 'Y'

Line 726: okc_xprt_rule_conditions rcon

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
730: AND rhdr.org_wide_flag = 'Y'