View: JAI_AP_TDS_DEFAULT_SECTION_V

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

View Text

SELECT E.TDS_VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, A.VENDOR_ID
, A.VENDOR_NAME
, C.PAN_NO
, D.ORG_TAN_NUM
, B.VENDOR_SITE_ID
, B.VENDOR_SITE_CODE
, C.SECTION_TYPE
, C.SECTION_CODE
, /* BUG 5093948 CHANGED
FROM 'C' TO 'E' C.CONFIRM_PAN_FLAG
, */ E.CONFIRM_PAN_FLAG
, B.ORG_ID
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_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 UNION ALL SELECT C.TDS_VENDOR_TYPE_LOOKUP_CODE VENDOR_TYPE_LOOKUP_CODE
, A.VENDOR_ID
, A.VENDOR_NAME
, C.PAN_NO
, TO_CHAR(NULL) ORG_TAN_NUM
, C.VENDOR_SITE_ID
, 'ALL SITES' VENDOR_SITE_CODE
, C.SECTION_TYPE
, C.SECTION_CODE
, C.CONFIRM_PAN_FLAG
, TO_NUMBER(NULL) ORG_ID
FROM PO_VENDORS A
, JAI_AP_TDS_VENDOR_HDRS C
WHERE A.VENDOR_ID = C.VENDOR_ID
AND C.VENDOR_SITE_ID = 0

Columns