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_WARRANTY_ENTITLEMENTS

Object Details

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

This table stores information about entitlement records

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AHL_WARRANTY_ENTITLEMENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WARRANTY_ENTITLEMENT_ID ENTITLEMENT_STATUS_CODE
AHL_WARRANTY_ENTITLEMENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VISIT_TASK_ID ENTITLEMENT_STATUS_CODE
AHL_WARRANTY_ENTITLEMENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OSP_ORDER_LINE_ID ENTITLEMENT_STATUS_CODE
AHL_WARRANTY_ENTITLEMENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	WORKORDER_ID ENTITLEMENT_STATUS_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
WARRANTY_ENTITLEMENT_ID	NUMBER		Yes	Warranty Entitlement Id
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object Version Number
LAST_UPDATE_DATE	DATE		Yes	Last Update Date
LAST_UPDATED_BY	NUMBER		Yes	Last Updated by
CREATION_DATE	DATE		Yes	Creation date
CREATED_BY	NUMBER		Yes	Created By
LAST_UPDATE_LOGIN	NUMBER			Last Update Login
WARRANTY_CONTRACT_ID	NUMBER			Warranty Contract ID
OLD_WARRANTY_CONTRACT_ID	NUMBER			Old Warranty Contract Id
ENTITLEMENT_STATUS_CODE	VARCHAR2	(30)	Yes	Entitlement Status Code
WARRANTY_CLAIM_ID	NUMBER			Warranty Claim Id
PO_HEADER_ID	NUMBER			PO Header Id
SR_INCIDENT_ID	NUMBER			SR Incident ID
WORKORDER_ID	NUMBER			Workorder ID
VISIT_TASK_ID	NUMBER			Visit Task Id
OSP_ORDER_LINE_ID	NUMBER			OSP Order Line Id
WARRANTY_LABOUR_CAPTURE	VARCHAR2	(1)		Warranty Labour Capture
WARRANTY_MTL_CAPTURE	VARCHAR2	(1)		Warranty Material Capture
ORDER_CLAIM_AMOUNT	NUMBER			Warranty Claim Amount
SECURITY_GROUP_ID	NUMBER			Security Group Id
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Attribute Category
ATTRIBUTE1	VARCHAR2	(150)		Attribute1
ATTRIBUTE2	VARCHAR2	(150)		Attribute2
ATTRIBUTE3	VARCHAR2	(150)		Attribute3
ATTRIBUTE4	VARCHAR2	(150)		Attribute4
ATTRIBUTE5	VARCHAR2	(150)		Attribute5
ATTRIBUTE6	VARCHAR2	(150)		Attribute6
ATTRIBUTE7	VARCHAR2	(150)		Attribute7
ATTRIBUTE8	VARCHAR2	(150)		Attribute8
ATTRIBUTE9	VARCHAR2	(150)		Attribute9
ATTRIBUTE10	VARCHAR2	(150)		Attribute10
ATTRIBUTE11	VARCHAR2	(150)		Attribute11
ATTRIBUTE12	VARCHAR2	(150)		Attribute12
ATTRIBUTE13	VARCHAR2	(150)		Attribute13
ATTRIBUTE14	VARCHAR2	(150)		Attribute14
ATTRIBUTE15	VARCHAR2	(150)		Attribute15

Query Text

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


SELECT WARRANTY_ENTITLEMENT_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      WARRANTY_CONTRACT_ID
,      OLD_WARRANTY_CONTRACT_ID
,      ENTITLEMENT_STATUS_CODE
,      WARRANTY_CLAIM_ID
,      PO_HEADER_ID
,      SR_INCIDENT_ID
,      WORKORDER_ID
,      VISIT_TASK_ID
,      OSP_ORDER_LINE_ID
,      WARRANTY_LABOUR_CAPTURE
,      WARRANTY_MTL_CAPTURE
,      ORDER_CLAIM_AMOUNT
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM AHL.AHL_WARRANTY_ENTITLEMENTS;

Dependencies

[top of page]

AHL.AHL_WARRANTY_ENTITLEMENTS does not reference any database object

AHL.AHL_WARRANTY_ENTITLEMENTS is referenced by following:

AHL: AHL_WARRANTY_ENTITLEMENTS#