eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.IGF_SE_EXT_JOB

Object Details

Object Name:	IGF_SE_EXT_JOB
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

This entity is primarily designed to hold the details of the jobs with the organizations external to the system. However there is no limitation on entering internal jobs details. The member type attribute of the organization will determine whether the job belongs to an internal or an external organization. This is an MO view for the table.

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
ORG_UNIT_CD	VARCHAR2	(30)	Yes
JOB_CODE	VARCHAR2	(15)	Yes
DESCRIPTION	VARCHAR2	(100)	Yes
WORK_LOC	VARCHAR2	(200)
CLOSED_IND	VARCHAR2	(1)	Yes
WORK_LOC_DEV	VARCHAR2	(1)
TELEPHONE_NO	VARCHAR2	(20)
PAYRANGE_FROM	NUMBER	(12)
PAYRANGE_TO	NUMBER	(12)
WORK_START_DATE	DATE
JOB_PURPOSE	VARCHAR2	(1000)
PAIDBY_CAMPUS_EMP	VARCHAR2	(1)
HELP_AMERICA_READ	VARCHAR2	(1)
COMMON_SERVICE	VARCHAR2	(1)
CAREER_OBJECTIVE	VARCHAR2	(1000)
JOB_SKILLS	VARCHAR2	(1000)
ORG_ID	NUMBER	(15)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
SUPERVISOR_CONTACT	VARCHAR2	(80)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      ORG_UNIT_CD
,      JOB_CODE
,      DESCRIPTION
,      WORK_LOC
,      CLOSED_IND
,      WORK_LOC_DEV
,      TELEPHONE_NO
,      PAYRANGE_FROM
,      PAYRANGE_TO
,      WORK_START_DATE
,      JOB_PURPOSE
,      PAIDBY_CAMPUS_EMP
,      HELP_AMERICA_READ
,      COMMON_SERVICE
,      CAREER_OBJECTIVE
,      JOB_SKILLS
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SUPERVISOR_CONTACT
FROM APPS.IGF_SE_EXT_JOB;

Dependencies

[top of page]

APPS.IGF_SE_EXT_JOB references the following:

APPS: IGF_SE_EXT_JOB_ALL

APPS.IGF_SE_EXT_JOB is not referenced by any database object