[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_LOOKUPS_IND |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_LOOKUPS_IND
|
| Subobject Name: | |
| Status: | VALID |
IGS_LOOKUPS_IND has a foreign key relationship with FND_LOOKUPS_TYPE. The join is based on the column LOOKUP_TYPE. The existing system tables from the original data model were merged into the FND_LOOKUPS table. The columns that are mandatory fields for a particular Lookup Type are indicated in this table.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_LOOKUPS_IND_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 LOOKUP_TYPE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LOOKUP_TYPE | VARCHAR2 | (30) | Yes | QuickCode lookup type |
| SECURITY_ALLOWED_IND | VARCHAR2 | (1) | Yes | A flag that indicates the security allowed details of a lookup type. |
| STEP_TYPE_RESTRICTION_NUM_IND | VARCHAR2 | (1) | Yes | This is the step type restriction number flag of a lookup type. |
| UNIT_OUTCOME_IND | VARCHAR2 | (1) | Yes | This is the unit outcome flag of the lookup type. |
| DISPLAY_NAME_IND | VARCHAR2 | (1) | Yes | Displays name flag of a lookup type. |
| DISPLAY_ORDER_IND | VARCHAR2 | (1) | Yes | Displays order flag of a lookup type |
| STEP_ORDER_APPLICABLE_IND | VARCHAR2 | (1) | Yes | This is the step order applicable flag of a lookup type |
| ACADEMIC_TRANSCRIPT_IND | VARCHAR2 | (1) | Yes | This is the academic transcript flag of a lookup type. |
| CMPLTN_REQUIREMENTS_IND | VARCHAR2 | (1) | Yes | A flag that indicates the completion requirements of a lookup type. |
| FEE_AS_IND | VARCHAR2 | (1) | Yes | A flag which indicates the fee assessment of a lookup type. |
| STEP_GROUP_TYPE_IND | VARCHAR2 | (1) | Yes | Flag that indicates the step group type of the lookup type |
| FINAL_RESULT_IND | VARCHAR2 | (1) | Yes | A flag that indicates the final result of a lookup type. |
| S_TRACKING_TYPE_IND | VARCHAR2 | (1) | Obsolete | |
| SYSTEM_GENERATED_IND | VARCHAR2 | (1) | Yes | A flag which indicates whether the lookup type is system generated. |
| TRANSACTION_CAT_IND | VARCHAR2 | (1) | Yes | A flag that indicates the transaction category of a lookup type. |
| ENCUMBRANCE_LEVEL_IND | VARCHAR2 | (1) | Yes | A flag that indicates the hold level of the lookup type. |
| OPEN_FOR_ENROLLMENTS_IND | VARCHAR2 | (1) | Yes | A flag to indicate that the unit section is open for enrollments. |
| SYSTEM_CALCULATED_IND | VARCHAR2 | (1) | Yes | A flag to indicate that the unit section status code is system calculated. |
| SYSTEM_MANDATORY_IND | VARCHAR2 | (1) | Indicates the column usage for the given lookup type | |
| DEFAULT_DISPLAY_SEQ_IND | VARCHAR2 | (1) | Indicates the column usage for the given lookup type | |
| TRACKING_USED_BY_IND | VARCHAR2 | (1) | Obsolete | |
| AV_TRANSCRIPT_DISP_OPTIONS_IND | VARCHAR2 | (1) | 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
, SECURITY_ALLOWED_IND
, STEP_TYPE_RESTRICTION_NUM_IND
, UNIT_OUTCOME_IND
, DISPLAY_NAME_IND
, DISPLAY_ORDER_IND
, STEP_ORDER_APPLICABLE_IND
, ACADEMIC_TRANSCRIPT_IND
, CMPLTN_REQUIREMENTS_IND
, FEE_AS_IND
, STEP_GROUP_TYPE_IND
, FINAL_RESULT_IND
, S_TRACKING_TYPE_IND
, SYSTEM_GENERATED_IND
, TRANSACTION_CAT_IND
, ENCUMBRANCE_LEVEL_IND
, OPEN_FOR_ENROLLMENTS_IND
, SYSTEM_CALCULATED_IND
, SYSTEM_MANDATORY_IND
, DEFAULT_DISPLAY_SEQ_IND
, TRACKING_USED_BY_IND
, AV_TRANSCRIPT_DISP_OPTIONS_IND
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGS.IGS_LOOKUPS_IND;
IGS.IGS_LOOKUPS_IND does not reference any database object
IGS.IGS_LOOKUPS_IND is referenced by following:
APPS
IGS_LOOKUPS_IND
|
|
|
|