VIEW: AHL.AHL_UNIT_EFFECTIVITIES_B#

Source

View Text - Preformatted

select UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID, 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, CSI_ITEM_INSTANCE_ID CSI_ITEM_INSTANCE_ID, MR_HEADER_ID MR_HEADER_ID, MR_EFFECTIVITY_ID MR_EFFECTIVITY_ID, MR_INTERVAL_ID MR_INTERVAL_ID, STATUS_CODE STATUS_CODE, DUE_DATE DUE_DATE, 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, SET_DUE_DATE SET_DUE_DATE, ACCOMPLISHED_DATE ACCOMPLISHED_DATE, SERVICE_LINE_ID SERVICE_LINE_ID, PROGRAM_MR_HEADER_ID PROGRAM_MR_HEADER_ID, CANCEL_REASON_CODE CANCEL_REASON_CODE, SECURITY_GROUP_ID SECURITY_GROUP_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, EARLIEST_DUE_DATE EARLIEST_DUE_DATE, LATEST_DUE_DATE LATEST_DUE_DATE, DEFER_FROM_UE_ID DEFER_FROM_UE_ID, ORIG_DEFERRAL_UE_ID ORIG_DEFERRAL_UE_ID, QA_COLLECTION_ID QA_COLLECTION_ID, CS_INCIDENT_ID CS_INCIDENT_ID, OBJECT_TYPE OBJECT_TYPE, APPLICATION_USG_CODE APPLICATION_USG_CODE, COUNTER_ID COUNTER_ID, MANUALLY_PLANNED_FLAG MANUALLY_PLANNED_FLAG, LOG_SERIES_CODE LOG_SERIES_CODE, LOG_SERIES_NUMBER LOG_SERIES_NUMBER, FLIGHT_NUMBER FLIGHT_NUMBER, MEL_CDL_TYPE_CODE MEL_CDL_TYPE_CODE, POSITION_PATH_ID POSITION_PATH_ID, ATA_CODE ATA_CODE, CLEAR_STATION_ORG_ID CLEAR_STATION_ORG_ID, CLEAR_STATION_DEPT_ID CLEAR_STATION_DEPT_ID, UNIT_CONFIG_HEADER_ID UNIT_CONFIG_HEADER_ID, ORIGINATING_WO_ID ORIGINATING_WO_ID, FLEET_HEADER_ID FLEET_HEADER_ID, ACCOMPLISH_TRIGGER_TYPE ACCOMPLISH_TRIGGER_TYPE, START_LC_UE_ID START_LC_UE_ID, LOOP_CHAIN_SEQ_NUM LOOP_CHAIN_SEQ_NUM, TERMINATING_UE_ID TERMINATING_UE_ID, QA_INSPECTION_TYPE QA_INSPECTION_TYPE from "AHL"."AHL_UNIT_EFFECTIVITIES_B"

View Text - HTML Formatted

SELECT UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID
, 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
, CSI_ITEM_INSTANCE_ID CSI_ITEM_INSTANCE_ID
, MR_HEADER_ID MR_HEADER_ID
, MR_EFFECTIVITY_ID MR_EFFECTIVITY_ID
, MR_INTERVAL_ID MR_INTERVAL_ID
, STATUS_CODE STATUS_CODE
, DUE_DATE DUE_DATE
, 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
, SET_DUE_DATE SET_DUE_DATE
, ACCOMPLISHED_DATE ACCOMPLISHED_DATE
, SERVICE_LINE_ID SERVICE_LINE_ID
, PROGRAM_MR_HEADER_ID PROGRAM_MR_HEADER_ID
, CANCEL_REASON_CODE CANCEL_REASON_CODE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, EARLIEST_DUE_DATE EARLIEST_DUE_DATE
, LATEST_DUE_DATE LATEST_DUE_DATE
, DEFER_FROM_UE_ID DEFER_FROM_UE_ID
, ORIG_DEFERRAL_UE_ID ORIG_DEFERRAL_UE_ID
, QA_COLLECTION_ID QA_COLLECTION_ID
, CS_INCIDENT_ID CS_INCIDENT_ID
, OBJECT_TYPE OBJECT_TYPE
, APPLICATION_USG_CODE APPLICATION_USG_CODE
, COUNTER_ID COUNTER_ID
, MANUALLY_PLANNED_FLAG MANUALLY_PLANNED_FLAG
, LOG_SERIES_CODE LOG_SERIES_CODE
, LOG_SERIES_NUMBER LOG_SERIES_NUMBER
, FLIGHT_NUMBER FLIGHT_NUMBER
, MEL_CDL_TYPE_CODE MEL_CDL_TYPE_CODE
, POSITION_PATH_ID POSITION_PATH_ID
, ATA_CODE ATA_CODE
, CLEAR_STATION_ORG_ID CLEAR_STATION_ORG_ID
, CLEAR_STATION_DEPT_ID CLEAR_STATION_DEPT_ID
, UNIT_CONFIG_HEADER_ID UNIT_CONFIG_HEADER_ID
, ORIGINATING_WO_ID ORIGINATING_WO_ID
, FLEET_HEADER_ID FLEET_HEADER_ID
, ACCOMPLISH_TRIGGER_TYPE ACCOMPLISH_TRIGGER_TYPE
, START_LC_UE_ID START_LC_UE_ID
, LOOP_CHAIN_SEQ_NUM LOOP_CHAIN_SEQ_NUM
, TERMINATING_UE_ID TERMINATING_UE_ID
, QA_INSPECTION_TYPE QA_INSPECTION_TYPE
FROM "AHL"."AHL_UNIT_EFFECTIVITIES_B"