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.IGSBV_AV_STND_UNT_REF_CODES

Object Details

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

View Type

A Business Intelligence System view

A Business Intelligence System view for Advanced standing unit reference codes.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
AVU_REFERENCE_CD_ID	NUMBER		Yes	System Generated number to store the primary key.
PERSON_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES.
AV_STND_UNIT_ID	NUMBER	(15)	Yes	Advanced Standing Unit ID.
REFERENCE_CODE_ID	NUMBER	(10)	Yes	Uniquely identifies an institution-defined reference code type.
APPLIED_COURSE_CD	VARCHAR2	(6)	Yes	The program code under which the reference code is saved.
DELETED_DATE	DATE			Deleted Date
CREATED_BY	NUMBER	(15)	Yes	Created By
CREATION_DATE	DATE		Yes	Creation Date
LAST_UPDATED_BY	NUMBER	(15)	Yes	Last Updated By
LAST_UPDATE_DATE	DATE		Yes	Last Update Date
LAST_UPDATE_LOGIN	NUMBER	(15)		Last Update Login

Query Text

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


SELECT AVU_REFERENCE_CD_ID
,      PERSON_ID
,      AV_STND_UNIT_ID
,      REFERENCE_CODE_ID
,      APPLIED_COURSE_CD
,      DELETED_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGSBV_AV_STND_UNT_REF_CODES;

Dependencies

[top of page]

APPS.IGSBV_AV_STND_UNT_REF_CODES references the following:

APPS: IGS_AV_UNT_REF_CDS

APPS.IGSBV_AV_STND_UNT_REF_CODES is not referenced by any database object