[Home] [Help] [Dependency Information]
Object Name: | IGS_GE_JOB_TEXT_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_GE_JOB_TEXT_ALL |
Subobject Name: | |
Status: | VALID |
IGS_GE_JOB_TEXT_ALL describes the job text used within reports on the system. Users may enter 'standard' text that is selected at the point of running reports through the job scheduler processing.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_GE_JOB_TEXT_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SEQUENCE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQUENCE_NUMBER | NUMBER | (6) | Yes | Identifies each and every row uniquely. It contains sequence generated data. |
JOB_EXECUTION_NAME | VARCHAR2 | (100) | Yes | Describes the job that can be selected at the point of running reports through the job scheduler processing |
DESCRIPTION | VARCHAR2 | (60) | Yes | Contains meaning of a job execution name |
TEXT | VARCHAR2 | (2000) | Yes | Contains notes for the description of a job execution |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ORG_ID | NUMBER | (15) | Operating unit identifier |
Cut, paste (and edit) the following text to query this object:
SELECT SEQUENCE_NUMBER
, JOB_EXECUTION_NAME
, DESCRIPTION
, TEXT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
FROM IGS.IGS_GE_JOB_TEXT_ALL;
IGS.IGS_GE_JOB_TEXT_ALL does not reference any database object
IGS.IGS_GE_JOB_TEXT_ALL is referenced by following:
|
|
|