View: CST_EAM_ROLLUP_BYPERIODS_VAR_V

Product:	BOM - Bills of Material
Description:	Asset Rollup Variance Cost by Period
Implementation/DBA Data:	APPS.CST_EAM_ROLLUP_BYPERIODS_VAR_V

View Text

SELECT CERP.GROUP_ID
, CERP.PERIOD_SET_NAME
, CERP.PERIOD_NAME
, CERP.PERIOD_START_DATE
, CERP.INV_ID
, CERP.CONCATENATED_SEGMENTS
, CERP.ORG_ID
, CERP.SERIAL_NUMBER
, (- CERP.TOTAL + CERPE.TOTAL) AS TOTAL
, (- CERP.MATERIAL + CERPE.MATERIAL) AS MATERIAL
, (- CERP.LABOR + CERPE.LABOR) AS LABOR
, (- CERP.EQUIPMENT + CERPE.EQUIPMENT) AS EQUIPMENT
FROM CST_EAM_ROLLUP_BY_PERIODS_V CERP
, CST_EAM_ROLLUP_BYPERIODS_EST_V CERPE
WHERE CERP.GROUP_ID = CERPE.GROUP_ID
AND CERP.PERIOD_SET_NAME = CERPE.PERIOD_SET_NAME
AND CERP.PERIOD_NAME = CERPE.PERIOD_NAME
AND CERP.PERIOD_START_DATE = CERPE.PERIOD_START_DATE
AND CERP.INV_ID = CERPE.INV_ID
AND CERP.CONCATENATED_SEGMENTS = CERPE.CONCATENATED_SEGMENTS
AND CERP.ORG_ID = CERPE.ORG_ID
AND CERP.SERIAL_NUMBER = CERPE.SERIAL_NUMBER

Columns