Hello,
I was wondering if someone could please help me out in getting the below script to work since I’m not an expert in SQL
What I need is to also get the Description of the EAC … the same as the ACTDES.
If this helps this is the script that pulls in the EAC + Description so I need to add this someway to the script below?
select flex_value, substr(t.description,0,50)
from apps.fnd_flex_values_vl t
where t.flex_value_set_id = 1009148
This is the script that I’m trying to get to work:
select
j.period_name MTH,
g.segment1 CO,
g.segment2 OU,
(g.segment3||’ - '||substr(t.description,0,50)) ACTDES,
substr(j.attribute3,1,6) EAC, — How do we add the EAC + Description
to_number((nvl(j.accounted_dr,0)-nvl(j.accounted_cr,0))) VALUE
from apps.gl_code_combinations g,
apps.gl_je_categories_tl c,
apps.gl_je_lines j,
apps.gl_je_headers h,
apps.gl_je_sources_tl s,
apps.fnd_flex_values_vl t
where j.status=‘P’
and t.flex_value_set_id = 1009133
and t.flex_value = g.segment3
and h.actual_flag = ‘A’
and h.je_category = c.je_category_name
and h.je_source=s.je_source_name
and g.code_combination_id = j.code_combination_id
and j.period_name in (‘Jul-16’)
and h.ledger_id=326
and j.je_header_id = h.je_header_id
and(g.segment3) = (‘70050’)
If somone could please help out that would be greatly appreciated
Thanks
Example.docx (28.4 KB)