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_HDRS_ALL

Line 191: from okc_xprt_rule_hdrs_all

187: IS
188:
189: cursor org_line_rule_csr (p_org_id number) is
190: select 'X'
191: from okc_xprt_rule_hdrs_all
192: where org_wide_flag = 'Y'
193: and line_level_flag = 'Y'
194: and org_id = p_org_id;
195:

Line 198: from okc_xprt_rule_hdrs_all rhdr,

194: and org_id = p_org_id;
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

Line 423: FROM okc_xprt_rule_hdrs_all rhdr,

419: AND var.variable_code = bvar.variable_code
420: AND bvar.variable_source = 'M'
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

Line 438: FROM okc_xprt_rule_hdrs_all rhdr,

434: AND SUBSTR(rcon.object_code,1,3) <> 'OKC'
435: GROUP BY rcon.object_code
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

Line 453: FROM okc_xprt_rule_hdrs_all rhdr,

449: AND SUBSTR(rcon.object_value_code,1,3) <> 'OKC'
450: GROUP BY rcon.object_value_code
451: UNION
452: SELECT rcon.object_code variable_code -- LHS of Condition from Global Rule
453: FROM okc_xprt_rule_hdrs_all rhdr,
454: okc_xprt_rule_conditions rcon
455: WHERE rhdr.rule_id = rcon.rule_id
456: AND rhdr.org_id = p_org_id
457: AND rhdr.intent = p_intent

Line 465: FROM okc_xprt_rule_hdrs_all rhdr,

461: AND SUBSTR(rcon.object_code,1,3) <> 'OKC'
462: GROUP BY rcon.object_code
463: UNION
464: SELECT rcon.object_value_code variable_code -- RHS of Condition from Global Rule
465: FROM okc_xprt_rule_hdrs_all rhdr,
466: okc_xprt_rule_conditions rcon
467: WHERE rhdr.rule_id = rcon.rule_id
468: AND rhdr.org_id = p_org_id
469: AND rhdr.intent = p_intent

Line 576: okc_xprt_rule_hdrs_all r,

572: SELECT 'CONSTANT$' || v.object_value_code constant_id, --
573: q.default_value
574: FROM okc_xprt_rule_cond_vals v,
575: okc_xprt_rule_conditions c,
576: okc_xprt_rule_hdrs_all r,
577: okc_xprt_questions_b q
578: WHERE v.rule_condition_id = c.rule_condition_id
579: AND c.rule_id = r.rule_id
580: AND to_char(q.question_id) = v.object_value_code

Line 684: FROM okc_xprt_rule_hdrs_all rhdr,

680: FROM okc_bus_variables_b var
681: WHERE var.variable_source = 'P'
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

Line 699: FROM okc_xprt_rule_hdrs_all rhdr,

695: AND SUBSTR(rcon.object_code,1,3) <> 'OKC'
696: GROUP BY rcon.object_code
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

Line 714: FROM okc_xprt_rule_hdrs_all rhdr,

710: AND SUBSTR(rcon.object_value_code,1,3) <> 'OKC'
711: GROUP BY rcon.object_value_code
712: UNION
713: SELECT distinct rcon.object_code variable_code -- LHS of Condition from Global Rule
714: FROM okc_xprt_rule_hdrs_all rhdr,
715: okc_xprt_rule_conditions rcon
716: WHERE rhdr.rule_id = rcon.rule_id
717: AND rhdr.org_id = p_org_id
718: AND rhdr.intent = p_intent

Line 726: FROM okc_xprt_rule_hdrs_all rhdr,

722: AND SUBSTR(rcon.object_code,1,3) <> 'OKC'
723: GROUP BY rcon.object_code
724: UNION
725: SELECT distinct rcon.object_value_code variable_code -- RHS of Condition from Global Rule
726: FROM okc_xprt_rule_hdrs_all rhdr,
727: okc_xprt_rule_conditions rcon
728: WHERE rhdr.rule_id = rcon.rule_id
729: AND rhdr.org_id = p_org_id
730: AND rhdr.intent = p_intent

Line 1030: FROM okc_xprt_rule_hdrs_all rhdr,

1026: AND RULE_CONDITION_ID IN (SELECT rule_condition_id
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

Line 1040: FROM okc_xprt_rule_hdrs_all rhdr

1036: AND trule.rule_id = rhdr.rule_id
1037: AND rhdr.status_code <> 'DRAFT'
1038: UNION
1039: SELECT rhdr.rule_id
1040: FROM okc_xprt_rule_hdrs_all rhdr
1041: WHERE rhdr.org_id = l_org_id
1042: AND rhdr.intent = l_intent
1043: AND rhdr.org_wide_flag = 'Y'
1044: AND rhdr.status_code <> 'DRAFT'