i want to make report
to get gl oaccount(segment and description)
like that
1.0000.101.200
company.dept.cc
and so on
help in gl report
hi sors,
select gcc.segment1||'.'||gcc.segment2||'.'||gcc.segment3||'.'||gcc.segment4||'.'||gcc.segment5 Account_Code,
f1.DESCRIPTION||'.'|| f2.DESCRIPTION||'.'|| f2.DESCRIPTION||'.'|| f3.DESCRIPTION||'.'|| f4.DESCRIPTION Account_desc
from
fnd_flex_values_vl f1,
fnd_flex_values_vl f2,
fnd_flex_values_vl f3,
fnd_flex_values_vl f4,
fnd_flex_values_vl f5,
gl_code_combinations gcc
where
f1.flex_value=gcc.segment1 and f2.flex_value=gcc.segment2
and f3.flex_value=gcc.segment3 and f4.flex_value=gcc.segment4
and f5.flex_value=gcc.segment5
and f1.flex_value_set_id=1010882 and f2.flex_value_set_id=1011029
and f3.flex_value_set_id=1010883 and f4.flex_value_set_id=1010881
and f5.flex_value_set_id=1010884
replace "flex_value_set_id" as per your chart of account.
hope this help you
also visit
http://www.notesbit.com/index.php/oracl ... formation/
select gcc.segment1||'.'||gcc.segment2||'.'||gcc.segment3||'.'||gcc.segment4||'.'||gcc.segment5 Account_Code,
f1.DESCRIPTION||'.'|| f2.DESCRIPTION||'.'|| f2.DESCRIPTION||'.'|| f3.DESCRIPTION||'.'|| f4.DESCRIPTION Account_desc
from
fnd_flex_values_vl f1,
fnd_flex_values_vl f2,
fnd_flex_values_vl f3,
fnd_flex_values_vl f4,
fnd_flex_values_vl f5,
gl_code_combinations gcc
where
f1.flex_value=gcc.segment1 and f2.flex_value=gcc.segment2
and f3.flex_value=gcc.segment3 and f4.flex_value=gcc.segment4
and f5.flex_value=gcc.segment5
and f1.flex_value_set_id=1010882 and f2.flex_value_set_id=1011029
and f3.flex_value_set_id=1010883 and f4.flex_value_set_id=1010881
and f5.flex_value_set_id=1010884
replace "flex_value_set_id" as per your chart of account.
hope this help you
also visit
http://www.notesbit.com/index.php/oracl ... formation/
Who is online
Users browsing this forum: No registered users and 1 guest