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

VIEW: APPS.IGS_PS_PRG_UNIT_REL_V

Object Details
Object Name: IGS_PS_PRG_UNIT_REL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_PS_PRG_UNIT_REL_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

A public view which may be useful for custom reporting or other data
requirements.


View for the base table for form which maintains the relationship between Programs' career level and units' program type level.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ROWID of the base table
PS_PRUN_REL_ID NUMBER (15) Yes
STUDENT_CAREER_LEVEL VARCHAR2 (10) Yes
UNIT_TYPE_ID NUMBER (15) Yes
UNIT_PROGRAM_TYPE_LEVEL VARCHAR2 (10) Yes
STUDENT_CAREER_TRANSCRIPT VARCHAR2 (1) Yes
STUDENT_CAREER_STATISTICS 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 ROW_ID
,      PS_PRUN_REL_ID
,      STUDENT_CAREER_LEVEL
,      UNIT_TYPE_ID
,      UNIT_PROGRAM_TYPE_LEVEL
,      STUDENT_CAREER_TRANSCRIPT
,      STUDENT_CAREER_STATISTICS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_PS_PRG_UNIT_REL_V;

Dependencies

[top of page]

APPS.IGS_PS_PRG_UNIT_REL_V references the following:

SchemaAPPS
SynonymIGS_PS_PRG_UNIT_REL
SynonymIGS_PS_UNIT_TYPE_LVL

APPS.IGS_PS_PRG_UNIT_REL_V is not referenced by any database object