DBA Data[Home] [Help]

VIEW: AHL.AHL_UE_SIMULATIONS#

Source

View Text - Preformatted

select SIMULATION_UE_ID SIMULATION_UE_ID, SIMULATION_PLAN_ID SIMULATION_PLAN_ID, CSI_ITEM_INSTANCE_ID CSI_ITEM_INSTANCE_ID, MR_HEADER_ID MR_HEADER_ID, FLEET_HEADER_ID FLEET_HEADER_ID, UNIT_CONFIG_HEADER_ID UNIT_CONFIG_HEADER_ID, DUE_DATE DUE_DATE, STATUS_CODE STATUS_CODE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SECURITY_GROUP_ID SECURITY_GROUP_ID, MR_EFFECTIVITY_ID MR_EFFECTIVITY_ID, MR_INTERVAL_ID MR_INTERVAL_ID, DUE_COUNTER_VALUE DUE_COUNTER_VALUE, FORECAST_SEQUENCE FORECAST_SEQUENCE, REPETITIVE_MR_FLAG REPETITIVE_MR_FLAG, TOLERANCE_FLAG TOLERANCE_FLAG, MESSAGE_CODE MESSAGE_CODE, DATE_RUN DATE_RUN, PRECEDING_UE_ID PRECEDING_UE_ID, EARLIEST_DUE_DATE EARLIEST_DUE_DATE, LATEST_DUE_DATE LATEST_DUE_DATE, DEFER_FROM_UE_ID DEFER_FROM_UE_ID, CS_INCIDENT_ID CS_INCIDENT_ID, COUNTER_ID COUNTER_ID, UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID, ORIGINATOR_UE_ID ORIGINATOR_UE_ID, PARENT_UE_ID PARENT_UE_ID, MANUALLY_PLANNED_FLAG MANUALLY_PLANNED_FLAG from "AHL"."AHL_UE_SIMULATIONS"
View Text - HTML Formatted

SELECT SIMULATION_UE_ID SIMULATION_UE_ID
, SIMULATION_PLAN_ID SIMULATION_PLAN_ID
, CSI_ITEM_INSTANCE_ID CSI_ITEM_INSTANCE_ID
, MR_HEADER_ID MR_HEADER_ID
, FLEET_HEADER_ID FLEET_HEADER_ID
, UNIT_CONFIG_HEADER_ID UNIT_CONFIG_HEADER_ID
, DUE_DATE DUE_DATE
, STATUS_CODE STATUS_CODE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, MR_EFFECTIVITY_ID MR_EFFECTIVITY_ID
, MR_INTERVAL_ID MR_INTERVAL_ID
, DUE_COUNTER_VALUE DUE_COUNTER_VALUE
, FORECAST_SEQUENCE FORECAST_SEQUENCE
, REPETITIVE_MR_FLAG REPETITIVE_MR_FLAG
, TOLERANCE_FLAG TOLERANCE_FLAG
, MESSAGE_CODE MESSAGE_CODE
, DATE_RUN DATE_RUN
, PRECEDING_UE_ID PRECEDING_UE_ID
, EARLIEST_DUE_DATE EARLIEST_DUE_DATE
, LATEST_DUE_DATE LATEST_DUE_DATE
, DEFER_FROM_UE_ID DEFER_FROM_UE_ID
, CS_INCIDENT_ID CS_INCIDENT_ID
, COUNTER_ID COUNTER_ID
, UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID
, ORIGINATOR_UE_ID ORIGINATOR_UE_ID
, PARENT_UE_ID PARENT_UE_ID
, MANUALLY_PLANNED_FLAG MANUALLY_PLANNED_FLAG
FROM "AHL"."AHL_UE_SIMULATIONS"