[Home] [Help] [Dependency Information]
Object Name: | IGF_AP_APPL_SETUP |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_AP_APPL_SETUP |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
QUESTION_ID | NUMBER | (15) | Yes | |
QUESTION | VARCHAR2 | (200) | Yes | |
ENABLED | VARCHAR2 | (1) | Yes | |
ORG_ID | NUMBER | (15) | The code for the organizational unit. An organizational unit isuniquely identified by the combination of its code and start date.An organizational unit is a business unit of an institution ororganization. Common organizational units in tertiary institutions arefaculties, schools, departments and divisions. Each organizational unit must be assigned a start date, description, status,organizational type and member type. An institution code may be assigned to an organizational unit | |
CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Indicates the code for the award year calender type, used within the operating unit |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Indicates a unique identifier for the award year calender instance |
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
APPLICATION_CODE | VARCHAR2 | (30) | Identifier for an Application | |
APPLICATION_NAME | VARCHAR2 | (80) | The descriptive name for an application code | |
ACTIVE_FLAG | VARCHAR2 | (1) | To Enable and Disable the Application | |
ANSWER_TYPE_CODE | VARCHAR2 | (30) | Determines the type of response against the question | |
DESTINATION_TXT | VARCHAR2 | (80) | Determines the anticipated data to be populated by the response | |
LD_CAL_TYPE | VARCHAR2 | (10) | Calendar Type of the Term (Determine the Term for which the anticipated data need to be updated) | |
LD_SEQUENCE_NUMBER | NUMBER | Calendar Sequence Number of the Term | ||
ALL_TERMS_FLAG | VARCHAR2 | (1) | Indicator for all terms selected for anticipated data | |
OVERRIDE_EXIST_ANT_DATA_FLAG | VARCHAR2 | (1) | Indicator to update the anticipated data | |
REQUIRED_FLAG | VARCHAR2 | (1) | Marks the question as mandatory to answer | |
MINIMUM_VALUE_NUM | NUMBER | (30) | Minimum value for a range of value | |
MAXIMUM_VALUE_NUM | NUMBER | (30) | Maximum value for a range of values | |
MINIMUM_DATE | DATE | Minimum date for a range of dates | ||
MAXIMIUM_DATE | DATE | Maximum date for a range of dates | ||
LOOKUP_CODE | VARCHAR2 | (30) | User defined lookup to be used. | |
HINT_TXT | VARCHAR2 | (30) | Hint text provided to the answer of the question |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, QUESTION_ID
, QUESTION
, ENABLED
, ORG_ID
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, APPLICATION_CODE
, APPLICATION_NAME
, ACTIVE_FLAG
, ANSWER_TYPE_CODE
, DESTINATION_TXT
, LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
, ALL_TERMS_FLAG
, OVERRIDE_EXIST_ANT_DATA_FLAG
, REQUIRED_FLAG
, MINIMUM_VALUE_NUM
, MAXIMUM_VALUE_NUM
, MINIMUM_DATE
, MAXIMIUM_DATE
, LOOKUP_CODE
, HINT_TXT
FROM APPS.IGF_AP_APPL_SETUP;
|
|
|