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_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
UNIT_EFFECTIVITY_ID	NUMBER		Internal identifier for the unit effectivity.
OBJECT_VERSION_NUMBER	NUMBER		Record version number.
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER		Standard Who column
CREATION_DATE	DATE		Standard Who column
CREATED_BY	NUMBER		Standard Who column
LAST_UPDATE_LOGIN	NUMBER		Standard Who column
MR_INTERVAL_ID	NUMBER		FK to AHL_MR_INTERVALS
CSI_ITEM_INSTANCE_ID	NUMBER		Unique internal identifier for the item instance from Installed Base. (FK to CSI_ITEM_INSTANCES).
MR_EFFECTIVITY_ID	NUMBER		Effectivity ID of the MR
MR_HEADER_ID	NUMBER		Header ID of the MR
UNIT_NAME	VARCHAR2	(4000)	Name of the Unit if present.
PART_NUMBER	VARCHAR2	(40)	Part Number from CSI Instance Details
SERIAL_NUMBER	VARCHAR2	(30)	Serial Number from CSI Instance Details
INSTANCE_NUMBER	VARCHAR2	(30)	Instance Number from CSI Instance Details
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		Due Date as calculated by "Calculate Due Date'.
LATEST_DUE_DATE	DATE		The forecasted latest due date. This is calculated based on the threhold's tolerance setup in Fleet Maintenance Program.
STATUS_CODE	VARCHAR2	(30)	Unit Effectivity status code.
STATUS	VARCHAR2	(80)	Unit Effectivity status meaning.
MESSAGE_CODE	VARCHAR2	(30)	Unit Effectivity message code.
MESSAGE	VARCHAR2	(80)	Unit Effectivity message meaning.
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.
TOLERANCE	VARCHAR2	(80)	Based on tolerance_flag this will be the YES_NO meaning from FND_LOOKUPS.
DATE_RUN	DATE		Date the unit effectivity was calculated.
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.
COUNTER_NAME	VARCHAR2	(80)	Name of the counter.
NET_READING	NUMBER		net reading of the counter.
REMARKS	VARCHAR2	(4000)	Remarks if any related to the Unit Effectivity.
PRECEDING_UE_ID	NUMBER		Unit Effectivity of any exieting preceding Unit Effectivity.
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'.
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.
TITLE	VARCHAR2	(155)	The unit effectivity's MR title.
VERSION_NUMBER	NUMBER		The unit effectivity's Version Number.
DESCRIPTION	VARCHAR2	(2000)	MR description.
PROGRAM_TYPE_CODE	VARCHAR2	(30)	MR Program Type Code.
PROGRAM_TYPE	VARCHAR2	(80)	MR Program Type Meaning.
IMPLEMENT_STATUS_CODE	VARCHAR2	(30)	MR Implement status code.
IMPLEMENT_STATUS	VARCHAR2	(80)	MR Implement status meaning.
CATEGORY_CODE	VARCHAR2	(30)	MR Category code
CATEGORY	VARCHAR2	(80)	MR Category meaning.
REVISION	VARCHAR2	(30)	Revision of the MR.
SERVICE_LINE_ID	NUMBER		The service line ID from Contracts (OKC_K_LINES_B).
SERVICE_LINE_NUMBER	VARCHAR2	(150)	The service Line Number from Contracts (OKC_K_LINES_B).
PROGRAM_MR_HEADER_ID	NUMBER		The Program MR ID to which the "Activity" MR (mr_header_id) belongs to.
CANCEL_REASON_CODE	VARCHAR2	(30)	The Cancellation reason code, relevant only in case the MR is not accomplished.
PROGRAM_TITLE	VARCHAR2	(80)	The MR title corressponding to the program_mr_header_id.
CONTRACT_NUMBER	VARCHAR2	(120)	The contract number(from OKC_K_HEADERS_B) to which the service_line_ID is associated to.
CONTRACT_NUMBER_MODIFIER	VARCHAR2	(120)	The Contract number modifier from OKC_K_HEADERS_B for the service_line_ID.
ORIGINATOR_TITLE	VARCHAR2	(155)	This will be the originators MR Title to which this component belongs to.
ORIG_UE_INSTANCE_ID	NUMBER		Item Instance ID of the originator MR.
DEPENDANT_TITLE	VARCHAR2	(80)	This will be the MR Title of the component which it is a dependant of.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)	Descriptive 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
DEFER_FROM_UE_ID	NUMBER		Link to the 'deferred from' unit effectivity ID.
DEFER_FROM_MR_TITLE	VARCHAR2	(80)	Title of the Deferred Unit Effectivity.
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.
CS_INCIDENT_NUMBER	VARCHAR2	(64)	Incident Number
CS_INCIDENT_SUMMARY	VARCHAR2	(240)	Incident Summary
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.
OBJECT_TYPE	VARCHAR2	(3)	Indicates the type of Unit Effectivity (MR = Maintenance Requirement, SR = Service Request)
COUNTER_ID	NUMBER		Indicates the counter that triggered the due date for Deferral and Initial Due thresholds.
MANUALLY_PLANNED_FLAG	VARCHAR2	(1)
MANUALLY_PLANNED_DESC	VARCHAR2	(80)

