VIEW: APPS.AHL_UTILIZATION_FORECAST_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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