VIEW: APPS.IGF_SE_EXT_JOB

Source

View Text - Preformatted

SELECT SEJ.ROWID ROW_ID , SEJ.ORG_UNIT_CD, SEJ.JOB_CODE, SEJ.DESCRIPTION, SEJ.WORK_LOC, SEJ.CLOSED_IND, SEJ.WORK_LOC_DEV, SEJ.TELEPHONE_NO, SEJ.PAYRANGE_FROM, SEJ.PAYRANGE_TO, SEJ.WORK_START_DATE, SEJ.JOB_PURPOSE, SEJ.PAIDBY_CAMPUS_EMP, SEJ.HELP_AMERICA_READ, SEJ.COMMON_SERVICE, SEJ.CAREER_OBJECTIVE, SEJ.JOB_SKILLS, SEJ.ORG_ID, SEJ.CREATED_BY , SEJ.CREATION_DATE , SEJ.LAST_UPDATED_BY, SEJ.LAST_UPDATE_DATE, SEJ.LAST_UPDATE_LOGIN , SEJ.SUPERVISOR_CONTACT FROM IGF_SE_EXT_JOB_ALL SEJ WHERE NVL (SEJ.org_id , NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' ',NULL,SUBSTRB(USERENV('CLIENT_INFO'),1,10))),-99)

View Text - HTML Formatted

SELECT SEJ.ROWID ROW_ID
, SEJ.ORG_UNIT_CD
, SEJ.JOB_CODE
, SEJ.DESCRIPTION
, SEJ.WORK_LOC
, SEJ.CLOSED_IND
, SEJ.WORK_LOC_DEV
, SEJ.TELEPHONE_NO
, SEJ.PAYRANGE_FROM
, SEJ.PAYRANGE_TO
, SEJ.WORK_START_DATE
, SEJ.JOB_PURPOSE
, SEJ.PAIDBY_CAMPUS_EMP
, SEJ.HELP_AMERICA_READ
, SEJ.COMMON_SERVICE
, SEJ.CAREER_OBJECTIVE
, SEJ.JOB_SKILLS
, SEJ.ORG_ID
, SEJ.CREATED_BY
, SEJ.CREATION_DATE
, SEJ.LAST_UPDATED_BY
, SEJ.LAST_UPDATE_DATE
, SEJ.LAST_UPDATE_LOGIN
, SEJ.SUPERVISOR_CONTACT
FROM IGF_SE_EXT_JOB_ALL SEJ
WHERE NVL (SEJ.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)