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_UE_DEFERRAL_DETAILS_V

Object Details

Object Name:	AHL_UE_DEFERRAL_DETAILS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_UE_DEFERRAL_DETAILS_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	Mandatory	Comments
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
CSI_ITEM_INSTANCE_ID	NUMBER		Yes	Unique internal identifier for the item instance from Installed Base. (FK to CSI_ITEM_INSTANCES).
MR_HEADER_ID	NUMBER			Header ID of the MR
INSTANCE_NUMBER	VARCHAR2	(30)	Yes	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.
UE_STATUS_CODE	VARCHAR2	(30)		Unit Effectivity status code.
UE_STATUS	VARCHAR2	(80)		Unit Effectivity status meaning.
UMP_STATUS_CODE	VARCHAR2	(30)		Unit Effectivity status code including the deferral status.
DEF_STATUS_CODE	VARCHAR2	(30)		Unit Effectivity's deferral approval status code.
DEF_STATUS	VARCHAR2	(80)		Unit Effectivity's deferral approval status meaning.
REPETITIVE_MR_FLAG	VARCHAR2	(1)		This will be set to 'Y' if the MR is from repetitivity else will b set to 'N'.
TITLE	VARCHAR2	(80)		The unit effectivity's MR title.
VERSION_NUMBER	NUMBER			The unit effectivity's Version Number.
DESCRIPTION	VARCHAR2	(2000)		MR description.
REVISION	VARCHAR2	(30)		Revision of the MR.
QA_INSPECTION_TYPE_CODE	VARCHAR2	(150)		The inspection type setup for at the Maintenance requirement.
CATEGORY_CODE	VARCHAR2	(30)		User-defined MR category
CATEGORY	VARCHAR2	(80)		User-defined MR category description
PROGRAM_TYPE_CODE	VARCHAR2	(30)		User-defined MR program type
PROGRAM_TYPE	VARCHAR2	(80)		User-defined MR program type description
PROGRAM_SUBTYPE_CODE	VARCHAR2	(30)		User-defined MR program subtype
PROGRAM_SUBTYPE	VARCHAR2	(80)		User-defined MR program subtype description
EFFECTIVE_FROM	DATE			Effective start date of this MR. Only one revision of MR can be effective at any time instance.
EFFECTIVE_TO	DATE			Effective end date of this MR. Only one revision of MR can be effective at any time instance.
ORIG_DEFERRAL_UE_ID	NUMBER			The unit effectivity 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.
CS_INCIDENT_NUMBER	VARCHAR2	(64)		Incident Number
CS_INCIDENT_SUMMARY	VARCHAR2	(240)		Incident Summary
QA_PLAN_ID	NUMBER			The quality plan ID. FK to QA_PLANS.
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)
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
MANUALLY_PLANNED_FLAG	VARCHAR2	(1)		Indicates the source of the Unit Effectivity - by forecast one or by planning.
ORIGINATING_WO_ID	NUMBER			Unique identifier for Originating Work Order.

Query Text

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


SELECT UNIT_EFFECTIVITY_ID
,      OBJECT_VERSION_NUMBER
,      CSI_ITEM_INSTANCE_ID
,      MR_HEADER_ID
,      INSTANCE_NUMBER
,      EARLIEST_DUE_DATE
,      DUE_DATE
,      LATEST_DUE_DATE
,      UE_STATUS_CODE
,      UE_STATUS
,      UMP_STATUS_CODE
,      DEF_STATUS_CODE
,      DEF_STATUS
,      REPETITIVE_MR_FLAG
,      TITLE
,      VERSION_NUMBER
,      DESCRIPTION
,      REVISION
,      QA_INSPECTION_TYPE_CODE
,      CATEGORY_CODE
,      CATEGORY
,      PROGRAM_TYPE_CODE
,      PROGRAM_TYPE
,      PROGRAM_SUBTYPE_CODE
,      PROGRAM_SUBTYPE
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      ORIG_DEFERRAL_UE_ID
,      QA_COLLECTION_ID
,      CS_INCIDENT_ID
,      CS_INCIDENT_NUMBER
,      CS_INCIDENT_SUMMARY
,      QA_PLAN_ID
,      APPLICATION_USG_CODE
,      OBJECT_TYPE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      MANUALLY_PLANNED_FLAG
,      ORIGINATING_WO_ID
FROM APPS.AHL_UE_DEFERRAL_DETAILS_V;

Dependencies

[top of page]

APPS.AHL_UE_DEFERRAL_DETAILS_V references the following:

APPS: AHL_MR_HEADERS_V; AHL_UNIT_DEFERRALS_B; AHL_UNIT_EFFECTIVITIES_APP_V; AHL_VISITS_B; AHL_VISIT_TASKS_B; CSI_ITEM_INSTANCES; CS_INCIDENTS_ALL_VL; FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES_VL; FND_PROFILE - show dependent code; QA_PLANS_VAL_V; QA_PLAN_COLLECTION_TRIGGERS; QA_PLAN_TRANSACTIONS; QA_RESULTS

APPS.AHL_UE_DEFERRAL_DETAILS_V is referenced by following:

APPS: AHL_MR_INSTANCES_V; AHL_PRD_DF_PVT - show dependent code; AHL_SRH_WO_HISTORY_V