GM_PROP_VW(SQL View) |
Index Back |
---|---|
Grants Proposal ViewView of all proposal records NOT including the present one. Related proposal. |
SELECT DISTINCT a.business_unit , a.proposal_id FROM PS_GM_PROPOSAL a |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT_PROP | Character(5) | VARCHAR2(5) NOT NULL | Proposal Business Unit |
2 | RELATED_PROPOSAL | Character(25) | VARCHAR2(25) NOT NULL | Related Proposal ID |