IRC_CAND_GEOGRAPHIES

Details

Schema: FUSION
Object owner: IRC
Object type: VIEW

Columns

Name
GEOGRAPHY_ID GEOGRAPHY_TYPE GEOGRAPHY_NAME COUNTRY_ID COUNTRY STATE_ID STATE CITY_ID CITY COUNTY_ID COUNTY NAME FQN FQN_COUNTRY FQN_STATE FQN_CITY OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

GEOGRAPHY_ID

GEOGRAPHY_TYPE

GEOGRAPHY_NAME

COUNTRY_ID

COUNTRY

STATE_ID

STATE

CITY_ID

CITY

COUNTY_ID

COUNTY

NAME

FQN

FQN_COUNTRY

FQN_STATE

FQN_CITY

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT B.GEOGRAPHY_ID, B.GEOGRAPHY_TYPE, B.GEOGRAPHY_NAME, B.COUNTRY_ID, B.COUNTRY, B.STATE_ID, B.STATE, B.CITY_ID, B.CITY, B.COUNTY_ID, B.COUNTY, TL.NAME, TL.FQN, TL.FQN_COUNTRY, TL.FQN_STATE, TL.FQN_CITY, B.OBJECT_VERSION_NUMBER, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN FROM irc_cand_geographies_b B, irc_cand_geographies_tl TL WHERE B.GEOGRAPHY_ID = TL.GEOGRAPHY_ID AND TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.GEOGRAPHY_ID,

B.GEOGRAPHY_TYPE,

B.GEOGRAPHY_NAME,

B.COUNTRY_ID,

B.COUNTRY,

B.STATE_ID,

B.STATE,

B.CITY_ID,

B.CITY,

B.COUNTY_ID,

B.COUNTY,

TL.NAME,

TL.FQN,

TL.FQN_COUNTRY,

TL.FQN_STATE,

TL.FQN_CITY,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN

FROM

irc_cand_geographies_b B, irc_cand_geographies_tl TL

WHERE

B.GEOGRAPHY_ID = TL.GEOGRAPHY_ID

AND

TL.LANGUAGE = USERENV('LANG')