FND Design Data [Home] [Help]

View: JAI_AP_TDS_SITE_V

Product: JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data: ViewAPPS.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