Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Tie AP,PO and GL table
This is a discussion on Tie AP,PO and GL table within the Data Modeling forums, part of the Databases category; Hi all In order to get the correct result out of custom query I need to tie below tables. po_vendors ap_invoices_all gl_code_combinations gl_balances gl_budget_assignment gl_budget_entities gl_periods gl_set_of_books Actually I don't ...
|
|||||||
11-25-2008
|
|||
|
|||
|
Tie AP,PO and GL table
Hi all
In order to get the correct result out of custom query I need to tie below tables. po_vendors ap_invoices_all gl_code_combinations gl_balances gl_budget_assignment gl_budget_entities gl_periods gl_set_of_books Actually I don't have that much functional knowledge..so facing problem in joining the table.If u have any idea about that,then please reply Thanks in advance. Swati Ruhatiya 
|
| Sponsored Links |
|
11-25-2008
|
|||
|
|||
|
Re: Tie AP,PO and GL table
po_vendors - ap_invoices_all (vendor_id)
ap_invoices_all - gl_code_combinations (code_combination_id) gl_code_combinations - gl_balances (code_combination_id) gl_budget_assignment - gl_budget_entities (budget_entity_id) gl_periods - gl_balances (period_name) gl_set_of_books - gl_balances (set_of_books_id) gl_budget_assignment - gl_sets_of_books (set_of_book_id) i hope this helps
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| question about of the design of fact table and dimension table | joseluiselaprendiz | Data Warehousing | 0 | 09-05-2008 06:39 PM |
| Testing Dimensional table and Fact table | pesalasrinivas | Data Warehousing | 0 | 04-24-2008 07:09 PM |
| Conver MS Access table to Oracle Table | sureshkumar.akl | SQL | 0 | 03-28-2008 08:06 AM |
| How to insert data from one table to an empty table | sahanai mishra | Oracle Apps | 1 | 08-11-2007 11:45 AM |
| How a java table be brought to data table? | dhandhan | QTP | 0 | 04-15-2007 06:14 AM |
All times are GMT -4. The time now is 11:38 PM.
