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

TABLE: IGI.IGI_EXP_JOBS_ACTIONS

Object Details
Object Name: IGI_EXP_JOBS_ACTIONS
Object Type: TABLE
Owner: IGI
FND Design Data: TableIGI.IGI_EXP_JOBS_ACTIONS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGI_EXP_JOB_ACTIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnJOB_ID
Columns
Name Datatype Length Mandatory Comments
JOB_ID NUMBER
Yes Human resources job identifier
CREATE_DOC VARCHAR2 (25)
Reserved for enhancement
APPROVE VARCHAR2 (25)
Reserved for enhancement
REJECT VARCHAR2 (25)
Reserved for enhancement
HOLD VARCHAR2 (25)
Reserved for enhancement
PEC VARCHAR2 (25)
Reserved for enhancement
REQUISITION VARCHAR2 (25)
Reserved for enhancement
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER

Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
Query Text

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


SELECT JOB_ID
,      CREATE_DOC
,      APPROVE
,      REJECT
,      HOLD
,      PEC
,      REQUISITION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM IGI.IGI_EXP_JOBS_ACTIONS;

Dependencies

[top of page]

IGI.IGI_EXP_JOBS_ACTIONS does not reference any database object

IGI.IGI_EXP_JOBS_ACTIONS is referenced by following:

SchemaAPPS
SynonymIGI_EXP_JOBS_ACTIONS