[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 |