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

VIEW: APPS.IGF_AP_APPL_SETUP_V

Object Details
Object Name: IGF_AP_APPL_SETUP_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_AP_APPL_SETUP_V
Subobject Name:
Status: VALID

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
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
APPLICATION_CODE VARCHAR2 (30)
Institutional Application Code
APPLICATION_NAME VARCHAR2 (80)
Institutional Application Name
ACTIVE_FLAG VARCHAR2 (1)
Indicator for Active Institutional Application
Query Text

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


SELECT ORG_ID
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      START_DT
,      END_DT
,      AWARD_YEAR
,      APPLICATION_CODE
,      APPLICATION_NAME
,      ACTIVE_FLAG
FROM APPS.IGF_AP_APPL_SETUP_V;

Dependencies

[top of page]

APPS.IGF_AP_APPL_SETUP_V references the following:

SchemaAPPS
ViewIGF_AP_APPL_SETUP
ViewIGS_CA_INST

APPS.IGF_AP_APPL_SETUP_V is not referenced by any database object