Hello Everyone,
I need your help from you all.
can any one please provide the query which retrieves data from GL to AR , in oracle apps 11i.
need columns as follows :
Journal Batch name,
Journal Header Name,
Journal header description,
Journal Period,
Journal Category,
Journal Source,
Journal Line number,
Journal Line Description,
Entered_CR,
Entered_DR,
Accounted_CR,
Accounted_DR,
GL_date,
Transaction Number,
Transaction Date,
Customer Name,
Customer Number.
It will help me a lot, I am trying but not getting data correctly.
Awaiting for your reply.
Thanks & Regards
Bhanu Prakash Kadavakollu.