FND Design Data [Home] [Help]

View: JAI_AP_TDS_THHOLD_VENDOR_V

Product: JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data: ViewAPPS.JAI_AP_TDS_THHOLD_VENDOR_V
View Text

SELECT DISTINCT B.TDS_VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, A.VENDOR_ID
, A.VENDOR_NAME
FROM PO_VENDORS A
, JAI_AP_TDS_VENDOR_HDRS B
WHERE A.VENDOR_ID = B.VENDOR_ID
AND B.VENDOR_SITE_ID = 0
AND B.TDS_VENDOR_TYPE_LOOKUP_CODE IS NOT NULL

Columns

Name
VENDOR_TYPE_LOOKUP_CODE
VENDOR_ID
VENDOR_NAME