IRC_TN_JOB_POSTING_LOCS

Details

Schema: FUSION
Object owner: IRC
Object type: VIEW

Columns

Name
TN_JOB_POSTING_LOC_ID TN_JOB_ID PRIMARY_FLAG FA_GEOGRAPHY_ID FA_GEOGRAPHY_TYPE FA_GEO_LEVEL_TYPES COUNTRY_CODE FA_GEOGRAPHY_NAME LOCATION_FQN CITY_FQN STATE_FQN COUNTRY STATE CITY FA_GEO_LEVEL_NAMES OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

TN_JOB_POSTING_LOC_ID

TN_JOB_ID

PRIMARY_FLAG

FA_GEOGRAPHY_ID

FA_GEOGRAPHY_TYPE

FA_GEO_LEVEL_TYPES

COUNTRY_CODE

FA_GEOGRAPHY_NAME

LOCATION_FQN

CITY_FQN

STATE_FQN

COUNTRY

STATE

CITY

FA_GEO_LEVEL_NAMES

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT TNJOBPOSTINGLOCSB.TN_JOB_POSTING_LOC_ID, TNJOBPOSTINGLOCSB.TN_JOB_ID, TNJOBPOSTINGLOCSB.PRIMARY_FLAG, TNJOBPOSTINGLOCSB.FA_GEOGRAPHY_ID, TNJOBPOSTINGLOCSB.FA_GEOGRAPHY_TYPE, TNJOBPOSTINGLOCSB.FA_GEO_LEVEL_TYPES, TNJOBPOSTINGLOCSB.COUNTRY_CODE, TNJOBPOSTINGLOCSTL.FA_GEOGRAPHY_NAME, TNJOBPOSTINGLOCSTL.LOCATION_FQN, TNJOBPOSTINGLOCSTL.CITY_FQN, TNJOBPOSTINGLOCSTL.STATE_FQN, TNJOBPOSTINGLOCSTL.COUNTRY, TNJOBPOSTINGLOCSTL.STATE, TNJOBPOSTINGLOCSTL.CITY, TNJOBPOSTINGLOCSTL.FA_GEO_LEVEL_NAMES, TNJOBPOSTINGLOCSB.OBJECT_VERSION_NUMBER, TNJOBPOSTINGLOCSB.CREATED_BY, TNJOBPOSTINGLOCSB.CREATION_DATE, TNJOBPOSTINGLOCSB.LAST_UPDATED_BY, TNJOBPOSTINGLOCSB.LAST_UPDATE_DATE, TNJOBPOSTINGLOCSB.LAST_UPDATE_LOGIN FROM IRC_TN_JOB_POSTING_LOCS_B TNJOBPOSTINGLOCSB, IRC_TN_JOB_POSTING_LOCS_TL TNJOBPOSTINGLOCSTL WHERE TNJOBPOSTINGLOCSB.TN_JOB_POSTING_LOC_ID = TNJOBPOSTINGLOCSTL.TN_JOB_POSTING_LOC_ID AND TNJOBPOSTINGLOCSTL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

TNJOBPOSTINGLOCSB.TN_JOB_POSTING_LOC_ID,

TNJOBPOSTINGLOCSB.TN_JOB_ID,

TNJOBPOSTINGLOCSB.PRIMARY_FLAG,

TNJOBPOSTINGLOCSB.FA_GEOGRAPHY_ID,

TNJOBPOSTINGLOCSB.FA_GEOGRAPHY_TYPE,

TNJOBPOSTINGLOCSB.FA_GEO_LEVEL_TYPES,

TNJOBPOSTINGLOCSB.COUNTRY_CODE,

TNJOBPOSTINGLOCSTL.FA_GEOGRAPHY_NAME,

TNJOBPOSTINGLOCSTL.LOCATION_FQN,

TNJOBPOSTINGLOCSTL.CITY_FQN,

TNJOBPOSTINGLOCSTL.STATE_FQN,

TNJOBPOSTINGLOCSTL.COUNTRY,

TNJOBPOSTINGLOCSTL.STATE,

TNJOBPOSTINGLOCSTL.CITY,

TNJOBPOSTINGLOCSTL.FA_GEO_LEVEL_NAMES,

TNJOBPOSTINGLOCSB.OBJECT_VERSION_NUMBER,

TNJOBPOSTINGLOCSB.CREATED_BY,

TNJOBPOSTINGLOCSB.CREATION_DATE,

TNJOBPOSTINGLOCSB.LAST_UPDATED_BY,

TNJOBPOSTINGLOCSB.LAST_UPDATE_DATE,

TNJOBPOSTINGLOCSB.LAST_UPDATE_LOGIN

FROM

IRC_TN_JOB_POSTING_LOCS_B TNJOBPOSTINGLOCSB,

IRC_TN_JOB_POSTING_LOCS_TL TNJOBPOSTINGLOCSTL

WHERE

TNJOBPOSTINGLOCSB.TN_JOB_POSTING_LOC_ID = TNJOBPOSTINGLOCSTL.TN_JOB_POSTING_LOC_ID AND TNJOBPOSTINGLOCSTL.LANGUAGE = USERENV('LANG')