View: AHL_UNIT_EFFECTIVITIES_APP_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	This view stores the query to retrieve unit effectivities information based on the base( AHL_UNIT_EFFECTIVITIES_B ) and TL ( AHL_UNIT_EFFECTIVITIES_TL ) tables striped by the language and application usage code.
Implementation/DBA Data:	APPS.AHL_UNIT_EFFECTIVITIES_APP_V

View Text

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
FROM AHL_UNIT_EFFECTIVITIES_VL UE
WHERE APPLICATION_USG_CODE=RTRIM(LTRIM(FND_PROFILE.VALUE('AHL_APPLN_USAGE')))

Columns