View: CST_EAM_ROLLUP_BY_DEPT_VAR_V

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

View Text

SELECT CERD.GROUP_ID
, CERD.PERIOD_SET_NAME
, CERD.PERIOD_NAME
, CERD.PERIOD_START_DATE
, CERD.NAME
, CERD.INV_ID
, CERD.CONCATENATED_SEGMENTS
, CERD.ORG_ID
, CERD.SERIAL_NUMBER
, (- CERD.TOTAL + CERDE.TOTAL) AS TOTAL
, (- CERD.MATERIAL + CERDE.MATERIAL) AS MATERIAL
, (- CERD.LABOR + CERDE.LABOR) AS LABOR
, (- CERD.EQUIPMENT + CERDE.EQUIPMENT) AS EQUIPMENT
FROM CST_EAM_ROLLUP_BY_DEPT_V CERD
, CST_EAM_ROLLUP_BY_DEPT_EST_V CERDE
WHERE CERD.GROUP_ID = CERDE.GROUP_ID
AND CERD.PERIOD_SET_NAME = CERDE.PERIOD_SET_NAME
AND CERD.PERIOD_NAME = CERDE.PERIOD_NAME
AND CERD.PERIOD_START_DATE = CERDE.PERIOD_START_DATE
AND CERD.NAME = CERDE.NAME
AND CERD.INV_ID = CERDE.INV_ID
AND CERD.CONCATENATED_SEGMENTS = CERDE.CONCATENATED_SEGMENTS
AND CERD.ORG_ID = CERDE.ORG_ID
AND CERD.SERIAL_NUMBER = CERDE.SERIAL_NUMBER

Columns