VIEW: APPS.JAI_AP_TDS_TH_PAN_TAN_V

Source

View Text - Preformatted

SELECT DISTINCT e.tds_vendor_type_lookup_code vendor_type_lookup_code, a.vendor_id, a.vendor_name, c.pan_no, d.org_tan_num FROM po_vendors a, ap_supplier_sites_all b, JAI_AP_TDS_VENDOR_HDRS c, jai_ap_tds_org_tan_v d, /* JAI_AP_TDS_ORG_TANS is changed to view jai_ap_tds_org_tan_v 4323338 */ jai_ap_tds_vndr_type_v e WHERE a.vendor_id = b.vendor_id AND b.vendor_id = c.vendor_id AND b.vendor_site_id = c.vendor_site_id AND b.org_id = d.organization_id AND a.vendor_id = e.vendor_id

View Text - HTML Formatted

SELECT DISTINCT E.TDS_VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, A.VENDOR_ID
, A.VENDOR_NAME
, C.PAN_NO
, D.ORG_TAN_NUM
FROM PO_VENDORS A
, AP_SUPPLIER_SITES_ALL B
, JAI_AP_TDS_VENDOR_HDRS C
, JAI_AP_TDS_ORG_TAN_V D
, /* JAI_AP_TDS_ORG_TANS IS CHANGED TO VIEW JAI_AP_TDS_ORG_TAN_V 4323338 */ JAI_AP_TDS_VNDR_TYPE_V E
WHERE A.VENDOR_ID = B.VENDOR_ID
AND B.VENDOR_ID = C.VENDOR_ID
AND B.VENDOR_SITE_ID = C.VENDOR_SITE_ID
AND B.ORG_ID = D.ORGANIZATION_ID
AND A.VENDOR_ID = E.VENDOR_ID