DBA Data[Home] [Help]

APPS.FV_TBAL_BY_TS dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 39: fnd_segment_attribute_values fsav

35: /* Bug 6244171 - Current query for cursor commented out and new select statement added to fetch correct segment*/
36: /* SELECT fifsv.application_column_name
37: FROM
38: fnd_id_flex_segments_vl fifsv,
39: fnd_segment_attribute_values fsav
40: WHERE
41: fifsv.application_id = 101
42: AND fifsv.id_flex_code = 'GL#'
43: AND fifsv.id_flex_num = fsav.id_flex_num

Line 49: fnd_segment_attribute_values

45: AND fsav.segment_attribute_type = p_attribute_type; */
46:
47: SELECT application_column_name
48: FROM
49: fnd_segment_attribute_values
50: WHERE
51: application_id = 101
52: AND id_flex_code = 'GL#'
53: AND id_flex_num = p_chart_of_accounts_id