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

TABLE: IGF.IGF_AP_TD_ITEM_TYPE_ALL_OLD

Object Details
Object Name: IGF_AP_TD_ITEM_TYPE_ALL_OLD
Object Type: TABLE
Owner: IGF
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_AP_TD_ITEM_TYPE_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnITEM_SEQUENCE_NUMBER
IGF_AP_TD_ITEM_TYPE_ALL_U2 NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnTODO_NUMBER
ColumnCI_CAL_TYPE
ColumnCI_SEQUENCE_NUMBER
ColumnGROUP_CODE
Columns
Name Datatype Length Mandatory Comments
ITEM_SEQUENCE_NUMBER NUMBER (15) Yes
CI_CAL_TYPE VARCHAR2 (10) Yes
TODO_NUMBER NUMBER (15) Yes
CI_SEQUENCE_NUMBER NUMBER (15) Yes
ITEM_CODE VARCHAR2 (30)
GROUP_CODE VARCHAR2 (10) Yes
DESCRIPTION VARCHAR2 (30)
CORSP_MESG VARCHAR2 (240)
FREQ_ATTEMPT NUMBER (15)
MAX_ATTEMPT NUMBER (15)
REQUIRED_FOR_APPLICATION VARCHAR2 (30)
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)
ORG_ID NUMBER (15)
Query Text

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


SELECT ITEM_SEQUENCE_NUMBER
,      CI_CAL_TYPE
,      TODO_NUMBER
,      CI_SEQUENCE_NUMBER
,      ITEM_CODE
,      GROUP_CODE
,      DESCRIPTION
,      CORSP_MESG
,      FREQ_ATTEMPT
,      MAX_ATTEMPT
,      REQUIRED_FOR_APPLICATION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
FROM IGF.IGF_AP_TD_ITEM_TYPE_ALL_OLD;

Dependencies

[top of page]

IGF.IGF_AP_TD_ITEM_TYPE_ALL_OLD does not reference any database object

IGF.IGF_AP_TD_ITEM_TYPE_ALL_OLD is referenced by following:

SchemaAPPS
SynonymIGF_AP_TD_ITEM_TYPE_ALL_OLD