eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CST_EAM_ASSET_BY_PERIODS_VAR_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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