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

TABLE: IGS.IGS_IN_INFTYP_PKG_IT

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


IGS_IN_INFTYP_PKG_IT describes the enquiry package items available to a particular information type, for example, fees information may be for a program or fees enquiry.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_IN_INFTYP_PKG_IT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnENQUIRY_INFORMATION_TYPE
ColumnENQUIRY_PACKAGE_ITEM
IGS_IN_INFTYP_PKG_IT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnENQUIRY_PACKAGE_ITEM
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
ENQUIRY_INFORMATION_TYPE VARCHAR2 (10) Yes The user-defined types of enquiry that are likely to be made. Examples are travel, accommodation, fees.
ENQUIRY_PACKAGE_ITEM VARCHAR2 (10) Yes Describes the correspondence, either system or non-system generated, hat is to be included in an enquiry package for a particular information type.
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
,      ENQUIRY_INFORMATION_TYPE
,      ENQUIRY_PACKAGE_ITEM
FROM IGS.IGS_IN_INFTYP_PKG_IT;

Dependencies

[top of page]

IGS.IGS_IN_INFTYP_PKG_IT does not reference any database object

IGS.IGS_IN_INFTYP_PKG_IT is referenced by following:

SchemaAPPS
SynonymIGS_IN_INFTYP_PKG_IT