IRC_TN_JOB_WORK_LOCS_VL

Details

• Schema: FUSION

• Object owner: IRC

• Object type: VIEW

Columns

Name
TN_JOB_WORK_LOC_ID TN_JOB_ID PRIMARY_FLAG FA_LOCATION_ID FA_LOCATION_CODE ADDRESS_LINE_1 ADDRESS_LINE_2 ADDRESS_LINE_3 ADDRESS_LINE_4 BUILDING TOWN_OR_CITY POSTAL_CODE COUNTRY REGION_1 REGION_2 REGION_3 FA_LOCATION_NAME FULL_LOCATION_ADDRESS OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT TNJOBWORKLOCSB.TN_JOB_WORK_LOC_ID, TNJOBWORKLOCSB.TN_JOB_ID, TNJOBWORKLOCSB.PRIMARY_FLAG, TNJOBWORKLOCSB.FA_LOCATION_ID, TNJOBWORKLOCSB.FA_LOCATION_CODE, TNJOBWORKLOCSB.ADDRESS_LINE_1, TNJOBWORKLOCSB.ADDRESS_LINE_2, TNJOBWORKLOCSB.ADDRESS_LINE_3, TNJOBWORKLOCSB.ADDRESS_LINE_4, TNJOBWORKLOCSB.BUILDING, TNJOBWORKLOCSB.TOWN_OR_CITY, TNJOBWORKLOCSB.POSTAL_CODE, TNJOBWORKLOCSB.COUNTRY, TNJOBWORKLOCSB.REGION_1, TNJOBWORKLOCSB.REGION_2, TNJOBWORKLOCSB.REGION_3, TNJOBWORKLOCSTL.FA_LOCATION_NAME, TNJOBWORKLOCSTL.FULL_LOCATION_ADDRESS, TNJOBWORKLOCSB.OBJECT_VERSION_NUMBER, TNJOBWORKLOCSB.CREATED_BY, TNJOBWORKLOCSB.CREATION_DATE, TNJOBWORKLOCSB.LAST_UPDATED_BY, TNJOBWORKLOCSB.LAST_UPDATE_DATE, TNJOBWORKLOCSB.LAST_UPDATE_LOGIN FROM IRC_TN_JOB_WORK_LOCS_B TNJOBWORKLOCSB, IRC_TN_JOB_WORK_LOCS_TL TNJOBWORKLOCSTL WHERE TNJOBWORKLOCSB.TN_JOB_WORK_LOC_ID = TNJOBWORKLOCSTL.TN_JOB_WORK_LOC_ID AND TNJOBWORKLOCSTL.LANGUAGE = USERENV('LANG')