DBA Data[Home] [Help]

APPS.OKL_DEAL_CREAT_PVT dependencies on OKC_RULE_DEFS_V

Line 2755: okc_rule_defs_v rulup

2751: FROM FND_DESCR_FLEX_COLUMN_USAGES fus,
2752: fnd_flex_value_sets ffv,
2753: okc_rg_def_rules defrul,
2754: fnd_lookup_values flup,
2755: okc_rule_defs_v rulup
2756: WHERE fus.DESCRIPTIVE_FLEX_CONTEXT_CODE = defrul.rdf_code
2757: AND fus.application_id = 540
2758: AND ffv.flex_value_set_id = fus.flex_value_set_id
2759: AND flup.lookup_code = defrul.rgd_code

Line 9148: okc_rule_defs_v rdef

9144:
9145: CURSOR c_prompt_name IS
9146: SELECT rdef.rule_code,col.form_left_prompt
9147: FROM fnd_descr_flex_col_usage_vl col,
9148: okc_rule_defs_v rdef
9149: WHERE col.application_id = rdef.application_id
9150: AND col.descriptive_flexfield_name=rdef.descriptive_flexfield_name
9151: AND col.descriptive_flex_context_code=rdef.rule_code
9152: AND rdef.rule_code in ('LACPLN','LANNTF','LAREBL','LARLES','LATOWN','LAPACT');