Search found 6 matches
- Thu Jun 25, 2009 7:08 am
- Forum: Reports (Only Oracle Apps Reports)
- Topic: GL--- SUBLEDGER ALL LINE DRILLDOW QUERY
- Replies: 1
- Views: 5197
GL--- SUBLEDGER ALL LINE DRILLDOW QUERY
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 ...
- Thu Jun 25, 2009 4:54 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: SQL Query For rcv tranxtion by supplier and inv ??
- Replies: 0
- Views: 747
SQL Query For rcv tranxtion by supplier and inv ??
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...
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...
- Thu Jun 25, 2009 4:38 am
- Forum: Purchasing & Inventory
- Topic: SQL QUERY FOR REV ITEMS BY SUPPLIER ??
- Replies: 0
- Views: 704
SQL QUERY FOR REV ITEMS BY SUPPLIER ??
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
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
- Wed Jun 24, 2009 10:04 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: SQL QUERY FOR AP INVOICES
- Replies: 2
- Views: 1686
- Wed Jun 24, 2009 8:03 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: SQL QUERY FOR AP INVOICES
- Replies: 2
- Views: 1686
SQL QUERY FOR AP INVOICES
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...
- Wed Jun 24, 2009 7:56 am
- Forum: Financials (GL, AP, AR, FA & CM)
- Topic: CUSTOMER SOA SQL QUERY
- Replies: 0
- Views: 652
CUSTOMER SOA SQL QUERY
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
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