DBA Data[Home] [Help]

APPS.OKL_RULE_APIS_PVT dependencies on OKC_RULE_DEFS_V

Line 613: okc_rule_defs_v rdefv

609: --union
610: select dflex.descriptive_flex_context_code
611: , dflex.flex_value_set_id
612: from fnd_descr_flex_col_usage_vl dflex,
613: okc_rule_defs_v rdefv
614: where dflex.application_id = rdefv.application_id
615: and dflex.descriptive_flexfield_name = rdefv.descriptive_flexfield_name
616: and dflex.descriptive_flex_context_code = rdefv.rule_code
617: and dflex.application_column_name = p_appl_col_name

Line 1687: okc_rule_defs_v rdefv

1683: --added for rule striping (once finalized remove the top portion of union)
1684: Select dflex.descriptive_flex_context_code
1685: , dflex.application_column_name
1686: from fnd_descr_flex_col_usage_vl dflex,
1687: okc_rule_defs_v rdefv
1688: where dflex.application_id = rdefv.application_id
1689: and dflex.descriptive_flexfield_name = rdefv.descriptive_flexfield_name
1690: and dflex.descriptive_flex_context_code = rdefv.rule_code
1691: and dflex.form_left_prompt = p_rdf_name