select
gjl.period_name period2,
gjb.period_name,
ggad.isgl_cost_center_50268 cost_center_description,
gjl.isgl_entity_50268 entity,
ggad.isgl_account_50268 account_description,
gjl.isgl_branch_50268 branch,
substr(ggad.isgl_cost_center_50268,1,5) cost_center,
ggad.isgl_cost_center_50268 "ISGL Cost Center",
substr(ggad.isgl_account_50268,1,6) account,
ggad.isgl_account_50268 account2,
gjl.isgl_cost_center_50268 cost_center2,
gjl.isgl_product_50268 product,
gjl.entered_dr debit,
gjl.isgl_intercompany_50268 "ISGL Intercompany",
gjl.isgl_intercompany_50268 interco,
gjl.entered_cr*-1 credit,
decode(gjl.converted_dr,null,0,gjl.converted_dr) "Debit (USD)",
decode(gjl.converted_cr,null,0,gjl.converted_cr*-1) "Credit (USD)",
gjl.isgl_intercompany_50268 "InterCo",
gjl.description,
gjl.isgl_market_50268 "ISGL Market",
(decode(gjl.converted_dr,null,0,gjl.converted_dr)+decode(gjl.converted_cr,null,0,gjl.converted_cr*-1)) "Net (USD)",
gjl.journal_entry_name "JE Name",
gjl.isgl_selling_bu_50268 "ISGL Selling BU",
gje.journal_source "JE Source",
gjl.isgl_future_1_50268 future_1,
gjb.batch_status status,
gjb.journal_batch_name batch_name,
gjl.isgl_future_2_50268 future_2,
gjl.journal_line_number "JE Line",
gjl.entered_cr credits,
gjb.date_posted,
decode(gjl.entered_dr,null,0,gjl.entered_dr) "Debit (local)",
decode(gjl.entered_cr,null,0,gjl.entered_cr*-1) "Credit (local)",
(decode(gjl.entered_dr,null,0,gjl.entered_dr)+decode(gjl.entered_cr,null,0,gjl.entered_cr*-1)) "Net (local)",
gjl.reference_1,
gje.currency_conversion_date curr_conv_date,
gjl.reference_2,
gje.currency curr,
gjl.reference_3,
gjl.reference_4,
decode(substr(gjl.isgl_product_50268,1,3),140,'Air',141,'Air',142,'Air',145,'Air',147,'Air',155,'Air',262,'Air',264,'Air',265,'Air',266,'Air',267,'Air',268,'Air',269,'Air',272,'Air',273,'Air',274,'Air',276,'Air',277,'Air',278,'Air',279,'Air',280,'Air',293,'Air',310,'Air',313,'Air',344,'Fluid',356,'Fluid',353,'Air',360,'Fluid',362,'Fluid',363,'Fluid',364,'Fluid',381,'Tools',383,'Tools',376,'Air',403,'Material',405,'Material',890,'Tools',350,'Tools',354,'Tools',378,'Tools',380,'Tools',384,'Tools',385,'Tools',386,'Tools',388,'Tools',394,'Tools',395,'Tools',396,'Tools',397,'Tools',470,'Air',621,'Air',624,'Air',630,'Air',632,'Air',633,'Air',640,'Air',641,'Air',642,'Air',643,'Air',671,'Air',672,'Air',673,'Air',674,'Air',675,'Air',676,'Air',677,'Air',682,'Air',683,'Air',688,'Air',811,'Air',398,'Tools',810,'Air',813,'Air',815,'Air',816,'Air',814,'Air',812,'Air',842,'Air',851,'Air',881,'Tools',885,'Tools',886,'Fluid',957,'Air',888,'Material',156,'Air',850,'Air',0,'00000','Other') sbu,
substr(ggad.isgl_account_50268,10,99) account_desc,
gjl.reference_5,
substr(gjl.period_name,5,4)||'-'||decode(substr(gjl.period_name,1,3),'Jan','01','Feb','02','Mar','03','Apr','04','May','05','Jun','06','Jul','07','Aug','08','Sep','09','Oct','10','Nov','11','Dec','12','Other') period,
gjl.reference_6,
gjl.reference_7,
gjl."TAX_CUSTOMER/VENDOR_NAME_3" "Customer/Vendor Name",
gjl.local_recon_ref reconciliation_reference,
gjb.journal_batch_name,
gjl.converted_dr converted_debits,
gjl.converted_cr converted_credit,
gjl.effective_date,
gje.reversal_period
from
glfg_gl_accounts_descr ggad,
glfg_journal_batches gjb,
glfg_journal_entries gje,
glfg_journal_lines gjl
where
2=2 and
ggad.account_id=gjl.account_id and
gjb.journal_batch_id=gje.journal_batch_id and
gje.journal_entry_id=gjl.journal_entry_id |
