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_SS_APPL_PERSTAT_V

Object Details

Object Name:	IGS_SS_APPL_PERSTAT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_SS_APPL_PERSTAT_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 Web view designed to simplify access from Oracle Self-Service Web Applications.

View to select the Personal Statements for the Applications from the Self Service staging table

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Identifier
SS_PERSTAT_ID	NUMBER	(15)	Yes	Self Service Personal statement Identifier
PERSON_ID	NUMBER	(15)		Person Identifier
SS_ADM_APPL_ID	NUMBER	(15)		Admission Application Identifier
PERSL_STAT_TYPE	VARCHAR2	(30)		Personal statement Type
PERSL_STAT_TYPE_DESC	VARCHAR2	(240)	Yes	Pesonal Statement Type Description
CLOSED_IND	VARCHAR2	(1)	Yes	Closed Indicator
DATE_RECEIVED	DATE			Date on which personal Statement is received
CREATED_BY	NUMBER	(15)		standard WHO column
CREATION_DATE	DATE			standard WHO column
ATTACH_EXISTS	VARCHAR2	(1)		Indicates whether attachment exists
LAST_UPDATED_BY	NUMBER	(15)		standard WHO column
LAST_UPDATE_DATE	DATE			standard WHO column
LAST_UPDATE_LOGIN	NUMBER	(15)		standard WHO column
GROUP_NUMBER	NUMBER	(15)		group number
MANDATORY	VARCHAR2	(1)	Yes	mandatory indicator
ADMISSION_APPLICATION_TYPE	VARCHAR2	(30)	Yes	admission application type
GROUP_MIN	NUMBER	(15)		group minimum
SELF_MESSAGE	VARCHAR2	(60)		self message
GROUP_NAME	VARCHAR2	(60)		Group Name
GROUP_REQUIRED_FLAG	VARCHAR2	(1)		Indicates whether group is required

Query Text

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


SELECT ROW_ID
,      SS_PERSTAT_ID
,      PERSON_ID
,      SS_ADM_APPL_ID
,      PERSL_STAT_TYPE
,      PERSL_STAT_TYPE_DESC
,      CLOSED_IND
,      DATE_RECEIVED
,      CREATED_BY
,      CREATION_DATE
,      ATTACH_EXISTS
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      GROUP_NUMBER
,      MANDATORY
,      ADMISSION_APPLICATION_TYPE
,      GROUP_MIN
,      SELF_MESSAGE
,      GROUP_NAME
,      GROUP_REQUIRED_FLAG
FROM APPS.IGS_SS_APPL_PERSTAT_V;

Dependencies

[top of page]

APPS.IGS_SS_APPL_PERSTAT_V references the following:

APPS: IGS_AD_APTYP_PESTAT; IGS_AD_PER_STM_TYP; IGS_AD_PESTAT_GROUP; IGS_SS_APPL_PERSTAT

APPS.IGS_SS_APPL_PERSTAT_V is not referenced by any database object