Help to organize or fix script AP
Hello everybody
Please help me to organize or fix my above script
Select
xah.event_id,
GJH.JE_HEADER_ID,
aca.bank_account_name,
aca.check_number,
gjh.period_name,
gjh.default_effective_date,
gjh.currency_code,
aca.vendor_name,
--gjh.doc_sequence_value,
--docdzd.doc_sequence_value,
--docusd.doc_sequence_value,
docdzd.doc_sequence_value || case when docusd.doc_sequence_value !=docdzd.doc_sequence_value then '/'|| docusd.doc_sequence_value else null end NUM_DOCUMENT,
case when nvl (gjl.accounted_dr, 0) >0 then 'D' else 'C' end SIGNE,
cc.segment2,
cc.segment3,
cc.segment4,
abs (DECODE(gjl.ledger_id,'2024',NVL(gjl.entered_dr,0)- NVL(gjl.entered_cr,0),0)) org,