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_DEFERRALS_VL

Object Details

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

View Type

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

This view stores the query to retrieve unit deferral information based on the base table ( AHL_UNIT_DEFERRALS_B ) and TL ( AHL_UNIT_DEFERRAL_TL ) tables.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row Id for AHL_UNIT_EFFECTIVITIES_VL
UNIT_DEFERRAL_ID	NUMBER		Yes	Primary Key, unique identifier for a Unit Effectivity deferral detail.
UNIT_EFFECTIVITY_ID	NUMBER		Yes	FK to Ahl_unit_effectivities_b.
UNIT_DEFERRAL_TYPE	VARCHAR2	(30)	Yes	System deferral type.
SET_DUE_DATE	DATE			Manually set duedate at either initialization or at the time of deferring a Maintenance requirement has been deferring a Maintenance Requirement.
APPROVAL_STATUS_CODE	VARCHAR2	(30)		The deferral approval status code.
SKIP_MR_FLAG	VARCHAR2	(1)		Flag to denote if the MR has been skipped. Takes values 'Y' or 'N'.
CANCEL_FLAG	VARCHAR2	(1)		Cancel Flag. Possible Values "Y" or "N".
AFFECT_DUE_CALC_FLAG	VARCHAR2	(1)		Flag to denote if the Deferral due date affects the future due dates for the Maintenance requirement. Takes values 'Y' and 'N'.
DEFER_REASON_CODE	VARCHAR2	(240)		Reason codes for the deferral.
DEFERRAL_EFFECTIVE_ON	DATE			Deferral effective date.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores locking sequence number.
REMARKS	VARCHAR2	(4000)		Remarks for the deferral.
APPROVER_NOTES	VARCHAR2	(4000)		Approver notes, if any, captured when the deferral is rejected by the approver.
ATA_SEQUENCE_ID	NUMBER			ATA sequence of the Non-routine after MEL/CDL qualification (based on POSITION_PATH_ID, ATA_CODE and MEL_CDL_TYPE_CODE of the unit effectivity)
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.
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
USER_DEFERRAL_TYPE	VARCHAR2	(240)		Internal ID for user defined deferral type.

Query Text

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


SELECT ROW_ID
,      UNIT_DEFERRAL_ID
,      UNIT_EFFECTIVITY_ID
,      UNIT_DEFERRAL_TYPE
,      SET_DUE_DATE
,      APPROVAL_STATUS_CODE
,      SKIP_MR_FLAG
,      CANCEL_FLAG
,      AFFECT_DUE_CALC_FLAG
,      DEFER_REASON_CODE
,      DEFERRAL_EFFECTIVE_ON
,      OBJECT_VERSION_NUMBER
,      REMARKS
,      APPROVER_NOTES
,      ATA_SEQUENCE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      USER_DEFERRAL_TYPE
FROM APPS.AHL_UNIT_DEFERRALS_VL;

Dependencies

[top of page]

APPS.AHL_UNIT_DEFERRALS_VL references the following:

APPS: AHL_UNIT_DEFERRALS_B; AHL_UNIT_DEFERRALS_TL

APPS.AHL_UNIT_DEFERRALS_VL is referenced by following:

APPS: AHL_PRD_DF_PVT - show dependent code; AHL_UMP_NONROUTINES_PVT - show dependent code; AHL_UMP_UNITMAINT_PVT - show dependent code