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

Object Details

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

View Type

A Business Intelligence System view

[View Source]

Columns

Name	Datatype	Length	Mandatory
PROPOSAL_NUMBER	VARCHAR2	(30)	Yes
LEAD_ORGANIZATION_NAME	VARCHAR2	(240)	Yes
_LA:PROPOSAL_STATUS	CHAR	(61)
PROPOSAL_START_DATE	DATE		Yes
PROPOSAL_END_DATE	DATE		Yes
PROPOSAL_TITLE	VARCHAR2	(250)
PROPOSAL_TYPE	VARCHAR2	(80)	Yes
AWARD_NUMBER	VARCHAR2	(15)
AWARD_AMOUNT	NUMBER	(15)
ORIGINAL_PROPOSAL_NUMBER	VARCHAR2	(30)
ORIGINAL_AWARD_NUMBER	VARCHAR2	(15)
ORIGINAL_PROPOSAL_START_DATE	DATE
ORIGINAL_PROPOSAL_END_DATE	DATE
ACTIVITY_TYPE	VARCHAR2	(80)	Yes
SPONSOR_NAME	VARCHAR2	(50)
SPONSOR_PROPOSAL_NUMBER	VARCHAR2	(30)
NOTICE_OF_OPPORTUNITY	VARCHAR2	(80)
PROGRAM_NUMBER	VARCHAR2	(30)
PROGRAM_TITLE	VARCHAR2	(250)
SPONSOR_ACTION	VARCHAR2	(80)
SPONSOR_ACTION_DATE	DATE
SUBMITTING_ORGANIZATION_NAME	VARCHAR2	(240)	Yes
DEADLINE_DATE	DATE
DEADLINE_TYPE	VARCHAR2	(1)
NARRATIVE_SUBMISSION	VARCHAR2	(80)
ORIGINAL_SPONSOR_NAME	VARCHAR2	(50)
LETTER_OF_INTENT_DUE_DATE	DATE
PROGRAM_URL	VARCHAR2	(240)
FUNDING_SPONSOR_UNIT	VARCHAR2	(45)
EDI_GENERATED_DATE	DATE
_DF	CHAR	(34)
NARRATIVE_STATUS	VARCHAR2	(4000)
NARRATIVE_TYPE_CODE	VARCHAR2	(30)
PROPOSAL_ID	NUMBER	(15)	Yes
LEAD_ORGANIZATION_ID	NUMBER	(15)
SUBMITTING_ORGANIZATION_ID	NUMBER	(15)
ORG_ID	NUMBER	(15)
SPONSOR_ID	NUMBER	(15)
ORIGINAL_SPONSOR_ID	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes

Query Text

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


SELECT PROPOSAL_NUMBER
,      LEAD_ORGANIZATION_NAME
,      _LA:PROPOSAL_STATUS
,      PROPOSAL_START_DATE
,      PROPOSAL_END_DATE
,      PROPOSAL_TITLE
,      PROPOSAL_TYPE
,      AWARD_NUMBER
,      AWARD_AMOUNT
,      ORIGINAL_PROPOSAL_NUMBER
,      ORIGINAL_AWARD_NUMBER
,      ORIGINAL_PROPOSAL_START_DATE
,      ORIGINAL_PROPOSAL_END_DATE
,      ACTIVITY_TYPE
,      SPONSOR_NAME
,      SPONSOR_PROPOSAL_NUMBER
,      NOTICE_OF_OPPORTUNITY
,      PROGRAM_NUMBER
,      PROGRAM_TITLE
,      SPONSOR_ACTION
,      SPONSOR_ACTION_DATE
,      SUBMITTING_ORGANIZATION_NAME
,      DEADLINE_DATE
,      DEADLINE_TYPE
,      NARRATIVE_SUBMISSION
,      ORIGINAL_SPONSOR_NAME
,      LETTER_OF_INTENT_DUE_DATE
,      PROGRAM_URL
,      FUNDING_SPONSOR_UNIT
,      EDI_GENERATED_DATE
,      _DF
,      NARRATIVE_STATUS
,      NARRATIVE_TYPE_CODE
,      PROPOSAL_ID
,      LEAD_ORGANIZATION_ID
,      SUBMITTING_ORGANIZATION_ID
,      ORG_ID
,      SPONSOR_ID
,      ORIGINAL_SPONSOR_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM APPS.IGWFV_GRANT_PROPOSAL;

Dependencies

[top of page]

APPS.IGWFV_GRANT_PROPOSAL references the following:

APPS: FND_GLOBAL - show dependent code; HR_ALL_ORGANIZATION_UNITS; HZ_CUST_ACCOUNTS; HZ_PARTIES; IGW_LOOKUPS_V; IGW_PROP - show dependent code; IGW_PROPOSALS_ALL

APPS.IGWFV_GRANT_PROPOSAL is not referenced by any database object