SELECT e.name ledger_name,
a.period_name,
g.user_je_category_name category_name,
f.user_je_source_name je_sournce,
a.name journal_name,
a.description,
a.currency_code,
a.running_total_dr entered_dr,
a.running_total_cr entered_cr,
a.running_total_accounted_dr accounted_dr,
a.running_total_accounted_cr accounted_cr,
a.posted_date,
h.user_name created_by,
i.user_name posted_by
FROM apps.gl_je_headers a,
apps.fnd_user h,
apps.fnd_user i,
apps.gl_ledgers e,
apps.gl_je_sources f,
apps.gl_je_categories g
WHERE h.user_id = a.created_by
AND i.user_id = a.last_updated_by
AND a.status = 'P'
AND a.period_name IN ('JAN-18',
'FEB-18',
'MAR-18',
'APR-18',
'MAY-18',
'JUN-18',
'JUL-18',
'AUG-18',
'SEP-18')
AND a.ledger_id = e.ledger_id
AND a.je_category = g.je_category_name
AND a.je_source = f.je_source_name
ORDER BY e.name, a.period_name, a.posted_date;
a.period_name,
g.user_je_category_name category_name,
f.user_je_source_name je_sournce,
a.name journal_name,
a.description,
a.currency_code,
a.running_total_dr entered_dr,
a.running_total_cr entered_cr,
a.running_total_accounted_dr accounted_dr,
a.running_total_accounted_cr accounted_cr,
a.posted_date,
h.user_name created_by,
i.user_name posted_by
FROM apps.gl_je_headers a,
apps.fnd_user h,
apps.fnd_user i,
apps.gl_ledgers e,
apps.gl_je_sources f,
apps.gl_je_categories g
WHERE h.user_id = a.created_by
AND i.user_id = a.last_updated_by
AND a.status = 'P'
AND a.period_name IN ('JAN-18',
'FEB-18',
'MAR-18',
'APR-18',
'MAY-18',
'JUN-18',
'JUL-18',
'AUG-18',
'SEP-18')
AND a.ledger_id = e.ledger_id
AND a.je_category = g.je_category_name
AND a.je_source = f.je_source_name
ORDER BY e.name, a.period_name, a.posted_date;
No comments:
Post a Comment