DBA Data[Home] [Help]

APPS.PQP_RIW_WEBADI_UTILS dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 3141: FROM fnd_descr_flex_column_usages fd,

3137: -- Cursor to get the global segments and the context specific segments for the DFF
3138: CURSOR csr_get_dff_segments (c_dff_name IN VARCHAR2
3139: ,c_context IN VARCHAR2) IS
3140: SELECT fd.application_column_name
3141: FROM fnd_descr_flex_column_usages fd,
3142: fnd_descr_flex_col_usage_tl fdtl
3143: WHERE fd.descriptive_flexfield_name = fdtl.descriptive_flexfield_name
3144: AND fd.descriptive_flex_context_code=fdtl.descriptive_flex_context_code
3145: AND fd.descriptive_flexfield_name = (SELECT descriptive_flexfield_name

Line 3163: l_dff_ctx_val fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;

3159: -- l_segment_list VARCHAR2(1000);
3160: l_concat_segments VARCHAR2(300);
3161:
3162: l_delimiter fnd_descriptive_flexs.concatenated_segment_delimiter%TYPE;
3163: l_dff_ctx_val fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
3164:
3165: l_dyn_sql_qry Varchar(1000);
3166: l_effective_date DATE;
3167: