How can i choose the join conditions in report 6i

There are many available reports in Oracle Apps so you can discuss the requirements related to these reports here.
Post Reply
visu.madhu
Posts: 6
Joined: Thu Mar 12, 2009 6:18 am
Location: India

How can i choose the join conditions in report 6i

Post by visu.madhu »

hi
here my doubt is how can i choose the oracle apps tables and join conditions in report 6i.i have some idea like in data query i need to write the sql statement
ex:select pv.vendor_id,pvs.vendor_site_id from po_vendors pv,po_vendor_sites_all pvs where pv.vendor_id=pvs.vendor_id
if we know the report fields and parameters how can i choose the tables and join conditions
sivananda
Posts: 9
Joined: Tue Jun 30, 2009 2:52 am
Location: India

Post by sivananda »

Hi,
The report , you should what fileds to be displayed in report based on that pull the tables and make a proper joins to the tables.

EX:

select
pv.vendor_id
,pvs.vendor_site_id
from
po_vendors pv,
po_vendor_sites_all pvs
where
pv.vendor_id=pvs.vendor_id

In this example , vendor id and site id are the selected fields from the table, so vendor id is the primary key in the both the tables.

If any thing plz let me know

Thanks,
sivananda venkat
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest