IRC_MP_GIGS_VL

Details

• Schema: FUSION

• Object owner: IRC

• Object type: VIEW

Columns

Name

GIG_ID GIG_NUMBER CREATOR_PERSON_ID GEOGRAPHY_NODE_ID START_DATE END_DATE PUBLISH_DATE TIME_COMMITMENT STATUS_CODE ORGANIZATION_ID REMOTE_OPPORTUNITY_FLAG OBJECT_STATUS CLASSIFY_ORG_ID CLASSIFY_BU_ID CLASSIFY_JOB_FAMILY_ID CLASSIFY_JOB_FUNC_CODE GIG_MANAGER_PERSON_ID TITLE DESCRIPTION SUMMARY IDEAL_PERSON_DESCRIPTION OBJECT_VERSION_NUMBER CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN PROFILE_ID OPENINGS_COUNT FILLED_COUNT

Query

SQL_Statement

SELECT B.GIG_ID GIG_ID, B.GIG_NUMBER GIG_NUMBER, B.CREATOR_PERSON_ID CREATOR_PERSON_ID, B.GEOGRAPHY_NODE_ID GEOGRAPHY_NODE_ID, B.START_DATE START_DATE, B.END_DATE END_DATE, B.PUBLISH_DATE PUBLISH_DATE, B.TIME_COMMITMENT TIME_COMMITMENT, B.STATUS_CODE STATUS_CODE, B.ORGANIZATION_ID ORGANIZATION_ID, B.REMOTE_OPPORTUNITY_FLAG REMOTE_OPPORTUNITY_FLAG, B.OBJECT_STATUS OBJECT_STATUS, B.CLASSIFY_ORG_ID CLASSIFY_ORG_ID, B.CLASSIFY_BU_ID CLASSIFY_BU_ID, B.CLASSIFY_JOB_FAMILY_ID CLASSIFY_JOB_FAMILY_ID, B.CLASSIFY_JOB_FUNC_CODE CLASSIFY_JOB_FUNC_CODE, B.GIG_MANAGER_PERSON_ID GIG_MANAGER_PERSON_ID, TL.TITLE TITLE, TL.DESCRIPTION DESCRIPTION, TL.SUMMARY SUMMARY, TL.IDEAL_PERSON_DESCRIPTION, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, B.PROFILE_ID, B.OPENINGS_COUNT, B.FILLED_COUNT FROM IRC_MP_GIGS_B B, IRC_MP_GIGS_TL TL WHERE B.GIG_ID = TL.GIG_ID AND TL.LANGUAGE = USERENV('LANG')