APPS.GL_REP_ATTRIBUTES dependencies on FND_SEG_RPT_ATTRIBUTES

Line 117: FROM fnd_seg_rpt_attributes att,

113: att.segment_name,
114: fdu.default_type ,
115: fdu.default_value ,
116: fdu.range_code
117: FROM fnd_seg_rpt_attributes att,
118: fnd_flex_value_sets val ,
119: fnd_descr_flex_column_usages fdu
120: WHERE segment_name = p_seg_name
121: AND att.attr_value_set_id = val.flex_value_set_id

Line 187: FROM fnd_seg_rpt_attributes

183: END IF;
184: --
185: SELECT COUNT(*)
186: INTO ln_no_of_attributes
187: FROM fnd_seg_rpt_attributes
188: WHERE application_id = 101
189: AND id_flex_code = 'GLAT'
190: AND id_flex_num = p_coa_id;
191: IF ln_no_of_attributes > 42 THEN

Line 704: FROM fnd_seg_rpt_attributes attr,

700: attr.segment_name,
701: attr.segment_num,
702: valset.validation_type,
703: attr.attr_segment_name
704: FROM fnd_seg_rpt_attributes attr,
705: fnd_flex_value_sets valset
706: WHERE valset.flex_value_set_id = attr.flex_value_set_id
707: AND attr.id_flex_num = :ln_p_coa_id ';
708: ELSE

Line 717: FROM fnd_seg_rpt_attributes attr,

713: attr.application_column_name,
714: attr.segment_name,
715: attr.segment_num,
716: valset.validation_type
717: FROM fnd_seg_rpt_attributes attr,
718: fnd_flex_value_sets valset
719: WHERE valset.flex_value_set_id = attr.flex_value_set_id
720: AND attr.id_flex_num = :ln_p_coa_id '||
721: 'AND attr.segment_name = :lc_p_segment_name '||