[Home] [Help] [Dependency Information]
Object Name: | IGF_AP_APPL_SETUPDTL_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_AP_APPL_SETUPDTL_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Shows the database row id | |
QUESTION_ID | NUMBER | (15) | Yes | Identifier for question |
QUESTION | VARCHAR2 | (200) | Yes | Question defined in the application |
ENABLED | VARCHAR2 | (1) | Yes | Flag tells about whether the corresponding question is enabled or not |
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 |
START_DT | DATE | Yes | Start date of the current award year | |
END_DT | DATE | Yes | End date of the current award year | |
AWARD_YEAR | VARCHAR2 | (10) | Current award year | |
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 | |
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 | |
ANSWER_TYPE_DESC | VARCHAR2 | (4000) | Answer Type Description | |
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_DESC | VARCHAR2 | (4000) | All Terms Flag Description | |
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
, START_DT
, END_DT
, AWARD_YEAR
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, APPLICATION_CODE
, APPLICATION_NAME
, ACTIVE_FLAG
, ANSWER_TYPE_CODE
, ANSWER_TYPE_DESC
, DESTINATION_TXT
, LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
, ALL_TERMS_DESC
, 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_SETUPDTL_V;
APPS.IGF_AP_APPL_SETUPDTL_V is not referenced by any database object
|
|
|