eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AHL_UNIT_EFFECTIVITIES_VL

Object Details

Object Name:	AHL_UNIT_EFFECTIVITIES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_UNIT_EFFECTIVITIES_VL
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

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.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id for AHL_UNIT_EFFECTIVITIES_VL
UNIT_EFFECTIVITY_ID	NUMBER		Yes	Primary Key, unique identifier of a Unit or item instance Effectivity.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores locking sequence number
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER		Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER			Standard Who column
CSI_ITEM_INSTANCE_ID	NUMBER		Yes	FK to CSI_ITEM_INSTANCES.
MR_INTERVAL_ID	NUMBER			FK to AHL_MR_INTERVALS. This is the threshold that was used to calculate the due date for this instance's mr effectivity.
MR_EFFECTIVITY_ID	NUMBER			FK to AHL_MR_EFFECTIVITIES. This effectivity got triggered from FMP module
MR_HEADER_ID	NUMBER			FK to AHL_MR_HEADERS_B
STATUS_CODE	VARCHAR2	(30)		Lookup codes defined in FND_LOOKUPS with lookup type = 'AHL_UNIT_EFFECTIVITY_STATUS'.
EARLIEST_DUE_DATE	DATE			The forecasted earliest due date. This is calculated based on the threhold's tolerance setup in Fleet Maintenance Program.
DUE_DATE	DATE			alculated due date based on MR_Interval_ID
LATEST_DUE_DATE	DATE			The forecasted latest due date. This is calculated based on the threhold's tolerance setup in Fleet Maintenance Program.
DUE_COUNTER_VALUE	NUMBER			The Counter Value (for the Counter associated to the MR_interval_id) at which this MR needs to be done. This value is calculated by "Calculate Due Date" API.
FORECAST_SEQUENCE	NUMBER			The sequence number in case of multiple instances of the same maintenance requirement for the same item instance in order of duedates ascending. Default is 1.
REPETITIVE_MR_FLAG	VARCHAR2	(1)		This will be set to 'Y' if the MR is from repetitivity else will b set to 'N'.
TOLERANCE_FLAG	VARCHAR2	(1)		This will be set to 'Y' if the associated Visit has a "Start Date" that is out of the range of tolerance allowance.
MESSAGE_CODE	VARCHAR2	(30)		message code
DATE_RUN	DATE			The date of estimated due date calculation and repetitive interval.
PRECEDING_UE_ID	NUMBER			The effectivity ID of the preceding Unit Effectivity. This effectivity can only triggered after its preceding effectivity
SET_DUE_DATE	DATE			Manually set duedate at initialization time or the due date has been provided by Production in cases where the Maintenance requirement has been defferred.
ACCOMPLISHED_DATE	DATE			The date the MR was accomplished on this instance.
SERVICE_LINE_ID	NUMBER
PROGRAM_MR_HEADER_ID	NUMBER
CANCEL_REASON_CODE	VARCHAR2	(30)
SECURITY_GROUP_ID	NUMBER			Used in application hosting
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		escriptive flexfield structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment column
REMARKS	VARCHAR2	(4000)		Remarks/comment sabout this effectivity
DEFER_FROM_UE_ID	NUMBER			Link to the 'deferred from' unit effectivity ID.
ORIG_DEFERRAL_UE_ID	NUMBER			Link to the unit effectivity ID governing the Deferral.
QA_COLLECTION_ID	NUMBER			Foreign key to QA_RESULTS table. Link to the captured QA results for the accomplished Unit Effectivity ID.
CS_INCIDENT_ID	NUMBER			Foreign key to CS_INCIDENTS_ALL_B.
OBJECT_TYPE	VARCHAR2	(3)		Indicates the type of Unit Effectivity (MR = Maintenance Requirement, SR = Service Request)
APPLICATION_USG_CODE	VARCHAR2	(30)		Indicates the application that the Unit Effectivity belongs to based on the MR's application usage. For a Service Request, this is always AHL.
COUNTER_ID	NUMBER			Indicates the Counter that triggered the due date in cases where counter based Initial Due or Deferral thresholds have been defined.
MANUALLY_PLANNED_FLAG	VARCHAR2	(1)		Manually Planned Flag
LOG_SERIES_CODE	VARCHAR2	(30)		Code part of the log series number of the Non-routine; Lookup from AHL_LOG_SERIES_CODE lookup type
LOG_SERIES_NUMBER	NUMBER			Number part of the log series number of the Non-routine
FLIGHT_NUMBER	VARCHAR2	(30)		Flight number of the flight for which Non-routine is logged
MEL_CDL_TYPE_CODE	VARCHAR2	(30)		MEL / CDL qualification type of the Non-routine; Lookup from AHL_MEL_CDL_TYPE lookup type
POSITION_PATH_ID	NUMBER			Position Path of the position for which Non-routine is logged
ATA_CODE	VARCHAR2	(30)		ATA Code of the instance for which Non-routine is logged; Lookup from AHL_ATA_CODE lookup type
CLEAR_STATION_ORG_ID	NUMBER			Location organization at which Non-routine is cleared / closed
CLEAR_STATION_DEPT_ID	NUMBER			Location department at which Non-routine is cleared / closed
UNIT_CONFIG_HEADER_ID	NUMBER			Unit Configuration for which the Non-routine was logged
ORIGINATING_WO_ID	NUMBER			Unique identifier for originating Work Order.
ACCOMPLISH_TRIGGER_TYPE	VARCHAR2	(30)		Indicates the accomplishment trigger type - LOOP or CHAIN
START_LC_UE_ID	NUMBER			Link to starting unit effectivity ID for the chain or loop.
LOOP_CHAIN_SEQ_NUM	NUMBER			Loop or Chain sequence number
TERMINATING_UE_ID	NUMBER			Present when maintenance is to be terminated by another requirement. This column links to the terminating unit effectivity Id
FLEET_HEADER_ID	NUMBER			Fleet header id
QA_INSPECTION_TYPE	VARCHAR2	(150)		Quality Inspection Type (for NonRoutines)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ROW_ID
,      UNIT_EFFECTIVITY_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CSI_ITEM_INSTANCE_ID
,      MR_INTERVAL_ID
,      MR_EFFECTIVITY_ID
,      MR_HEADER_ID
,      STATUS_CODE
,      EARLIEST_DUE_DATE
,      DUE_DATE
,      LATEST_DUE_DATE
,      DUE_COUNTER_VALUE
,      FORECAST_SEQUENCE
,      REPETITIVE_MR_FLAG
,      TOLERANCE_FLAG
,      MESSAGE_CODE
,      DATE_RUN
,      PRECEDING_UE_ID
,      SET_DUE_DATE
,      ACCOMPLISHED_DATE
,      SERVICE_LINE_ID
,      PROGRAM_MR_HEADER_ID
,      CANCEL_REASON_CODE
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REMARKS
,      DEFER_FROM_UE_ID
,      ORIG_DEFERRAL_UE_ID
,      QA_COLLECTION_ID
,      CS_INCIDENT_ID
,      OBJECT_TYPE
,      APPLICATION_USG_CODE
,      COUNTER_ID
,      MANUALLY_PLANNED_FLAG
,      LOG_SERIES_CODE
,      LOG_SERIES_NUMBER
,      FLIGHT_NUMBER
,      MEL_CDL_TYPE_CODE
,      POSITION_PATH_ID
,      ATA_CODE
,      CLEAR_STATION_ORG_ID
,      CLEAR_STATION_DEPT_ID
,      UNIT_CONFIG_HEADER_ID
,      ORIGINATING_WO_ID
,      ACCOMPLISH_TRIGGER_TYPE
,      START_LC_UE_ID
,      LOOP_CHAIN_SEQ_NUM
,      TERMINATING_UE_ID
,      FLEET_HEADER_ID
,      QA_INSPECTION_TYPE
FROM APPS.AHL_UNIT_EFFECTIVITIES_VL;

Dependencies

[top of page]

APPS.AHL_UNIT_EFFECTIVITIES_VL references the following:

APPS: AHL_UNIT_EFFECTIVITIES_B; AHL_UNIT_EFFECTIVITIES_TL

APPS.AHL_UNIT_EFFECTIVITIES_VL is referenced by following:

APPS: AHL_PRD_DF_PVT - show dependent code; AHL_PRD_VISITS_PVT - show dependent code; AHL_UMP_PROCESSUNIT_EXTN_PVT - show dependent code; AHL_UMP_PROCESSUNIT_PVT - show dependent code; AHL_UMP_UNITMAINT_PVT - show dependent code; AHL_UNIT_EFFECTIVITIES_APP_V; AHL_VWP_PLAN_TASKS_PVT - show dependent code; AHL_VWP_RULES_PVT - show dependent code; AHL_VWP_TASKS_PVT - show dependent code; AHL_VWP_VISITS_PVT - show dependent code; CSF_WF_EVENT_SUBSCR_PKG - show dependent code