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

TABLE: IGS.IGS_LOOKUPS_VAL

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


IGS_LOOKUPS_VAL has a foreign key relationship with FND_LOOKUPS_VAL. The join is based on the columns LOOKUP_TYPE and LOOKUP_CODE. The existing system tables from the original data model were merged into the FND_LOOKUPS table and the columns that could not be merged into FND_LOOKUPS table were consolidated into this table.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGS_LOOKUPS_VAL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLOOKUP_TYPE
ColumnLOOKUP_CODE
Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Yes QuickCode lookup type
LOOKUP_CODE VARCHAR2 (30) Yes QuickCode code
CLOSED_IND VARCHAR2 (1)
A flag for determining if the lookup type is closed.
SECURITY_ALLOWED_IND VARCHAR2 (1)
A flag to control if the lookup type has security allowed
STEP_TYPE_RESTRICTION_NUM_IND VARCHAR2 (1)
A flag to control the step type restriction number of the lookup type
UNIT_OUTCOME_IND VARCHAR2 (1)
A flag to control the unit outcome of a lookup type.
DISPLAY_NAME VARCHAR2 (30)
Displays name of the lookup type
DISPLAY_ORDER NUMBER (22)
Displays order of the lookup type
STEP_ORDER_APPLICABLE_IND VARCHAR2 (1)
A step order applicable flag for the lookup type.
ACADEMIC_TRANSCRIPT_IND VARCHAR2 (1)
A flag to indicate the academic transcript associated with the lookup type.
CMPLTN_REQUIREMENTS_IND VARCHAR2 (1)
A flag to indicate the completion requirements of a lookup type.
FEE_ASS_IND VARCHAR2 (1)
A flag to indicate the fee assessment of a lookup type.
STEP_GROUP_TYPE VARCHAR2 (10)
A step group type of a lookupt type
FINAL_RESULT_IND VARCHAR2 (1)
A flag that indicates the final result of the lookup type.
S_TRACKING_TYPE VARCHAR2 (30)
Obsolete
SYSTEM_GENERATED_IND VARCHAR2 (1)
A flag indicating if the lookup type is system generated.
TRANSACTION_CAT VARCHAR2 (10)
A transaction category of the lookup type
ENCUMBRANCE_LEVEL NUMBER (1)
The hold level of the lookup type
OPEN_FOR_ENROLLMENTS VARCHAR2 (1)
Indicates that the unit section is open for enrollments.
SYSTEM_CALCULATED VARCHAR2 (1)
Indicates that the unit section status code is system calculated
SYSTEM_MANDATORY_IND VARCHAR2 (1)
Indicator to designate whether the region is mandatory in the self service form
DEFAULT_DISPLAY_SEQ NUMBER (15)
Default display sequence for attributes for a region
TRACKING_USED_BY VARCHAR2 (30)
Obsolete
AV_TRANSCRIPT_DISP_OPTIONS VARCHAR2 (10)
This will have value if the Academic_Transcript_Ind is set to YES. It will have CPT,CPE,PUE for the respective options.
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
Query Text

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


SELECT LOOKUP_TYPE
,      LOOKUP_CODE
,      CLOSED_IND
,      SECURITY_ALLOWED_IND
,      STEP_TYPE_RESTRICTION_NUM_IND
,      UNIT_OUTCOME_IND
,      DISPLAY_NAME
,      DISPLAY_ORDER
,      STEP_ORDER_APPLICABLE_IND
,      ACADEMIC_TRANSCRIPT_IND
,      CMPLTN_REQUIREMENTS_IND
,      FEE_ASS_IND
,      STEP_GROUP_TYPE
,      FINAL_RESULT_IND
,      S_TRACKING_TYPE
,      SYSTEM_GENERATED_IND
,      TRANSACTION_CAT
,      ENCUMBRANCE_LEVEL
,      OPEN_FOR_ENROLLMENTS
,      SYSTEM_CALCULATED
,      SYSTEM_MANDATORY_IND
,      DEFAULT_DISPLAY_SEQ
,      TRACKING_USED_BY
,      AV_TRANSCRIPT_DISP_OPTIONS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGS.IGS_LOOKUPS_VAL;

Dependencies

[top of page]

IGS.IGS_LOOKUPS_VAL does not reference any database object

IGS.IGS_LOOKUPS_VAL is referenced by following:

SchemaAPPS
SynonymIGS_LOOKUPS_VAL