[Home] [Help] [Dependency Information]
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 |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROPOSAL_ID | NUMBER | (15) | Yes | |
PERSON_ID | NUMBER | (15) | ||
PARTY_ID | NUMBER | (15) | Yes | |
SUPPORT_STATUS | VARCHAR2 | (80) | ||
AWARD_NUMBER | VARCHAR2 | (30) | ||
AWARD_TITLE | VARCHAR2 | (250) | ||
ANNUAL_DIRECT_COST | NUMBER | (15) | ||
TOTAL_COST | NUMBER | (15) | ||
PERCENT_EFFORT | NUMBER | (5) | ||
SPONSOR_NAME | VARCHAR2 | (50) | ||
MAJOR_GOALS | VARCHAR2 | (250) | ||
PM_LAST_NAME | VARCHAR2 | (150) | ||
PM_FIRST_NAME | VARCHAR2 | (150) | ||
PM_MIDDLE_NAME | VARCHAR2 | (60) | ||
PROJECT_LOCATION | VARCHAR2 | (100) | ||
START_DATE | DATE | |||
END_DATE | DATE | |||
OVERLAP | VARCHAR2 | (250) | ||
OTH_SUPPORT_ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
OTH_SUPPORT_ATTRIBUTE1 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE2 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE3 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE4 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE5 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE6 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE7 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE8 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE9 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE10 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE11 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE12 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE13 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE14 | VARCHAR2 | (150) | ||
OTH_SUPPORT_ATTRIBUTE15 | VARCHAR2 | (150) |
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;
APPS.IGW_PRPO_OTHER_SUPPORT_V is not referenced by any database object
|
|
|