VIEW: APPS.CST_EAM_ROLLUP_BY_DEPT_VAR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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