FND Design Data [Home] [Help]

Table: IGW_PROPOSALS_ALL

Product: IGW - Grants Proposal (Obsolete)
Description: Core information about proposals
Implementation/DBA Data: Not implemented in this database
Primary Key: IGW_PROPOSALS_PK
  1. ColumnPROPOSAL_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
IGW_PROPOSALS_ALL FK Joins to TableHR_ALL_ORGANIZATION_UNITS IGW_PROPOSALS_ALL.LEAD_ORGANIZATION_ID
IGW_PROPOSALS_ALL FK Joins to TableHR_ALL_ORGANIZATION_UNITS IGW_PROPOSALS_ALL.SUBMITTING_ORGANIZATION_ID
TableIGW_AWARDS FK Joins to IGW_PROPOSALS_ALL IGW_AWARDS.PROPOSAL_ID
TableIGW_BUDGETS FK Joins to IGW_PROPOSALS_ALL IGW_BUDGETS.PROPOSAL_ID
TableIGW_PROP_ABSTRACTS FK Joins to IGW_PROPOSALS_ALL IGW_PROP_ABSTRACTS.PROPOSAL_ID
TableIGW_PROP_APPROVAL_RUNS FK Joins to IGW_PROPOSALS_ALL IGW_PROP_APPROVAL_RUNS.PROPOSAL_ID
TableIGW_PROP_CHECKLIST FK Joins to IGW_PROPOSALS_ALL IGW_PROP_CHECKLIST.PROPOSAL_ID
TableIGW_PROP_COMMENTS FK Joins to IGW_PROPOSALS_ALL IGW_PROP_COMMENTS.PROPOSAL_ID
TableIGW_PROP_COMMENTS FK Joins to IGW_PROPOSALS_ALL IGW_PROP_COMMENTS.PROPOSAL_ID
TableIGW_PROP_COMPONENT_STATUSES FK Joins to IGW_PROPOSALS_ALL IGW_PROP_COMPONENT_STATUSES.PROPOSAL_ID
TableIGW_PROP_LOCATIONS FK Joins to IGW_PROPOSALS_ALL IGW_PROP_LOCATIONS.PROPOSAL_ID
TableIGW_PROP_NARRATIVES FK Joins to IGW_PROPOSALS_ALL IGW_PROP_NARRATIVES.PROPOSAL_ID
TableIGW_PROP_PERSONS FK Joins to IGW_PROPOSALS_ALL IGW_PROP_PERSONS.PROPOSAL_ID
TableIGW_PROP_PROGRAM_ADDRESSES FK Joins to IGW_PROPOSALS_ALL IGW_PROP_PROGRAM_ADDRESSES.PROPOSAL_ID
TableIGW_PROP_QUESTIONS FK Joins to IGW_PROPOSALS_ALL IGW_PROP_QUESTIONS.PROPOSAL_ID
TableIGW_PROP_SCIENCE_CODES FK Joins to IGW_PROPOSALS_ALL IGW_PROP_SCIENCE_CODES.PROPOSAL_ID
TableIGW_PROP_SPECIAL_REVIEWS FK Joins to IGW_PROPOSALS_ALL IGW_PROP_SPECIAL_REVIEWS.PROPOSAL_ID
TableIGW_PROP_USERS FK Joins to IGW_PROPOSALS_ALL IGW_PROP_USERS.PROPOSAL_ID
TableIGW_STUDY_TITLES FK Joins to IGW_PROPOSALS_ALL IGW_STUDY_TITLES.PROPOSAL_ID