ERPstuff - Oracle EBS Community

Hi All, I am very new to this foram,,, I need help for a query by which i can find out all drildown lines till transaction lavel for GL balance. As in India we hv to justify each and every tansaction but in oracele GL line are posted as group... So i think you will help me in this sql query. Thanks ...

Hi All,

I want help to get the following data by a SQL Query...

Supplier Name--Site---Date---Inv. no.---AMount---GRN No.----Description--- GL Code Combination Code Combination--- Receiveing trx. detais

Thish all is for AP Accural Reconciliation Purpose...

Hi All,

I want sql query by which i m able to link the following relationship


Supplier Name---Site----GRN----Invoince No.-----Date-----Amount----Account Code combination------

Thanks ,
Sanjay Khandelwal

Hi,

Really this is a very useful script....

Thanks a lot for such information.

HI ALL, I want help for a SQL query in which i can find the following relation SUPPLIER NAME---SITE CODE----DATE----INVOICE NO.----DESCRIPTION-----GL CODE COMBINATION Basiclly i want to the GL -- Subledger Report --- from where i can find the all invoices in a particular GL like Professional Charges...

HI ALL,

I need help to generat the SQL query by which i can get the statement of account for a customer in the below format

Opening Balances....
Period Activity.....
Closing Balances