VIEW: CCT.CCT_EXTERNAL_ADDRESSES#

Source

View Text - Preformatted

select EXTERNAL_ADDRESS_ID EXTERNAL_ADDRESS_ID, LAST_NAME LAST_NAME, FIRST_NAME FIRST_NAME, DESCRIPTION DESCRIPTION, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, F_DELETEDFLAG F_DELETEDFLAG, SECURITY_GROUP_ID SECURITY_GROUP_ID, UPG_COUNTRY_CODE UPG_COUNTRY_CODE, UPG_AREA_CODE UPG_AREA_CODE, UPG_LOCAL_NUMBER UPG_LOCAL_NUMBER, AREA_CODE AREA_CODE, COUNTRY_CODE COUNTRY_CODE, LOCAL_NUMBER LOCAL_NUMBER from "CCT"."CCT_EXTERNAL_ADDRESSES"

View Text - HTML Formatted

SELECT EXTERNAL_ADDRESS_ID EXTERNAL_ADDRESS_ID
, LAST_NAME LAST_NAME
, FIRST_NAME FIRST_NAME
, DESCRIPTION DESCRIPTION
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, F_DELETEDFLAG F_DELETEDFLAG
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, UPG_COUNTRY_CODE UPG_COUNTRY_CODE
, UPG_AREA_CODE UPG_AREA_CODE
, UPG_LOCAL_NUMBER UPG_LOCAL_NUMBER
, AREA_CODE AREA_CODE
, COUNTRY_CODE COUNTRY_CODE
, LOCAL_NUMBER LOCAL_NUMBER
FROM "CCT"."CCT_EXTERNAL_ADDRESSES"