[Home] [Help]
View: PA_PROJECT_ASSET_DRILLDOWN_V
View Text
SELECT PPAL.PROJECT_ASSET_LINE_ID
, PPAL.PROJECT_ASSET_LINE_DETAIL_ID
, PPAL.PROJECT_ID
, PPAL.TASK_ID
, PP.NAME
, PP.SEGMENT1
, PT.TASK_NAME
, PT.TASK_NUMBER
, PPAL.DESCRIPTION
, PPAL.ORIGINAL_ASSET_COST
, PPAL.CURRENT_ASSET_COST
, PP.ORG_ID
FROM PA_PROJECT_ASSET_LINES_ALL PPAL
, PA_PROJECTS PP
, PA_TASKS PT
WHERE PT.TASK_ID = PPAL.TASK_ID(+)
AND PP.PROJECT_ID = PPAL.PROJECT_ID
Columns
Name |
PROJECT_ASSET_LINE_ID |
PROJECT_ASSET_LINE_DETAIL_ID |
PROJECT_ID |
TASK_ID |
PROJECT_NAME |
PROJECT_NUMBER |
TASK_NAME |
TASK_NUMBER |
DESCRIPTION |
ORIGINAL_ASSET_COST |
CURRENT_ASSET_COST |
ORG_ID |