[Home] [Help] [Dependency Information]
Object Name: | IGW_PROPOSALS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGW.IGW_PROPOSALS_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.IGW_PROPOSALS_V is not referenced by any database object
|
|
|