[Home] [Help]
View: CST_EAM_ASSET_BY_PERIODS_V
View Text
SELECT CS.INV_ID
, MI.CONCATENATED_SEGMENTS
, CS.ORG_ID
, CS.SERIAL_NUMBER
, CS.PERIOD_SET_NAME
, CS.PERIOD_NAME
, CS.PERIOD_START_DATE
, CS.TOTAL
, CS.MATERIAL
, CS.LABOR
, CS.EQUIPMENT
FROM (SELECT T1.INVENTORY_ITEM_ID AS INV_ID
, T1.ORGANIZATION_ID AS ORG_ID
, T1.SERIAL_NUMBER AS SERIAL_NUMBER
, T1.PERIOD_SET_NAME
, T1.PERIOD_NAME
, T1.PERIOD_START_DATE
, (NVL(SUM(T1.ACTUAL_MAT_COST)
, 0) + NVL(SUM(T1.ACTUAL_LAB_COST)
, 0) + NVL(SUM(T1.ACTUAL_EQP_COST)
, 0)) AS TOTAL
, NVL(SUM(T1.ACTUAL_MAT_COST)
, 0) AS MATERIAL
, NVL(SUM(T1.ACTUAL_LAB_COST)
, 0) AS LABOR
, NVL(SUM(T1.ACTUAL_EQP_COST)
, 0) AS EQUIPMENT
FROM CST_EAM_ASSET_PER_BALANCES T1 GROUP BY T1.INVENTORY_ITEM_ID
, T1.ORGANIZATION_ID
, T1.SERIAL_NUMBER
, T1.PERIOD_SET_NAME
, T1.PERIOD_NAME
, T1.PERIOD_START_DATE) CS
, MTL_SYSTEM_ITEMS_B_KFV MI
WHERE MI.INVENTORY_ITEM_ID = CS.INV_ID
AND MI.ORGANIZATION_ID = CS.ORG_ID ORDER BY PERIOD_START_DATE ASC
Columns
Name |
INV_ID |
CONCATENATED_SEGMENTS |
ORG_ID |
SERIAL_NUMBER |
PERIOD_SET_NAME |
PERIOD_NAME |
PERIOD_START_DATE |
TOTAL |
MATERIAL |
LABOR |
EQUIPMENT |