DBA Data[Home] [Help]

APPS.OKC_XPRT_IMPORT_CLAUSES_PVT dependencies on OKC_ARTICLES_ALL

Line 1125: okc_articles_all a

1121: a.article_title
1122: FROM okc_xprt_rule_cond_vals v,
1123: okc_xprt_rule_conditions c,
1124: okc_xprt_rule_hdrs_all r,
1125: okc_articles_all a
1126: WHERE v.rule_condition_id = c.rule_condition_id
1127: AND c.rule_id = r.rule_id
1128: AND a.article_id = to_number(v.object_value_code) -- Fix for bug 5030078.Removed to_char and added to_number
1129: AND c.object_type = 'CLAUSE'

Line 1140: okc_articles_all a

1136: SELECT to_char(o.object_value_id) article_id,
1137: a.article_title
1138: FROM okc_xprt_rule_outcomes o,
1139: okc_xprt_rule_hdrs_all r,
1140: okc_articles_all a
1141: WHERE o.rule_id = r.rule_id
1142: AND a.article_id = o.object_value_id
1143: AND o.object_type = 'CLAUSE'
1144: AND r.org_id = p_org_id