[Home] [Help]
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
Name |
UF_HEADER_ID |
UNIT_CONFIG_HEADER_ID |
PC_NODE_ID |
INVENTORY_ORG_ID |
INVENTORY_ITEM_ID |
CSI_ITEM_INSTANCE_ID |
USE_UNIT_FLAG |
UF_DETAIL_ID |
UOM_CODE |
START_DATE |
END_DATE |
USAGE_PER_DAY |