IRC_TN_JOBS

Details

Schema: FUSION
Object owner: IRC
Object type: VIEW

Columns

Name
TN_JOB_ID SUBSCRIBER_ID STATUS FA_REQUISITION_ID FA_REQUISITION_NUMBER FA_REQ_LAST_MODIFIED_DATE JOB_NUMBER FA_JOB_TYPE_CODE FA_JOB_SHIFT_CODE WORK_START_DATE WORK_END_DATE MIN_SALARY MAX_SALARY SALARY_CURRENCY_CODE STANDARD_WORKING_HOURS NAT_TRAVEL_REQUIRED_FLAG INTL_TRAVEL_REQUIRED_FLAG HOT_JOB_FLAG NUMBER_TO_HIRE UNLIMITED_HIRE_FLAG TITLE EXTERNAL_DESC EXTERNAL_DESC_HTML EXTERNAL_SHORT_DESC EXTERNAL_RESP EXTERNAL_RESP_HTML EXTERNAL_QUAL EXTERNAL_QUAL_HTML EXT_EMPLOYER_DESC EXT_ORGANIZATION_DESC FULL_PART_TIME_MEANING SALARY_FREQUENCY_MEANING SALARY_CURRENCY_MEANING ORGANIZATION_NAME JOB_FAMILY_NAME JOB_FUNCTION_MEANING REGULAR_TEMPORARY_MEANING WORKPLACE_TYPE_MEANING TRAVEL_FREQUENCY_MEANING WORK_HOURS_MEANING WORK_DAYS_MEANING STANDARD_WORKING_FREQ_MEANING OVERTIME_STATUS_MEANING OBJECT_STATUS OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

TN_JOB_ID

SUBSCRIBER_ID

STATUS

FA_REQUISITION_ID

FA_REQUISITION_NUMBER

FA_REQ_LAST_MODIFIED_DATE

JOB_NUMBER

FA_JOB_TYPE_CODE

FA_JOB_SHIFT_CODE

WORK_START_DATE

WORK_END_DATE

MIN_SALARY

MAX_SALARY

SALARY_CURRENCY_CODE

STANDARD_WORKING_HOURS

NAT_TRAVEL_REQUIRED_FLAG

INTL_TRAVEL_REQUIRED_FLAG

HOT_JOB_FLAG

NUMBER_TO_HIRE

UNLIMITED_HIRE_FLAG

TITLE

EXTERNAL_DESC

EXTERNAL_DESC_HTML

EXTERNAL_SHORT_DESC

EXTERNAL_RESP

EXTERNAL_RESP_HTML

EXTERNAL_QUAL

EXTERNAL_QUAL_HTML

EXT_EMPLOYER_DESC

EXT_ORGANIZATION_DESC

FULL_PART_TIME_MEANING

SALARY_FREQUENCY_MEANING

SALARY_CURRENCY_MEANING

ORGANIZATION_NAME

JOB_FAMILY_NAME

JOB_FUNCTION_MEANING

REGULAR_TEMPORARY_MEANING

WORKPLACE_TYPE_MEANING

TRAVEL_FREQUENCY_MEANING

WORK_HOURS_MEANING

WORK_DAYS_MEANING

STANDARD_WORKING_FREQ_MEANING

OVERTIME_STATUS_MEANING

OBJECT_STATUS

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT TNJOBSB.TN_JOB_ID, TNJOBSB.SUBSCRIBER_ID, TNJOBSB.STATUS, TNJOBSB.FA_REQUISITION_ID, TNJOBSB.FA_REQUISITION_NUMBER, TNJOBSB.FA_REQ_LAST_MODIFIED_DATE, TNJOBSB.JOB_NUMBER, TNJOBSB.FA_JOB_TYPE_CODE, TNJOBSB.FA_JOB_SHIFT_CODE, TNJOBSB.WORK_START_DATE, TNJOBSB.WORK_END_DATE, TNJOBSB.MIN_SALARY, TNJOBSB.MAX_SALARY, TNJOBSB.SALARY_CURRENCY_CODE, TNJOBSB.STANDARD_WORKING_HOURS, TNJOBSB.NAT_TRAVEL_REQUIRED_FLAG, TNJOBSB.INTL_TRAVEL_REQUIRED_FLAG, TNJOBSB.HOT_JOB_FLAG, TNJOBSB.NUMBER_TO_HIRE, TNJOBSB.UNLIMITED_HIRE_FLAG, TNJOBSTL.TITLE, TNJOBSTL.EXTERNAL_DESC, TNJOBSTL.EXTERNAL_DESC_HTML, TNJOBSTL.EXTERNAL_SHORT_DESC, TNJOBSTL.EXTERNAL_RESP, TNJOBSTL.EXTERNAL_RESP_HTML, TNJOBSTL.EXTERNAL_QUAL, TNJOBSTL.EXTERNAL_QUAL_HTML, TNJOBSTL.EXT_EMPLOYER_DESC, TNJOBSTL.EXT_ORGANIZATION_DESC, TNJOBSTL.FULL_PART_TIME_MEANING, TNJOBSTL.SALARY_FREQUENCY_MEANING, TNJOBSTL.SALARY_CURRENCY_MEANING, TNJOBSTL.ORGANIZATION_NAME, TNJOBSTL.JOB_FAMILY_NAME, TNJOBSTL.JOB_FUNCTION_MEANING, TNJOBSTL.REGULAR_TEMPORARY_MEANING, TNJOBSTL.WORKPLACE_TYPE_MEANING, TNJOBSTL.TRAVEL_FREQUENCY_MEANING, TNJOBSTL.WORK_HOURS_MEANING, TNJOBSTL.WORK_DAYS_MEANING, TNJOBSTL.STANDARD_WORKING_FREQ_MEANING, TNJOBSTL.OVERTIME_STATUS_MEANING, TNJOBSB.OBJECT_STATUS, TNJOBSB.OBJECT_VERSION_NUMBER, TNJOBSB.CREATED_BY, TNJOBSB.CREATION_DATE, TNJOBSB.LAST_UPDATED_BY, TNJOBSB.LAST_UPDATE_DATE, TNJOBSB.LAST_UPDATE_LOGIN FROM IRC_TN_JOBS_B TNJOBSB, IRC_TN_JOBS_TL TNJOBSTL WHERE TNJOBSB.TN_JOB_ID = TNJOBSTL.TN_JOB_ID AND TNJOBSTL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

