select SEGMENT1 Company,
apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id
1, —– Position of segment
segment1 —- Segment value
) Company_desc,
SEGMENT2 Location,
apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id
2, —– Position of segment
segment2 —- Segment value
) Location_desc,
SEGMENT3 Product,
apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id
3, —– Position of segment
segment3 —- Segment value
) Product_desc,
SEGMENT4 Function,
apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id
4, —– Position of segment
segment4 —- Segment value
) Function_desc,
SEGMENT5 Account,
apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id
5, —– Position of segment
segment5 —- Segment value
) Account_desc,
SEGMENT6 Intercompany,
apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id
6, —– Position of segment
segment6 —- Segment value
) Intercompany_desc,
SEGMENT7 SubAccount,
apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id
7, —– Position of segment
segment7 —- Segment value
) SubAccount_desc,
SEGMENT8 Future1,
apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id
8, —– Position of segment
segment8 —- Segment value
) Future1_desc,
SEGMENT9 Future2,
apps.gl_flexfields_pkg.get_description_sql (chart_of_accounts_id,— chart of account id
9, —– Position of segment
segment9 —- Segment value
) Future2_desc,
SEGMENT1||’.’||
SEGMENT2||’.’||
SEGMENT3||’.’||
SEGMENT4||’.’||
SEGMENT5||’.’||
SEGMENT6||’.’||
SEGMENT7||’.’||
SEGMENT8||’.’||
SEGMENT9 concatenated_segments,
apps.gl_flexfields_pkg.get_concat_description
(chart_of_accounts_id,
code_combination_id
) concatenated_segments_desc
from apps.gl_code_combinations_v where segment1 = ‘40906’
Recommended Posts
