[Home] [Help]
View: CSD_PROJECT_DETAILS_V
View Text
SELECT DPT.PRODUCT_TRANSACTION_ID
, DPT.PROJECT_ID
, PPV.PROJECT_NUMBER
, DPT.TASK_ID
, PTV.TASK_NUMBER
, DPT.UNIT_NUMBER
, DPT.OBJECT_VERSION_NUMBER
FROM CSD_PRODUCT_TRANSACTIONS DPT
, PJM_PROJECTS_V PPV
, PJM_TASKS_V PTV
WHERE DPT.PROJECT_ID = PPV.PROJECT_ID(+)
AND DPT.TASK_ID = PTV.TASK_ID(+)
Columns
Name |
PRODUCT_TRANSACTION_ID |
PROJECT_ID |
PROJECT_NUMBER |
TASK_ID |
TASK_NUMBER |
UNIT_NUMBER |
OBJECT_VERSION_NUMBER |