TNJOBSB.TN_JOB_ID,

TNJOBSB.SUBSCRIBER_ID,

TNJOBSB.STATUS,

TNJOBSB.FA_REQUISITION_ID,

TNJOBSB.FA_REQUISITION_NUMBER,

TNJOBSB.FA_REQ_LAST_MODIFIED_DATE,

TNJOBSB.JOB_NUMBER,

TNJOBSB.FA_JOB_TYPE_CODE,

TNJOBSB.FA_JOB_SHIFT_CODE,

TNJOBSB.WORK_START_DATE,

TNJOBSB.WORK_END_DATE,

TNJOBSB.MIN_SALARY,

TNJOBSB.MAX_SALARY,

TNJOBSB.SALARY_CURRENCY_CODE,

TNJOBSB.STANDARD_WORKING_HOURS,

TNJOBSB.NAT_TRAVEL_REQUIRED_FLAG,

TNJOBSB.INTL_TRAVEL_REQUIRED_FLAG,

TNJOBSB.HOT_JOB_FLAG,

TNJOBSB.NUMBER_TO_HIRE,

TNJOBSB.UNLIMITED_HIRE_FLAG,

TNJOBSTL.TITLE,

TNJOBSTL.EXTERNAL_DESC,

TNJOBSTL.EXTERNAL_DESC_HTML,

TNJOBSTL.EXTERNAL_SHORT_DESC,

TNJOBSTL.EXTERNAL_RESP,

TNJOBSTL.EXTERNAL_RESP_HTML,

TNJOBSTL.EXTERNAL_QUAL,

TNJOBSTL.EXTERNAL_QUAL_HTML,

TNJOBSTL.EXT_EMPLOYER_DESC,

TNJOBSTL.EXT_ORGANIZATION_DESC,

TNJOBSTL.FULL_PART_TIME_MEANING,

TNJOBSTL.SALARY_FREQUENCY_MEANING,

TNJOBSTL.SALARY_CURRENCY_MEANING,

TNJOBSTL.ORGANIZATION_NAME,

TNJOBSTL.JOB_FAMILY_NAME,

TNJOBSTL.JOB_FUNCTION_MEANING,

TNJOBSTL.REGULAR_TEMPORARY_MEANING,

TNJOBSTL.WORKPLACE_TYPE_MEANING,

TNJOBSTL.TRAVEL_FREQUENCY_MEANING,

TNJOBSTL.WORK_HOURS_MEANING,

TNJOBSTL.WORK_DAYS_MEANING,

TNJOBSTL.STANDARD_WORKING_FREQ_MEANING,

TNJOBSTL.OVERTIME_STATUS_MEANING,

TNJOBSB.OBJECT_STATUS,

TNJOBSB.OBJECT_VERSION_NUMBER,

TNJOBSB.CREATED_BY,

TNJOBSB.CREATION_DATE,

TNJOBSB.LAST_UPDATED_BY,

TNJOBSB.LAST_UPDATE_DATE,

TNJOBSB.LAST_UPDATE_LOGIN

FROM

IRC_TN_JOBS_B TNJOBSB,

IRC_TN_JOBS_TL TNJOBSTL

WHERE

TNJOBSB.TN_JOB_ID = TNJOBSTL.TN_JOB_ID AND TNJOBSTL.LANGUAGE = USERENV('LANG')