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]

TABLE: AHL.AHL_UNIT_DEFERRALS_B

Object Details

Object Name:	AHL_UNIT_DEFERRALS_B
Object Type:	TABLE
Owner:	AHL
FND Design Data:	AHL.AHL_UNIT_DEFERRALS_B
Subobject Name:
Status:	VALID

This table holds the deferral and MR initialization information for a unit effectivity.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AHL_UNIT_DEFERRALS_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	UNIT_DEFERRAL_ID
AHL_UNIT_DEFERRALS_B_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	UNIT_EFFECTIVITY_ID UNIT_DEFERRAL_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
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. For internal use only.
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'.
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.
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.
SECURITY_GROUP_ID	NUMBER			Used in application hosting
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
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 for the unit effectivity)
USER_DEFERRAL_TYPE	VARCHAR2	(240)		User defined Deferral type.
CANCEL_FLAG	VARCHAR2	(1)		Cancel Flag. Takes value "Y" or "N"

Query Text

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


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

Dependencies

[top of page]

AHL.AHL_UNIT_DEFERRALS_B does not reference any database object

AHL.AHL_UNIT_DEFERRALS_B is referenced by following:

AHL: AHL_UNIT_DEFERRALS_B#