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

TABLE: IGS.IGS_FI_WAV_PR_PREQS

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


Stores the Pre-requisite Waiver Programs for a given Waiver Program and Fee Period.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_FI_WAV_PR_PREQS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWAIVER_RELATION_ID
IGS_FI_WAV_PR_PREQS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnFEE_CAL_TYPE
ColumnFEE_CI_SEQUENCE_NUMBER
ColumnSUB_WAIVER_NAME
ColumnSUP_WAIVER_NAME
Columns
Name Datatype Length Mandatory Comments
WAIVER_RELATION_ID NUMBER
Yes Sequence-generated Waiver Relationship Identifier.
OBJECT_VERSION_NUMBER NUMBER
Yes This column is used for locking rows in the database
FEE_CAL_TYPE VARCHAR2 (10) Yes Fee Calendar Type
FEE_CI_SEQUENCE_NUMBER NUMBER (6) Yes Fee Calendar Instance Sequence Number
SUP_WAIVER_NAME VARCHAR2 (30) Yes Pre-requisite Waiver Program for the given Waiver Program and Fee Period.
SUB_WAIVER_NAME VARCHAR2 (30) Yes Waiver Program for the given Fee Period.
CREATED_BY NUMBER (15) Yes Standard Who Column
CREATION_DATE DATE
Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

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


SELECT WAIVER_RELATION_ID
,      OBJECT_VERSION_NUMBER
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      SUP_WAIVER_NAME
,      SUB_WAIVER_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_FI_WAV_PR_PREQS;

Dependencies

[top of page]

IGS.IGS_FI_WAV_PR_PREQS does not reference any database object

IGS.IGS_FI_WAV_PR_PREQS is referenced by following:

SchemaAPPS
SynonymIGS_FI_WAV_PR_PREQS