APPS.OKC_SBCR_DT_PKG dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 77: fnd_descr_flex_column_usages fcu

73: fcu.end_user_column_name,
74: fcu.flex_value_set_id,
75: efdfce.data_type
76: FROM ego_fnd_df_col_usgs_ext efdfce ,
77: fnd_descr_flex_column_usages fcu
78: WHERE efdfce.descriptive_flexfield_name = p_desc_flexfld_name
79: AND efdfce.descriptive_flex_context_code = p_attr_group
80: AND fcu.descriptive_flex_context_code = efdfce.descriptive_flex_context_code
81: AND fcu.descriptive_flexfield_name = efdfce.descriptive_flexfield_name

Line 146: FROM fnd_descr_flex_column_usages fcu

142:
143: BEGIN
144:
145: SELECT fcu.application_column_name INTO l_rec_type_col_name
146: FROM fnd_descr_flex_column_usages fcu
147: WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
148: AND fcu.descriptive_flex_context_code = 'SBCR_REC_AG'
149: AND fcu.end_user_column_name = 'RECOMMENDATION_TYPE';
150:

Line 152: FROM fnd_descr_flex_column_usages fcu

148: AND fcu.descriptive_flex_context_code = 'SBCR_REC_AG'
149: AND fcu.end_user_column_name = 'RECOMMENDATION_TYPE';
150:
151: SELECT fcu.application_column_name INTO l_rec_percent_col_name
152: FROM fnd_descr_flex_column_usages fcu
153: WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
154: AND fcu.descriptive_flex_context_code = 'SBCR_REC_AG'
155: AND fcu.end_user_column_name = 'RECOMMEND_PERCENT';
156:

Line 206: FROM fnd_descr_flex_column_usages fcu

202:
203: BEGIN
204:
205: SELECT fcu.application_column_name INTO l_prev_acq_type_col_name
206: FROM fnd_descr_flex_column_usages fcu
207: WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
208: AND fcu.descriptive_flex_context_code = 'SBCR_PRE_ACQ'
209: AND fcu.end_user_column_name = 'ACQ_PREV';
210:

Line 212: FROM fnd_descr_flex_column_usages fcu

208: AND fcu.descriptive_flex_context_code = 'SBCR_PRE_ACQ'
209: AND fcu.end_user_column_name = 'ACQ_PREV';
210:
211: SELECT fcu.application_column_name INTO l_prev_acq_cmt_col_name
212: FROM fnd_descr_flex_column_usages fcu
213: WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
214: AND fcu.descriptive_flex_context_code = 'SBCR_PRE_ACQ'
215: AND fcu.end_user_column_name = 'ACQ_COMMENTS';
216:

Line 264: FROM fnd_descr_flex_column_usages fcu,

260: BEGIN
261:
262: SELECT fcu.application_column_name, efdfce.attr_id, efdfce.data_type
263: INTO l_sbcr_size_standard_col_name, l_attr_id, l_attr_data_type
264: FROM fnd_descr_flex_column_usages fcu,
265: ego_fnd_df_col_usgs_ext efdfce
266: WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
267: AND fcu.descriptive_flex_context_code = 'SBCR_PROC_INFO_AG'
268: AND fcu.end_user_column_name = 'SBCR_SBSS_SIZE_STANDARD'

Line 323: FROM fnd_descr_flex_column_usages fcu,

319: BEGIN
320:
321: SELECT fcu.application_column_name, efdfce.attr_id, efdfce.data_type
322: INTO l_sbcr_size_standard_col_name, l_attr_id, l_attr_data_type
323: FROM fnd_descr_flex_column_usages fcu,
324: ego_fnd_df_col_usgs_ext efdfce
325: WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
326: AND fcu.descriptive_flex_context_code = 'SBCR_PROC_INFO_AG'
327: AND fcu.end_user_column_name = 'SBCR_SBSS_SIZE_STANDARD'

Line 377: FROM fnd_descr_flex_column_usages fcu

373:
374: BEGIN
375:
376: SELECT fcu.application_column_name INTO l_rec_type_col_name
377: FROM fnd_descr_flex_column_usages fcu
378: WHERE fcu.descriptive_flexfield_name = 'OKC_REP_CONTRACT_HDR_EXT_ATTRS'
379: AND fcu.descriptive_flex_context_code = 'SBCR_REC_AG'
380: AND fcu.end_user_column_name = 'RECOMMENDATION_TYPE';
381: