[Home] [Help]
View: PA_PROJECT_ASSET_ASSIGNMENTS_V
View Text
SELECT AA.ROWID ROW_ID
, AA.PROJECT_ASSET_ID
, A.ASSET_NAME
, A.ASSET_DESCRIPTION
, AA.PROJECT_ID
, AA.TASK_ID
, AA.LAST_UPDATE_DATE
, AA.LAST_UPDATED_BY
, AA.CREATION_DATE
, AA.CREATED_BY
, AA.LAST_UPDATE_LOGIN
, A.ORG_ID
FROM PA_PROJECT_ASSETS A
, PA_PROJECT_ASSET_ASSIGNMENTS AA
WHERE A.PROJECT_ASSET_ID = AA.PROJECT_ASSET_ID
Columns
Name |
ROW_ID |
PROJECT_ASSET_ID |
ASSET_NAME |
ASSET_DESCRIPTION |
PROJECT_ID |
TASK_ID |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_LOGIN |
ORG_ID |