View that relates a project and the users currently assigned to it.
Output
Column | Type | Description |
|---|---|---|
project_id | NUMBER | The ID of the project. |
assigned_to | NUMBER | The ID of a user that the project is assigned to. |
username | VARCHAR2 | The name of the assigned user. |
Example
The following example shows the use of this view in an SQL statement.
select * from hpd_projectusers_vw where project_id=44; |