View: AHL_UTILIZATION_FORECAST_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view holds the utilization forecast header information and utilization forcast details.
Implementation/DBA Data:	APPS.AHL_UTILIZATION_FORECAST_V

View Text

SELECT AUH.UF_HEADER_ID
, AUH.UNIT_CONFIG_HEADER_ID
, AUH.PC_NODE_ID
, AUH.INVENTORY_ORG_ID
, AUH.INVENTORY_ITEM_ID
, AUH.CSI_ITEM_INSTANCE_ID
, AUH.USE_UNIT_FLAG
, AUD.UF_DETAIL_ID
, AUD.UOM_CODE
, AUD.START_DATE
, AUD.END_DATE
, AUD.USAGE_PER_DAY
FROM AHL_UF_HEADERS AUH
, AHL_UF_DETAILS AUD
WHERE AUH.UF_HEADER_ID = AUD.UF_HEADER_ID

Columns