DBA Data[Home] [Help]

VIEW: EGO.EGO_SUPPLIERSITE_TMP#

Source

View Text - Preformatted

select BATCH_ID BATCH_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_NAME SUPPLIER_NAME, SUPPLIER_NUMBER SUPPLIER_NUMBER, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME, CITY CITY, STATE STATE, COUNTRY COUNTRY, SELECT_FLAG SELECT_FLAG, DUNS_NUMBER DUNS_NUMBER, TAX_PAYER_ID TAX_PAYER_ID, TAX_REGISTRATION_NUM TAX_REGISTRATION_NUM from "EGO"."EGO_SUPPLIERSITE_TMP"
View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_NAME SUPPLIER_NAME
, SUPPLIER_NUMBER SUPPLIER_NUMBER
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, SUPPLIER_SITE_NAME SUPPLIER_SITE_NAME
, CITY CITY
, STATE STATE
, COUNTRY COUNTRY
, SELECT_FLAG SELECT_FLAG
, DUNS_NUMBER DUNS_NUMBER
, TAX_PAYER_ID TAX_PAYER_ID
, TAX_REGISTRATION_NUM TAX_REGISTRATION_NUM
FROM "EGO"."EGO_SUPPLIERSITE_TMP"