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

TABLE: IGS.IGS_UC_OFFER_CONDS

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


This is the master table in the generic condition library . It holds the condition category and condition code , which is used to uniquely identify the offer condition and its attributes


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_UC_OFFER_CONDS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONDITION_CATEGORY
ColumnCONDITION_NAME
Columns
Name Datatype Length Mandatory Comments
CONDITION_CATEGORY VARCHAR2 (450) Yes Condition Category Name
CONDITION_NAME VARCHAR2 (450) Yes User friendly offer name
EFFECTIVE_FROM DATE
Yes Start date for condition
EFFECTIVE_TO DATE

End date for condition
STATUS VARCHAR2 (1) Yes Condition status (N - not tested , P- pending , A - passed , F- failed)
MARVIN_CODE VARCHAR2 (591)
Marvin coded offer
SUMM_OF_COND VARCHAR2 (6)
Summary of Conditions
CREATED_BY NUMBER (15) Yes Standard WHO columns
CREATION_DATE DATE
Yes Standard WHO columns
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO columns
LAST_UPDATE_DATE DATE
Yes Standard WHO columns
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO columns
LETTER_TEXT LONG (0)
Text format of the letter generated by this offer
DECISION VARCHAR2 (1) Yes UCAS Decision
Query Text

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


SELECT CONDITION_CATEGORY
,      CONDITION_NAME
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      STATUS
,      MARVIN_CODE
,      SUMM_OF_COND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LETTER_TEXT
,      DECISION
FROM IGS.IGS_UC_OFFER_CONDS;

Dependencies

[top of page]

IGS.IGS_UC_OFFER_CONDS does not reference any database object

IGS.IGS_UC_OFFER_CONDS is referenced by following:

SchemaAPPS
SynonymIGS_UC_OFFER_CONDS