How can i choose the join conditions in report 6i
Posted: Tue Apr 21, 2009 8:15 am
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
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