Query Text

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


SELECT UNIT_EFFECTIVITY_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      MR_INTERVAL_ID
,      CSI_ITEM_INSTANCE_ID
,      MR_EFFECTIVITY_ID
,      MR_HEADER_ID
,      UNIT_NAME
,      PART_NUMBER
,      SERIAL_NUMBER
,      INSTANCE_NUMBER
,      EARLIEST_DUE_DATE
,      DUE_DATE
,      LATEST_DUE_DATE
,      STATUS_CODE
,      STATUS
,      MESSAGE_CODE
,      MESSAGE
,      TOLERANCE_FLAG
,      TOLERANCE
,      DATE_RUN
,      DUE_COUNTER_VALUE
,      COUNTER_NAME
,      NET_READING
,      REMARKS
,      PRECEDING_UE_ID
,      FORECAST_SEQUENCE
,      REPETITIVE_MR_FLAG
,      SET_DUE_DATE
,      ACCOMPLISHED_DATE
,      TITLE
,      VERSION_NUMBER
,      DESCRIPTION
,      PROGRAM_TYPE_CODE
,      PROGRAM_TYPE
,      IMPLEMENT_STATUS_CODE
,      IMPLEMENT_STATUS
,      CATEGORY_CODE
,      CATEGORY
,      REVISION
,      SERVICE_LINE_ID
,      SERVICE_LINE_NUMBER
,      PROGRAM_MR_HEADER_ID
,      CANCEL_REASON_CODE
,      PROGRAM_TITLE
,      CONTRACT_NUMBER
,      CONTRACT_NUMBER_MODIFIER
,      ORIGINATOR_TITLE
,      ORIG_UE_INSTANCE_ID
,      DEPENDANT_TITLE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DEFER_FROM_UE_ID
,      DEFER_FROM_MR_TITLE
,      QA_COLLECTION_ID
,      CS_INCIDENT_ID
,      CS_INCIDENT_NUMBER
,      CS_INCIDENT_SUMMARY
,      APPLICATION_USG_CODE
,      OBJECT_TYPE
,      COUNTER_ID
,      MANUALLY_PLANNED_FLAG
,      MANUALLY_PLANNED_DESC
FROM APPS.AHL_UNIT_EFFECTIVITIES_V;

Dependencies

[top of page]

APPS.AHL_UNIT_EFFECTIVITIES_V references the following:

APPS: AHL_MR_HEADERS_B; AHL_MR_HEADERS_TL; AHL_MR_INTERVALS; AHL_UE_RELATIONSHIPS; AHL_UMP_UTIL_PKG - show dependent code; AHL_UNIT_EFFECTIVITIES_B; AHL_UNIT_EFFECTIVITIES_TL; CSI_COUNTER_TEMPLATE_VL; CSI_ITEM_INSTANCES; CS_INCIDENTS_ALL_B; CS_INCIDENTS_ALL_TL; CS_INCIDENT_TYPES_B; CS_INCIDENT_TYPES_TL; FND_LOOKUP_VALUES; FND_PROFILE - show dependent code; MTL_SYSTEM_ITEMS_KFV; OKC_K_HEADERS_ALL_B; OKC_K_LINES_B

APPS.AHL_UNIT_EFFECTIVITIES_V is referenced by following:

APPS: AHL_COMPLETIONS_PVT - show dependent code; AHL_PRD_DF_PVT - show dependent code; AHL_QA_RESULTS_PVT - show dependent code; AHL_UMP_SMRINSTANCE_PVT - show dependent code; AHL_VWP_RULES_PVT - show dependent code