[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

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

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