Receivables - EBS (MOSC)

MOSC Banner

Change Record feild for APP_FOLDER.TRX_NUMBER AR receipt form

edited Jun 5, 2018 5:09AM in Receivables - EBS (MOSC) 1 commentAnswered

Hi

I need help in AR receipt form  fro record group change for APP_FOLDER.TRX_NUMBER .

please check below query

select /*+FIRST_ROWS */

ot.trx_number ,

ot.customer_id ,

ot.customer_number ,

ot.class ,

SUBSTRB(ot.class_meaning, 1, 30) class_meaning ,

ot.trx_type ,

ot.cust_trx_type_id ,

ot.trx_due_date trx_due_date ,

SUBSTRB(decode(sign(ot.payment_schedule_id),-1, :app_main.currency_code,

              ot.invoice_currency_code), 1, 15) invoice_currency_code ,

ot.balance_due_curr ,

decode(sign(ot.payment_schedule_id),-1, to_number(null),

              ot.balance_due_functional) balance_due_functional,

ot.customer_name ,

ot.location,

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