Query to retrieve GL Journal Import

Introduction

This Post illustrates the steps required to retrieve GL Journal Import in Oracle EBS R12.

 

Script to retrieve GL Journal Import

SELECT

glc.segment1

|| ‘-‘

|| apps.gl_flexfields_pkg.get_description_sql

(glc.chart_of_accounts_id,

1,

glc.segment1

) “Company” ,

to_char(glh.default_effective_date,’DD-MON-YYYY’) “Accounting Date”

,glh.je_source “Source”

,gljc.user_je_category_name “Category”

,glh.doc_sequence_value “Document Number”

,glh.currency_code “Currency”

,NVL(REPLACE(gll.description,chr(9),”),”)”Description”

,gll.entered_dr “Dr”

,gll.entered_cr “Cr”

,glh.created_by “Created by”

,glh.creation_date

FROM apps.gl_je_headers glh,

apps.gl_je_lines gll,

apps.gl_je_categories_tl gljc,

apps.gl_code_combinations glc

WHERE glh.je_header_id = gll.je_header_id

AND gll.code_combination_id = glc.code_combination_id

–AND glh.je_source = ‘Manual’

AND glh.default_effective_date BETWEEN :lv_from_date AND :lv_to_date

AND glh.je_category=gljc.je_category_name

order by doc_sequence_value,default_effective_date,gll.entered_dr,gll.entered_cr;

 

Summary

This Post described the script to retrieve GL Journal Import in Oracle EBS R12.

 

Got any queries?

Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.