[Home] [Help]
View: JAI_AP_TDS_SITE_V
View Text
SELECT VENDOR_ID
, TDS_VENDOR_TYPE_LOOKUP_CODE
, VENDOR_SITE_ID
, PAN_NO
, TAN_NO
, SECTION_CODE
, SECTION_TYPE
, THRESHOLD_SETUP_NAME
, THRESHOLD_HDR_ID
, EXCEPTION_SETUP_FLAG
FROM JAI_AP_TDS_TH_VSITE_V UNION ALL SELECT VENDOR_ID
, TDS_VENDOR_TYPE_LOOKUP_CODE
, VENDOR_SITE_ID
, PAN_NO
, TAN_NO
, SECTION_CODE
, SECTION_TYPE
, THRESHOLD_SETUP_NAME
, THRESHOLD_HDR_ID
, EXCEPTION_SETUP_FLAG
FROM JAI_AP_TDS_NULLSITE_THHOLD_V
Columns
Name |
VENDOR_ID |
TDS_VENDOR_TYPE_LOOKUP_CODE |
VENDOR_SITE_ID |
PAN_NO |
TAN_NO |
SECTION_CODE |
SECTION_TYPE |
THRESHOLD_SETUP_NAME |
THRESHOLD_HDR_ID |
EXCEPTION_SETUP_FLAG |