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

VIEW: APPS.IGS_PS_UNIT_REF_HIST_V

Object Details
Object Name: IGS_PS_UNIT_REF_HIST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_PS_UNIT_REF_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
UNIT_CD VARCHAR2 (10)
The code used to identify the unit.
VERSION_NUMBER NUMBER (3)
Version number is used to uniquely identify each version of a unit.
REFERENCE_CD_TYPE VARCHAR2 (10)
This field describes the types of reference codes that are applied to the course offering options.
REFERENCE_CD VARCHAR2 (30)
An 'other system' reference code for a unit. For example, an IVRS code used to represent a unit.
HIST_START_DT DATE

The effective start date/time of the history record.
HIST_END_DT DATE

The effective end date/time of the history record.
HIST_WHO NUMBER (15)
The Oracle username of the person who created the history record.
DESCRIPTION VARCHAR2 (60)
The description, or name, of the unit reference code.
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 UNIT_CD
,      VERSION_NUMBER
,      REFERENCE_CD_TYPE
,      REFERENCE_CD
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      DESCRIPTION
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_PS_UNIT_REF_HIST_V;

Dependencies

[top of page]

APPS.IGS_PS_UNIT_REF_HIST_V references the following:

SchemaAPPS
PL/SQL PackageIGS_AU_GEN_004 - show dependent code
SynonymIGS_PS_UNIT_REF_CD
ViewIGS_PS_UNIT_REF_HIST
ViewIGS_PS_UNIT_VER

APPS.IGS_PS_UNIT_REF_HIST_V is not referenced by any database object