View: CST_EAM_ASSET_BY_PERIODS_VAR_V

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

View Text

SELECT CEAP.INV_ID
, CEAP.CONCATENATED_SEGMENTS
, CEAP.ORG_ID
, CEAP.SERIAL_NUMBER
, CEAP.PERIOD_SET_NAME
, CEAP.PERIOD_NAME
, CEAP.PERIOD_START_DATE
, (- CEAP.TOTAL + CEAPE.TOTAL) AS TOTAL
, (- CEAP.MATERIAL + CEAPE.MATERIAL) AS MATERIAL
, (- CEAP.LABOR + CEAPE.LABOR) AS LABOR
, (- CEAP.EQUIPMENT + CEAPE.EQUIPMENT) AS EQUIPMENT
FROM CST_EAM_ASSET_BY_PERIODS_V CEAP
, CST_EAM_ASSET_BY_PERIODS_EST_V CEAPE
WHERE CEAP.PERIOD_SET_NAME = CEAPE.PERIOD_SET_NAME
AND CEAP.PERIOD_NAME = CEAPE.PERIOD_NAME
AND CEAP.PERIOD_START_DATE = CEAPE.PERIOD_START_DATE
AND CEAP.INV_ID = CEAPE.INV_ID
AND CEAP.CONCATENATED_SEGMENTS = CEAPE.CONCATENATED_SEGMENTS
AND CEAP.ORG_ID = CEAPE.ORG_ID
AND CEAP.SERIAL_NUMBER = CEAPE.SERIAL_NUMBER

Columns