DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.AHL_WARRANTY_CONTRACTS_VL

Object Details
Object Name: AHL_WARRANTY_CONTRACTS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_WARRANTY_CONTRACTS_VL
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
ROW_ID ROWID (10)
Rowid
WARRANTY_CONTRACT_ID NUMBER
Yes Contract id
OBJECT_VERSION_NUMBER NUMBER
Yes Object version 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

Security group id
CONTRACT_NUMBER NUMBER
Yes Contract number
CONTRACT_STATUS_CODE VARCHAR2 (30) Yes Contract status code
ITEM_INSTANCE_ID NUMBER
Yes Contract instance id
WARRANTY_TEMPLATE_ID NUMBER

Contract template id
EXPIRATION_DATE DATE

Contract expiration date
OSP_CLAIM_FLAG VARCHAR2 (1)
OSP claim flag
START_FROM_TYPE VARCHAR2 (30)
Contract start from type
COUNTER_START_TYPE VARCHAR2 (30)
Contract counter start from type
WARRANTY_TYPE VARCHAR2 (30) Yes Warranty type
WARRANTY_VENDOR_ID NUMBER
Yes Warranty vendor id
ACTIVE_START_DATE DATE
Yes Contract active start date
ACTIVE_END_DATE DATE

Contract active end date
WARRANTY_PERIOD NUMBER

Warranty period
PERIOD_UOM_CODE VARCHAR2 (30)
Period UOM code
CONTRACT_EXPIRY_TYPE VARCHAR2 (30) Yes Contract expiration date calculation type
CLAIM_LABOUR_HOURS NUMBER

Claim labour hours
REMARKS VARCHAR2 (4000)
Remarks
DESCRIPTION VARCHAR2 (4000)
Description
TERMS_AND_CONDITIONS VARCHAR2 (4000)
Terms and conditions
REACTION_AND_RESOL_TIME VARCHAR2 (4000)
Reaction and resolution time
SERVICE_LEVEL_AGREEMENT VARCHAR2 (4000)
Service level agreement
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Flexfield category
ATTRIBUTE1 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE2 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE3 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE4 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE5 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE6 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE7 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE8 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE9 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE10 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE11 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE12 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE13 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE14 VARCHAR2 (150)
Flexfield attribute
ATTRIBUTE15 VARCHAR2 (150)
Flexfield attribute
Query Text

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


SELECT ROW_ID
,      WARRANTY_CONTRACT_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      CONTRACT_NUMBER
,      CONTRACT_STATUS_CODE
,      ITEM_INSTANCE_ID
,      WARRANTY_TEMPLATE_ID
,      EXPIRATION_DATE
,      OSP_CLAIM_FLAG
,      START_FROM_TYPE
,      COUNTER_START_TYPE
,      WARRANTY_TYPE
,      WARRANTY_VENDOR_ID
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      WARRANTY_PERIOD
,      PERIOD_UOM_CODE
,      CONTRACT_EXPIRY_TYPE
,      CLAIM_LABOUR_HOURS
,      REMARKS
,      DESCRIPTION
,      TERMS_AND_CONDITIONS
,      REACTION_AND_RESOL_TIME
,      SERVICE_LEVEL_AGREEMENT
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.AHL_WARRANTY_CONTRACTS_VL;

Dependencies

[top of page]

APPS.AHL_WARRANTY_CONTRACTS_VL references the following:

SchemaAPPS
SynonymAHL_WARRANTY_CONTRACTS_B
SynonymAHL_WARRANTY_CONTRACTS_TL
APPS.AHL_WARRANTY_CONTRACTS_VL is referenced by following:

SchemaAPPS
Package BodyAHL_VWP_RULES_PVT - show dependent code