SQL For Supplier List

[aganguly]

I am new to Oracle Purchase.

I want to generate a Supplier List with the following details.

Supplier Code
Supplier Name
Supplier Address
PAN
Status
TDS Section

I need the SQL for the same.

Thanks in advance.

Amitava

[siva sankar]

Hi,

Please use the following query to find the same.

select distinct(pv.segment1),
pv.VENDOR_NAME,
pvs.VENDOR_SITE_CODE site,
pvs.ADDRESS_LINE1,
pvs.ADDRESS_LINE2,
pvs.ADDRESS_LINE3,
pvs.CITY,
pvs.ZIP,
pvs.STATE,jav.PAN_NO,
jav.WARD_NO,jav.SECTION_code
from po.po_vendors pv,
po.po_vendor_sites_all pvs,
ja.ja_in_vendor_tds_info_hdr jav
where pv.vendor_id=pvs.vendor_id
and jav.VENDOR_id=pvs.VENDOR_id
and pvs.VENDOR_SITE_ID=jav.VENDOR_SITE_ID
and pv.END_DATE_ACTIVE is null
and pvs.INACTIVE_DATE is null order by segment1

Thanks & Regards,

Siva