Sunday, October 22, 2017

Query to get Journal Header Level Details in R12

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;

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)