View: JAI_AP_TDS_NULLSITE_THHOLD_V

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

View Text

SELECT DISTINCT A.VENDOR_ID
, B.TDS_VENDOR_TYPE_LOOKUP_CODE
, TO_NUMBER('0') VENDOR_SITE_ID
, TO_CHAR(NULL) PAN_NO
, TO_CHAR(NULL) TAN_NO
, C.SECTION_CODE
, C.SECTION_TYPE
, C.THRESHOLD_SETUP_NAME
, C.THRESHOLD_HDR_ID
, C.EXCEPTION_SETUP_FLAG
FROM PO_VENDORS A
, JAI_AP_TDS_VENDOR_HDRS B
, JAI_AP_TDS_THHOLD_HDRS C
WHERE A.VENDOR_ID = B.VENDOR_ID
AND B.VENDOR_SITE_ID = 0
AND B.TDS_VENDOR_TYPE_LOOKUP_CODE = C.VENDOR_TYPE_LOOKUP_CODE
AND C.EXCEPTION_SETUP_FLAG = 'N'

Columns