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_EN_SUA_PLACEMENT_DET_V

Object Details

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

View Type

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

List of students with placement with an indicator to show whether placement details have been entered.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_IDENTIFIER	NUMBER	(15)	Yes	Identifier of the person for the student placement
PERSON_NUMBER	VARCHAR2	(30)	Yes	Person number
PROGRAM_CODE	VARCHAR2	(6)	Yes	Program code
UNIT_CODE	VARCHAR2	(10)	Yes	Unit code
UNIT_VERSION_NUMBER	NUMBER	(3)	Yes	Unit version number
UNIT_CLASS	VARCHAR2	(10)	Yes	Unit class
LOCATION_CODE	VARCHAR2	(10)	Yes	Unit location code
UNIT_SECTION_IDENTIFIER	NUMBER	(7)	Yes	Unique identifier for the unit offering option record.
STUDENT_PLACEMENT_INDICATOR	VARCHAR2	(1)		Placement indicator, 'Y' - Indicates placement record exists 'N' - Indicates placement record does not exist

Query Text

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


SELECT PERSON_IDENTIFIER
,      PERSON_NUMBER
,      PROGRAM_CODE
,      UNIT_CODE
,      UNIT_VERSION_NUMBER
,      UNIT_CLASS
,      LOCATION_CODE
,      UNIT_SECTION_IDENTIFIER
,      STUDENT_PLACEMENT_INDICATOR
FROM APPS.IGS_EN_SUA_PLACEMENT_DET_V;

Dependencies

[top of page]

APPS.IGS_EN_SUA_PLACEMENT_DET_V references the following:

APPS: HZ_PARTIES; IGS_EN_SPLACEMENTS; IGS_EN_SU_ATTEMPT; IGS_PS_UNIT_OFR_OPT

APPS.IGS_EN_SUA_PLACEMENT_DET_V is not referenced by any database object