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

TABLE: IGS.IGS_IN_LVLTYP_PKG_IT

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


IGS_IN_LVLTYP_PKG_IT describes package items available to a particular level of enquiry for example, fees information may be relevant to a faculty, and institution level enquiry.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_IN_LVLTYP_PKG_IT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnS_ENQUIRY_LEVEL_TYPE
ColumnENQUIRY_PACKAGE_ITEM
IGS_IN_LVLTYP_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
S_ENQUIRY_LEVEL_TYPE VARCHAR2 (30) Yes The system-defined levels of enquiry. Examples are institution, organisational unit, discipline, course.
ENQUIRY_PACKAGE_ITEM VARCHAR2 (10) Yes Describes the correspondence, either system or non-system generated, that is to be included in an enquiry package for a particular level 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
,      S_ENQUIRY_LEVEL_TYPE
,      ENQUIRY_PACKAGE_ITEM
FROM IGS.IGS_IN_LVLTYP_PKG_IT;

Dependencies

[top of page]

IGS.IGS_IN_LVLTYP_PKG_IT does not reference any database object

IGS.IGS_IN_LVLTYP_PKG_IT is referenced by following:

SchemaAPPS
SynonymIGS_IN_LVLTYP_PKG_IT