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

Object Details

Object Name:	IGW_PRPO_ABSTRACTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGW.IGW_PRPO_ABSTRACTS_V
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

IGW_PRPO_ABSTRACTS_V displays proposal paragraphs like abstract and progress report. Each paragraph is formatted into ten fields each of 400 characters. This view is used in generating a flat file for Electronic Data Interchange.

[View Source]

Columns

Name	Datatype	Length	Mandatory
PROPOSAL_ID	NUMBER	(15)	Yes
ABSTRACT_CODE	VARCHAR2	(30)	Yes
ABSTRACT_TYPE	VARCHAR2	(80)	Yes
ABSTRACT_TEXT1	VARCHAR2	(400)
ABSTRACT_TEXT2	VARCHAR2	(400)
ABSTRACT_TEXT3	VARCHAR2	(400)
ABSTRACT_TEXT4	VARCHAR2	(400)
ABSTRACT_TEXT5	VARCHAR2	(400)
ABSTRACT_TEXT6	VARCHAR2	(400)
ABSTRACT_TEXT7	VARCHAR2	(400)
ABSTRACT_TEXT8	VARCHAR2	(400)
ABSTRACT_TEXT9	VARCHAR2	(400)
ABSTRACT_TEXT10	VARCHAR2	(400)

Query Text

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


SELECT PROPOSAL_ID
,      ABSTRACT_CODE
,      ABSTRACT_TYPE
,      ABSTRACT_TEXT1
,      ABSTRACT_TEXT2
,      ABSTRACT_TEXT3
,      ABSTRACT_TEXT4
,      ABSTRACT_TEXT5
,      ABSTRACT_TEXT6
,      ABSTRACT_TEXT7
,      ABSTRACT_TEXT8
,      ABSTRACT_TEXT9
,      ABSTRACT_TEXT10
FROM APPS.IGW_PRPO_ABSTRACTS_V;

Dependencies

[top of page]

APPS.IGW_PRPO_ABSTRACTS_V references the following:

APPS: FND_GLOBAL - show dependent code; IGW_LOOKUPS_V; IGW_PROP_ABSTRACTS

APPS.IGW_PRPO_ABSTRACTS_V is not referenced by any database object