VIEW: APPS.AHL_UNIT_EFFECTIVITIES_APP_V

Source

View Text - Preformatted

SELECT UE.UNIT_EFFECTIVITY_ID, UE.OBJECT_VERSION_NUMBER, UE.LAST_UPDATE_DATE, UE.LAST_UPDATED_BY, UE.CREATION_DATE, UE.CREATED_BY, UE.LAST_UPDATE_LOGIN, UE.CSI_ITEM_INSTANCE_ID, UE.MR_INTERVAL_ID, UE.MR_EFFECTIVITY_ID, UE.MR_HEADER_ID, UE.STATUS_CODE, UE.EARLIEST_DUE_DATE, UE.DUE_DATE, UE.LATEST_DUE_DATE, UE.DUE_COUNTER_VALUE, UE.FORECAST_SEQUENCE, UE.REPETITIVE_MR_FLAG, UE.TOLERANCE_FLAG, UE.MESSAGE_CODE, UE.DATE_RUN, UE.PRECEDING_UE_ID, UE.SET_DUE_DATE, UE.ACCOMPLISHED_DATE, UE.SERVICE_LINE_ID, UE.PROGRAM_MR_HEADER_ID, UE.CANCEL_REASON_CODE, UE.SECURITY_GROUP_ID, UE.ATTRIBUTE_CATEGORY, UE.ATTRIBUTE1, UE.ATTRIBUTE2, UE.ATTRIBUTE3, UE.ATTRIBUTE4, UE.ATTRIBUTE5, UE.ATTRIBUTE6, UE.ATTRIBUTE7, UE.ATTRIBUTE8, UE.ATTRIBUTE9, UE.ATTRIBUTE10, UE.ATTRIBUTE11, UE.ATTRIBUTE12, UE.ATTRIBUTE13, UE.ATTRIBUTE14, UE.ATTRIBUTE15, UE.REMARKS, UE.DEFER_FROM_UE_ID, UE.ORIG_DEFERRAL_UE_ID, UE.QA_COLLECTION_ID, UE.CS_INCIDENT_ID, UE.OBJECT_TYPE, UE.APPLICATION_USG_CODE, UE.COUNTER_ID, UE.MANUALLY_PLANNED_FLAG, UE.log_series_code, UE.log_series_number, UE.flight_number, UE.mel_cdl_type_code, UE.position_path_id, UE.ata_code, UE.clear_station_org_id, UE.clear_station_dept_id, UE.unit_config_header_id, UE.ORIGINATING_WO_ID from AHL_UNIT_EFFECTIVITIES_VL UE WHERE APPLICATION_USG_CODE=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')))

View Text - HTML Formatted

SELECT UE.UNIT_EFFECTIVITY_ID
, UE.OBJECT_VERSION_NUMBER
, UE.LAST_UPDATE_DATE
, UE.LAST_UPDATED_BY
, UE.CREATION_DATE
, UE.CREATED_BY
, UE.LAST_UPDATE_LOGIN
, UE.CSI_ITEM_INSTANCE_ID
, UE.MR_INTERVAL_ID
, UE.MR_EFFECTIVITY_ID
, UE.MR_HEADER_ID
, UE.STATUS_CODE
, UE.EARLIEST_DUE_DATE
, UE.DUE_DATE
, UE.LATEST_DUE_DATE
, UE.DUE_COUNTER_VALUE
, UE.FORECAST_SEQUENCE
, UE.REPETITIVE_MR_FLAG
, UE.TOLERANCE_FLAG
, UE.MESSAGE_CODE
, UE.DATE_RUN
, UE.PRECEDING_UE_ID
, UE.SET_DUE_DATE
, UE.ACCOMPLISHED_DATE
, UE.SERVICE_LINE_ID
, UE.PROGRAM_MR_HEADER_ID
, UE.CANCEL_REASON_CODE
, UE.SECURITY_GROUP_ID
, UE.ATTRIBUTE_CATEGORY
, UE.ATTRIBUTE1
, UE.ATTRIBUTE2
, UE.ATTRIBUTE3
, UE.ATTRIBUTE4
, UE.ATTRIBUTE5
, UE.ATTRIBUTE6
, UE.ATTRIBUTE7
, UE.ATTRIBUTE8
, UE.ATTRIBUTE9
, UE.ATTRIBUTE10
, UE.ATTRIBUTE11
, UE.ATTRIBUTE12
, UE.ATTRIBUTE13
, UE.ATTRIBUTE14
, UE.ATTRIBUTE15
, UE.REMARKS
, UE.DEFER_FROM_UE_ID
, UE.ORIG_DEFERRAL_UE_ID
, UE.QA_COLLECTION_ID
, UE.CS_INCIDENT_ID
, UE.OBJECT_TYPE
, UE.APPLICATION_USG_CODE
, UE.COUNTER_ID
, UE.MANUALLY_PLANNED_FLAG
, UE.LOG_SERIES_CODE
, UE.LOG_SERIES_NUMBER
, UE.FLIGHT_NUMBER
, UE.MEL_CDL_TYPE_CODE
, UE.POSITION_PATH_ID
, UE.ATA_CODE
, UE.CLEAR_STATION_ORG_ID
, UE.CLEAR_STATION_DEPT_ID
, UE.UNIT_CONFIG_HEADER_ID
, UE.ORIGINATING_WO_ID
FROM AHL_UNIT_EFFECTIVITIES_VL UE
WHERE APPLICATION_USG_CODE=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')))