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

VIEW: APPS.IGS_DA_XML_DEGREEPROGRAM_V

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


XML element DegreeProgramLead index view to Academic Program and Academic Subprogram. Provides the batch_id, local_institution_cd, and person_id to the sub views whereclause is provide in XML map.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes Contains the OSS generated Batch ID for tracking purposes.
INSTITUTION_CD VARCHAR2 (30) Yes Describes the institution from which the degree program is offered. The Institution is composed of the EntityID type. See this type for institution details.
PERSON_ID NUMBER (15) Yes Describes the details of the person ID code that is being passed.
Query Text

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


SELECT BATCH_ID
,      INSTITUTION_CD
,      PERSON_ID
FROM APPS.IGS_DA_XML_DEGREEPROGRAM_V;

Dependencies

[top of page]

APPS.IGS_DA_XML_DEGREEPROGRAM_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGS_DA_REQ_STDNTS

APPS.IGS_DA_XML_DEGREEPROGRAM_V is not referenced by any database object