[Home] [Help]
View: 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
Name |
VENDOR_TYPE_LOOKUP_CODE |
VENDOR_ID |
VENDOR_NAME |
PAN_NO |
ORG_TAN_NUM |
VENDOR_SITE_ID |
VENDOR_SITE_CODE |
SECTION_TYPE |
SECTION_CODE |
CONFIRM_PAN_FLAG |
ORG_ID |