View: JAI_AP_TDS_TH_PAN_TAN_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_AP_TDS_TH_PAN_TAN_V

View Text

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

Columns