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

VIEW: APPS.IGS_OR_UNIT_FUNDSRC_V

Object Details
Object Name: IGS_OR_UNIT_FUNDSRC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_OR_UNIT_FUNDSRC_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
TCA_PARTY_NUMBER VARCHAR2 (30) Yes Party Number of the Organization in HZ_PARTIES
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. An institution code may be assigned to an organisational unit.
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.
END_DT DATE

The date from which the organisational unit is no longer effective.
OU_DESCRIPTION VARCHAR2 (360) Yes The description of an organisational unit. 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. An institution code may be assigned to an organisational unit.
ORG_STATUS VARCHAR2 (10)
The name of the organisational status assigned to the organisational unit. An organisational unit status indicates the level of activity of an organisational unit record. Each organisational unit must be assigned a status. Examples are ACTIVE and INACTIVE.
ORG_TYPE VARCHAR2 (30)
The name of the organisational type assigned to the organisational unit. Organisational types are business category classifications of organisational units. Each organisational unit must be assigned an organisational type. Examples are ACADEMIC and ADMINISTRATIVE.
MEMBER_TYPE VARCHAR2 (30)
The name of the member type assigned to the organisational unit. A member type is a classification of organisational units by structure level. Each organisational unit must be assigned a member type. Examples are FACULTY, SCHOOL, DEPARTMENT, and DIVISION.
INSTITUTION_CD VARCHAR2 (30)
The code for the institution with which the organisational unit is associated. The association of an organisational unit with an institution is optional.
FUNDING_SOURCE VARCHAR2 (10) Yes A unique identifier for the institution-defined funding source. This must be mapped to a Government funding source.
FS_DESCRIPTION VARCHAR2 (60) Yes Description of an institution-defined funding source.
GOVT_FUNDING_SOURCE NUMBER (2) Yes The unique identifier for the Government funding source.
CLOSED_IND VARCHAR2 (1) Yes
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)
Query Text

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


SELECT TCA_PARTY_NUMBER
,      ORG_UNIT_CD
,      START_DT
,      END_DT
,      OU_DESCRIPTION
,      ORG_STATUS
,      ORG_TYPE
,      MEMBER_TYPE
,      INSTITUTION_CD
,      FUNDING_SOURCE
,      FS_DESCRIPTION
,      GOVT_FUNDING_SOURCE
,      CLOSED_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_OR_UNIT_FUNDSRC_V;

Dependencies

[top of page]

APPS.IGS_OR_UNIT_FUNDSRC_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewIGS_FI_FUND_SRC
SynonymIGS_PE_HZ_PARTIES

APPS.IGS_OR_UNIT_FUNDSRC_V is not referenced by any database object