VIEW: APPS.JAI_AP_TDS_DEFAULT_SECTION_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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