View: IGW_PRPO_ABSTRACTS_V

Product:	IGW - Grants Proposal
Description:	View displays proposal paragraphs, such as abstract, progress, and report
Implementation/DBA Data:	APPS.IGW_PRPO_ABSTRACTS_V

View Text

SELECT PROPOSAL_ID
, ABSTRACT_TYPE_CODE
, MEANING
, SUBSTR(ABSTRACT
, 1
, 400)
, SUBSTR(ABSTRACT
, 401
, 400)
, SUBSTR(ABSTRACT
, 801
, 400)
, SUBSTR(ABSTRACT
, 1201
, 400)
, SUBSTR(ABSTRACT
, 1601
, 400)
, SUBSTR(ABSTRACT
, 2001
, 400)
, SUBSTR(ABSTRACT
, 2401
, 400)
, SUBSTR(ABSTRACT
, 2801
, 400)
, SUBSTR(ABSTRACT
, 3201
, 400)
, SUBSTR(ABSTRACT
, 3601
, 400)
FROM IGW_PROP_ABSTRACTS ABS
, IGW_LOOKUPS_V VALS
WHERE (ABS.ABSTRACT_TYPE_CODE = VALS.LOOKUP_CODE
AND VALS.LOOKUP_TYPE = 'IGW_ABSTRACT_TYPES'
AND ABS.ABSTRACT_TYPE = 'IGW_ABSTRACT_TYPES') OR (ABS.ABSTRACT_TYPE_CODE = VALS.LOOKUP_CODE
AND VALS.LOOKUP_TYPE = 'IGW_RESOURCE_TYPES'
AND ABS.ABSTRACT_TYPE = 'IGW_RESOURCE_TYPES')

Columns