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

VIEW: APPS.IGS_OR_UNIT_HIST_V

Object Details
Object Name: IGS_OR_UNIT_HIST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_OR_UNIT_HIST_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_UNIT_CD VARCHAR2 (30)
The code for the organisational unit. An organisational unit is uniquely identified by the combination of its code and start date. An organisational unit is a business unit of an institution or organisation. Common organisational units in tertiary institutions are faculties, schools, departments and divisions. Each organisational unit must be assigned a start date, description, status, organisational type and member type.
OU_START_DT DATE

The date from which the organisational unit is effective. The organisational unit is uniquely identified by the combination of its code and start date.
HIST_START_DT DATE

The effective start date/time of the organisational unit history record. It is the date/time the previous history record was ended.
HIST_END_DT DATE

The effective end date/time of the organisational unit history record. It is the date/time the subsequent history record was created.
HIST_WHO NUMBER (15)
The Oracle username of the person who created the history record.
END_DT DATE

DESCRIPTION VARCHAR2 (4000)
The description of the organisational unit during the currency of the history record. There will be a value in this field only if the description was changed when the subsequent record was created.
ORG_STATUS VARCHAR2 (4000)
The status of the organisational unit during the currency of the history record. There will be a value in this field only if the status changed when the subsequent history record was created. It indicates the level of activity of the organisational unit.
ORG_TYPE VARCHAR2 (4000)
The organisational type of the organisational unit during the currency of the history record. There will be a value in this field only if the organisational type changed when the subsequent record was created.
MEMBER_TYPE VARCHAR2 (4000)
The member type of the organisational unit during the currency of the history record. There will be a value in this field only if the member type changed when the subsequent history record was created.
INSTITUTION_CD VARCHAR2 (4000)
The code for the institution the organisational unit was associated with during the currency of the history record. There will be a value in this field only if the association changed when the subsequent history record was created.
NAME VARCHAR2 (4000)
The description, or name, of the institution the organisational unit was associated with during the currency of the history record. There will be a value in this field only if the association changed when the subsequent history record was created.
CREATED_BY NUMBER (15)
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT ORG_UNIT_CD
,      OU_START_DT
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      END_DT
,      DESCRIPTION
,      ORG_STATUS
,      ORG_TYPE
,      MEMBER_TYPE
,      INSTITUTION_CD
,      NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_OR_UNIT_HIST_V;

Dependencies

[top of page]

APPS.IGS_OR_UNIT_HIST_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
PL/SQL PackageIGS_AU_GEN_003 - show dependent code
PL/SQL PackageIGS_GE_DATE - show dependent code
SynonymIGS_OR_UNIT_HIST_ALL
SynonymIGS_PE_HZ_PARTIES

APPS.IGS_OR_UNIT_HIST_V is not referenced by any database object