VIEW: APPS.CST_EAM_ROLLUP_BYPERIODS_VAR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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