General Ledger - EBS (MOSC)

MOSC Banner

Help to organize or fix script AP

edited Nov 10, 2017 4:49AM in General Ledger - EBS (MOSC) 1 commentAnswered

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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center