[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_LOOKUPS_VAL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_LOOKUPS_VAL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 LOOKUP_TYPE
LOOKUP_CODE
|
| 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 |
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;
IGS.IGS_LOOKUPS_VAL does not reference any database object
IGS.IGS_LOOKUPS_VAL is referenced by following:
APPS
IGS_LOOKUPS_VAL
|
|
|
|