[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 |