eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.IGS_DA_XML_SUBPROGRAM_V

Object Details

Object Name:	IGS_DA_XML_SUBPROGRAM_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_DA_XML_SUBPROGRAM_V
Subobject Name:
Status:	VALID

View Type

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

XML element SubProgramType (child of AcademicProgram). Returns the Major(s), Minor(s), and Track(s) of the Academic Program.

[View Source]

Columns

Name	Datatype	Length	Comments
PROGRAM_TYPE	VARCHAR2	(10)	Contains the type of the program being described.
PROGRAM_CODE	VARCHAR2	(10)	Contains the program.
PROGRAM_NAME	VARCHAR2	(4000)	Contains the name of the program.
PROGRAM_CATALOG_YEAR	VARCHAR2	(10)	Contains the catalog year of the program.
PROGRAM_CONTROL_CODE	CHAR	(0)	Contains the Marker value for the sub program
PROGRAM_CODE_TYPE	CHAR	(0)	Contains the Marker type for the sub program.
BATCH_ID	NUMBER	(15)	Contains the OSS generated Batch ID for tracking purposes.
PERSON_ID	NUMBER	(15)	Describes the details of the person ID code that is being passed.
IGS_DA_REQ_STDNTS_ID	NUMBER	(15)	Student ID
SOURCE	VARCHAR2	(7)	Major1,2,3 - minor 1,2,3 - track 1,2,3

Query Text

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


SELECT PROGRAM_TYPE
,      PROGRAM_CODE
,      PROGRAM_NAME
,      PROGRAM_CATALOG_YEAR
,      PROGRAM_CONTROL_CODE
,      PROGRAM_CODE_TYPE
,      BATCH_ID
,      PERSON_ID
,      IGS_DA_REQ_STDNTS_ID
,      SOURCE
FROM APPS.IGS_DA_XML_SUBPROGRAM_V;

Dependencies

[top of page]

APPS.IGS_DA_XML_SUBPROGRAM_V references the following:

APPS: IGS_AS_SU_SETATMPT; IGS_CA_INST_ALL; IGS_DA_REQ_STDNTS; IGS_DA_REQ_WIF; IGS_DA_SETUP; IGS_EN_STDNT_PS_ATT_ALL; IGS_EN_UNIT_SET; IGS_GE_GEN_004 - show dependent code; IGS_PE_STAT_DETAILS

APPS.IGS_DA_XML_SUBPROGRAM_V is not referenced by any database object