Query to Fetch the GL Segment Values-Oracle ERP Cloud

SELECT segvalsets.value_set_code,

value,

segvals.description,

enabled_flag,

start_date_active,

end_date_active,

summary_flag,

flex_value_attribute1 AS POSTING_ALLOWED,

flex_value_attribute2 AS BUDGETING_ALLOWED,

flex_value_attribute3 AS ACCOUNT_TYPE,

flex_value_attribute4 AS CONTROL_ACCOUNT,

flex_value_attribute5 AS RECONCILIATION_FLAG,

flex_value_attribute6 AS FINANCIAL_CATEGORY

FROM fusion.fnd_vs_values_vl segvals,

fusion.fnd_vs_value_sets segvalsets

WHERE segvals.value_set_id = segvalsets.value_set_id

AND segvalsets.value_set_id IN (SELECT value_set_id

FROM fusion.fnd_kf_segment_instances

WHERE structure_instance_id IN (SELECT

fusion.fnd_kf_str_instances_b.structure_instance_id

FROM fusion.fnd_kf_str_instances_b

WHERE application_id = 101

AND key_flexfield_code = 'GL#'))

Happy Learning!