[Home] [Help]
View: PA_CIP_COST_CLEARING_V
View Text
SELECT PAL.PROJECT_ASSET_LINE_ID
, PAL.DESCRIPTION
, PAL.PROJECT_ASSET_ID
, PAL.PROJECT_ID
, PAL.TASK_ID
, PAL.CIP_CCID
, PAL.CURRENT_ASSET_COST
, PAL.PROJECT_ASSET_LINE_DETAIL_ID
, PAL.GL_DATE
, PAL.FA_PERIOD_NAME
, PAL.ASSET_CATEGORY_ID
, PAL.ORG_ID
FROM PA_PROJECT_ASSET_LINES_ALL PAL
WHERE PAL.FA_PERIOD_NAME IS NOT NULL
AND PAL.ORG_ID = MO_GLOBAL.GET_CURRENT_ORG_ID
Columns
| Name |
| PROJECT_ASSET_LINE_ID |
| ASSET_LINE_DESCRIPTION |
| PROJECT_ASSET_ID |
| PROJECT_ID |
| TASK_ID |
| CIP_CCID |
| CURRENT_ASSET_COST |
| PROJECT_ASSET_LINE_DETAIL_ID |
| GL_DATE |
| FA_PERIOD_NAME |
| ASSET_CATEGORY_ID |
| ORG_ID |
APPS.PA_CIP_COST_CLEARING_V