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

TABLE: IGF.IGF_AP_TODO_ALL

Object Details
Object Name: IGF_AP_TODO_ALL
Object Type: TABLE
Owner: IGF
FND Design Data: TableIGF.IGF_AP_TODO_ALL
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_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_AP_TODO_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnTODO_ID
Columns
Name Datatype Length Mandatory Comments
TODO_ID NUMBER (15) Yes Sequence Generated Column
PERSON_ID NUMBER (15)
Holds person ID
ACAD_CI_CAL_TYPE VARCHAR2 (10)
Holds the Academic Calendar's Instance
ACAD_CI_SEQUENCE_NUMBER NUMBER (15)
Holds the Academic Calendar's Instance
AWD_CI_CAL_TYPE VARCHAR2 (10)
Holds the Academic Calendar's Instance
AWD_CI_SEQUENCE_NUMBER NUMBER (15)
Holds the Academic Calendar's Instance
TODO_TYPE VARCHAR2 (30) Yes Holds the Todo Type
TODO_SUB_TYPE VARCHAR2 (30) Yes Holds todo sub-type
LOGICAL_DELETE DATE

Indicates whether the todo has been deleted or not
KEY1 VARCHAR2 (30)
Holds the key information for the different todo types
KEY2 VARCHAR2 (30)
Holds the key information for the different todo types
KEY3 VARCHAR2 (30)
Holds the key information for the different todo types
KEY4 VARCHAR2 (30)
Holds the key information for the different todo types
KEY5 VARCHAR2 (30)
Holds the key information for the different todo types
KEY6 VARCHAR2 (30)
Holds the key information for the different todo types
KEY7 VARCHAR2 (30)
Holds the key information for the different todo types
KEY8 VARCHAR2 (30)
Holds the key information for the different todo types
OLD_VALUE1 VARCHAR2 (255)
Holds the old value of Todo data attribute
NEW_VALUE1 VARCHAR2 (255)
Holds the new value of Todo data attribute
OLD_VALUE2 VARCHAR2 (255)
Holds the old value of Todo data attribute
NEW_VALUE2 VARCHAR2 (255)
Holds the new value of Todo data attribute
OLD_VALUE3 VARCHAR2 (255)
Holds the old value of Todo data attribute
NEW_VALUE3 VARCHAR2 (255)
Holds the new value of Todo data attribute
OLD_VALUE4 VARCHAR2 (255)
Holds the old value of Todo data attribute
NEW_VALUE4 VARCHAR2 (255)
Holds the new value of Todo data attribute
OLD_VALUE5 VARCHAR2 (255)
Holds the old value of Todo data attribute
NEW_VALUE5 VARCHAR2 (255)
Holds the new value of Todo data attribute
ORG_ID NUMBER (15)
Operating unit Identifier
CREATED_BY NUMBER (15) Yes Standard Who columns
CREATION_DATE DATE
Yes Standard Who columns
LAST_UPDATED_BY NUMBER (15) Yes Standard Who columns
LAST_UPDATE_DATE DATE
Yes Standard Who columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who columns
REQUEST_ID NUMBER (15)
Standard Who column for Concurrent Programs
PROGRAM_APPLICATION_ID NUMBER (15)
Standard Who column for Concurrent Programs
PROGRAM_ID NUMBER (15)
Standard Who column for Concurrent Programs
PROGRAM_UPDATE_DATE DATE

Standard Who column for Concurrent Programs
Query Text

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


SELECT TODO_ID
,      PERSON_ID
,      ACAD_CI_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      AWD_CI_CAL_TYPE
,      AWD_CI_SEQUENCE_NUMBER
,      TODO_TYPE
,      TODO_SUB_TYPE
,      LOGICAL_DELETE
,      KEY1
,      KEY2
,      KEY3
,      KEY4
,      KEY5
,      KEY6
,      KEY7
,      KEY8
,      OLD_VALUE1
,      NEW_VALUE1
,      OLD_VALUE2
,      NEW_VALUE2
,      OLD_VALUE3
,      NEW_VALUE3
,      OLD_VALUE4
,      NEW_VALUE4
,      OLD_VALUE5
,      NEW_VALUE5
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM IGF.IGF_AP_TODO_ALL;

Dependencies

[top of page]

IGF.IGF_AP_TODO_ALL does not reference any database object

IGF.IGF_AP_TODO_ALL is referenced by following:

SchemaAPPS
SynonymIGF_AP_TODO_ALL