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

TABLE: IGS.IGS_IN_APPLINFO_TYPE

Object Details
Object Name: IGS_IN_APPLINFO_TYPE
Object Type: TABLE
Owner: IGS
FND Design Data: TableIGS.IGS_IN_APPLINFO_TYPE
Subobject Name:
Status: VALID


IGS_IN_APPLINFO_TYPE describes the types of information requested with an enquiry - Obsolete


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_IN_APPLINFO_TYPE_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPERSON_ID
ColumnENQUIRY_APPL_NUMBER
ColumnENQUIRY_INFORMATION_TYPE
IGS_IN_APPLINFO_TYPE_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENQUIRY_INFORMATION_TYPE
Columns
Name Datatype Length Mandatory Comments
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
PERSON_ID NUMBER (15) Yes Describes the ID code that uniquely identifies a person
ENQUIRY_APPL_NUMBER NUMBER (7) Yes Number identifying the enquiry made by a person
ENQUIRY_INFORMATION_TYPE VARCHAR2 (10) Yes Describes the user-defined types of enquiry that are likely to be made. For exxample, travel, accommodation, fees.
Query Text

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


SELECT CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PERSON_ID
,      ENQUIRY_APPL_NUMBER
,      ENQUIRY_INFORMATION_TYPE
FROM IGS.IGS_IN_APPLINFO_TYPE;

Dependencies

[top of page]

IGS.IGS_IN_APPLINFO_TYPE does not reference any database object

IGS.IGS_IN_APPLINFO_TYPE is referenced by following:

SchemaAPPS
SynonymIGS_IN_APPLINFO_TYPE