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

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PROPOSAL_ID	NUMBER	(15)	Yes	Proposal identifier
PROPOSAL_NUMBER	VARCHAR2	(30)	Yes	Proposal number that uniquely identifies the proposal. Proposal number can be user-entered or system-generated as defined in the implementation options.
PROPOSAL_SHORT_TITLE	VARCHAR2	(150)		Short Title of Proposal
PROPOSAL_TITLE	VARCHAR2	(250)		Detailed title of the proposal
PROPOSAL_STATUS	VARCHAR2	(1)		Status of the proposal. Possible values are P for In Progress, I for Approval In-Progress, A for Approved, and R for Rejected.
PROPOSAL_STATUS_DESC	VARCHAR2	(80)	Yes	Proposal Status Description
SPONSOR_ID	NUMBER	(15)		Grantor Identifier
SPONSOR_NAME	VARCHAR2	(360)		Grantor Name in Internal Grantee mode
SUBMITTING_PARTY_ID	NUMBER	(15)		Submitting Party Identifier
APPLICANT	VARCHAR2	(360)		Name of Applicant organization
PROPOSAL_MANAGER_ID	NUMBER	(15)		Proposal Manager Identifier
PROPOSAL_MANAGER_NAME	VARCHAR2	(360)	Yes	Proposal Manager Name
PROGRAM_NUMBER	VARCHAR2	(30)		Program Number
PROGRAM_TITLE	VARCHAR2	(250)		Program Title
PROGRAM_MANAGER_ID	NUMBER	(15)		Program Manager Identifier
PROGRAM_MANAGER_NAME	VARCHAR2	(360)		Program Manager Name
TOTAL_DIRECT_COST	NUMBER	(15)		Total Direct Cost
TOTAL_COST	NUMBER	(15)		Total Cost
PROPOSAL_START_DATE	DATE		Yes	Proposal Start Date
PROPOSAL_END_DATE	DATE		Yes	Proposal End Date
SPONSOR_APPLICATION_NUMBER	VARCHAR2	(50)		Sponsor Application Number
AWARD_NUMBER	VARCHAR2	(15)		Award Number
CREATION_DATE	DATE		Yes	Proposal Creation Date
DETAIL_VIEW	CHAR	(1)		Detail View Flag
SELECT_FLAG	CHAR	(1)		Select Flag
SUBMIT_SWITCHER	CHAR	(14)		Submit Switcher
RECORD_VERSION_NUMBER	NUMBER		Yes	Record Version Number
UPPER_PROPOSAL_NUMBER	VARCHAR2	(30)		Uppercase value of Proposal Number
UPPER_PROPOSAL_SHORT_TITLE	VARCHAR2	(150)		Uppercase value of Proposal Short Title
UPPER_PROPOSAL_TITLE	VARCHAR2	(250)		Uppercase value of Proposal Title
PROPOSAL_TYPE_CODE	VARCHAR2	(30)	Yes	Proposal Type Code
ACTIVITY_TYPE_CODE	VARCHAR2	(30)	Yes	Activity Type Code
SPONSOR_ACTION_CODE	VARCHAR2	(30)		Sponsor Action Code
DEADLINE_DATE	DATE			Deadline Date
FUNDING_SPONSOR_UNIT	VARCHAR2	(45)		Funding Sponsor Unit
APPLICANT_UNIT_NAME	VARCHAR2	(300)		Applicant Unit Name
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
DELETE_SWITCHER	CHAR	(14)		Delete Switcher
CURRENCY_CODE	VARCHAR2	(4000)		Currency Code
PROP_OAHP	VARCHAR2	(28)		Application Menu Name
SIGNING_OFFICIAL_PARTY_ID	NUMBER	(15)		Party Identifier for Signing Official
ADMIN_OFFICIAL_PARTY_ID	NUMBER	(15)		Party identifier for Administrative Official
TOTAL_INDIRECT_COST	NUMBER	(15)		Total Indirect Cost
GRANTOR	VARCHAR2	(360)		Grantor Name in External Grantee mode
LEAD_ORGANIZATION_ID	NUMBER	(15)		Applicant Unit Identifier
ALLOW_QUERY	CHAR	(1)		Flag to identify if query is allowed on this proposal for given user
IGW_MODE	VARCHAR2	(30)		Installation Mode value for proposal
PROFILE_IGW_MODE	VARCHAR2	(10)		Installation Mode value from profile

Query Text

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


SELECT PROPOSAL_ID
,      PROPOSAL_NUMBER
,      PROPOSAL_SHORT_TITLE
,      PROPOSAL_TITLE
,      PROPOSAL_STATUS
,      PROPOSAL_STATUS_DESC
,      SPONSOR_ID
,      SPONSOR_NAME
,      SUBMITTING_PARTY_ID
,      APPLICANT
,      PROPOSAL_MANAGER_ID
,      PROPOSAL_MANAGER_NAME
,      PROGRAM_NUMBER
,      PROGRAM_TITLE
,      PROGRAM_MANAGER_ID
,      PROGRAM_MANAGER_NAME
,      TOTAL_DIRECT_COST
,      TOTAL_COST
,      PROPOSAL_START_DATE
,      PROPOSAL_END_DATE
,      SPONSOR_APPLICATION_NUMBER
,      AWARD_NUMBER
,      CREATION_DATE
,      DETAIL_VIEW
,      SELECT_FLAG
,      SUBMIT_SWITCHER
,      RECORD_VERSION_NUMBER
,      UPPER_PROPOSAL_NUMBER
,      UPPER_PROPOSAL_SHORT_TITLE
,      UPPER_PROPOSAL_TITLE
,      PROPOSAL_TYPE_CODE
,      ACTIVITY_TYPE_CODE
,      SPONSOR_ACTION_CODE
,      DEADLINE_DATE
,      FUNDING_SPONSOR_UNIT
,      APPLICANT_UNIT_NAME
,      LAST_UPDATE_DATE
,      DELETE_SWITCHER
,      CURRENCY_CODE
,      PROP_OAHP
,      SIGNING_OFFICIAL_PARTY_ID
,      ADMIN_OFFICIAL_PARTY_ID
,      TOTAL_INDIRECT_COST
,      GRANTOR
,      LEAD_ORGANIZATION_ID
,      ALLOW_QUERY
,      IGW_MODE
,      PROFILE_IGW_MODE
FROM APPS.IGW_PROPOSALS_V;

Dependencies

[top of page]

APPS.IGW_PROPOSALS_V references the following:

APPS: FND_GLOBAL - show dependent code; FND_LOOKUPS; FND_PROFILE - show dependent code; HZ_PARTIES; IGW_BUDGETS; IGW_PROPOSALS_ALL; IGW_PROP_GRANTORS

APPS.IGW_PROPOSALS_V is not referenced by any database object