[Home] [Help] [Dependency Information]

VIEW: APPS.IGW_PRPO_OTHER_SUPPORT_V

Object Details

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

View Type

A Business Intelligence System view

IGW_PRPO_OTHER_SUPPORT_V displays details of other sources of support which are pending or available for personnel on the proposal. This view is used in generating a flat file for Electronic Data Interchange.

[View Source]

Columns

Query Text

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

SELECT PROPOSAL_ID
,      PERSON_ID
,      PARTY_ID
,      SUPPORT_STATUS
,      AWARD_NUMBER
,      AWARD_TITLE
,      ANNUAL_DIRECT_COST
,      TOTAL_COST
,      PERCENT_EFFORT
,      SPONSOR_NAME
,      MAJOR_GOALS
,      PM_LAST_NAME
,      PM_FIRST_NAME
,      PM_MIDDLE_NAME
,      PROJECT_LOCATION
,      START_DATE
,      END_DATE
,      OVERLAP
,      OTH_SUPPORT_ATTRIBUTE_CATEGORY
,      OTH_SUPPORT_ATTRIBUTE1
,      OTH_SUPPORT_ATTRIBUTE2
,      OTH_SUPPORT_ATTRIBUTE3
,      OTH_SUPPORT_ATTRIBUTE4
,      OTH_SUPPORT_ATTRIBUTE5
,      OTH_SUPPORT_ATTRIBUTE6
,      OTH_SUPPORT_ATTRIBUTE7
,      OTH_SUPPORT_ATTRIBUTE8
,      OTH_SUPPORT_ATTRIBUTE9
,      OTH_SUPPORT_ATTRIBUTE10
,      OTH_SUPPORT_ATTRIBUTE11
,      OTH_SUPPORT_ATTRIBUTE12
,      OTH_SUPPORT_ATTRIBUTE13
,      OTH_SUPPORT_ATTRIBUTE14
,      OTH_SUPPORT_ATTRIBUTE15
FROM APPS.IGW_PRPO_OTHER_SUPPORT_V;

Dependencies

[top of page]

APPS

FND_GLOBAL - show dependent code

HR_GENERAL - show dependent code

HR_PERSON_NAME - show dependent code

HR_SECURITY - show dependent code

HZ_CUST_ACCOUNTS

HZ_PARTIES

IGW_LOOKUPS_V

IGW_PROP_PERSON_SUPPORT

PER_PEOPLE_X

APPS.IGW_PRPO_OTHER_SUPPORT_V is not referenced by any database object