View: CST_EAM_ASSET_BY_DEPT_VAR_V

Product:	BOM - Bills of Material
Description:	Asset Variance Cost by Maintenance Department Type
Implementation/DBA Data:	APPS.CST_EAM_ASSET_BY_DEPT_VAR_V

View Text

SELECT CEAD.PERIOD_SET_NAME
, CEAD.PERIOD_NAME
, CEAD.PERIOD_START_DATE
, CEAD.NAME
, CEAD.INV_ID
, CEAD.CONCATENATED_SEGMENTS
, CEAD.ORG_ID
, CEAD.SERIAL_NUMBER
, (- CEAD.TOTAL + CEADE.TOTAL) AS TOTAL
, (- CEAD.MATERIAL + CEADE.MATERIAL) AS MATERIAL
, (- CEAD.LABOR + CEADE.LABOR) AS LABOR
, (- CEAD.EQUIPMENT + CEADE.EQUIPMENT) AS EQUIPMENT
FROM CST_EAM_ASSET_BY_DEPT_V CEAD
, CST_EAM_ASSET_BY_DEPT_EST_V CEADE
WHERE CEAD.PERIOD_SET_NAME = CEADE.PERIOD_SET_NAME
AND CEAD.PERIOD_NAME = CEADE.PERIOD_NAME
AND CEAD.PERIOD_START_DATE = CEADE.PERIOD_START_DATE
AND CEAD.NAME = CEADE.NAME
AND CEAD.INV_ID = CEADE.INV_ID
AND CEAD.CONCATENATED_SEGMENTS = CEADE.CONCATENATED_SEGMENTS
AND CEAD.ORG_ID = CEADE.ORG_ID
AND CEAD.SERIAL_NUMBER = CEADE.SERIAL_NUMBER

Columns