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

TABLE: AHL.AHL_WARRANTY_CONTRACTS_B

Object Details
Object Name: AHL_WARRANTY_CONTRACTS_B
Object Type: TABLE
Owner: AHL
FND Design Data: TableAHL.AHL_WARRANTY_CONTRACTS_B
Subobject Name:
Status: VALID


Base table for storing Warranty Contracts.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AHL_WARRANTY_CONTRACTS_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWARRANTY_CONTRACT_ID
AHL_WARRANTY_CONTRACTS_B_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONTRACT_NUMBER
ColumnCONTRACT_STATUS_CODE
AHL_WARRANTY_CONTRACTS_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnITEM_INSTANCE_ID
ColumnCONTRACT_STATUS_CODE
Columns
Name Datatype Length Mandatory Comments
WARRANTY_CONTRACT_ID NUMBER
Yes Primary Key
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
CONTRACT_NUMBER NUMBER
Yes Warranty contract number
CONTRACT_STATUS_CODE VARCHAR2 (30) Yes Contract's status code
ITEM_INSTANCE_ID NUMBER
Yes Contract Instance Id from CSI_ITEM_INSTANCES
WARRANTY_TEMPLATE_ID NUMBER

Warranty template for the contract.
EXPIRATION_DATE DATE

Contract's expiration date
OSP_CLAIM_FLAG VARCHAR2 (1)
Flag indicating that claim will be auto generated from OSP.
START_FROM_TYPE VARCHAR2 (30)
Contract's start from type
COUNTER_START_TYPE VARCHAR2 (30)
Contract's counter's start type
WARRANTY_TYPE VARCHAR2 (30) Yes Contract's type - user defined
WARRANTY_VENDOR_ID NUMBER
Yes Warranty Vendor id
ACTIVE_START_DATE DATE
Yes Contract's start date
ACTIVE_END_DATE DATE

Contract's end date
WARRANTY_PERIOD NUMBER

Warranty duration
PERIOD_UOM_CODE VARCHAR2 (30)
UOM code for the warranty duration period.
CONTRACT_EXPIRY_TYPE VARCHAR2 (30) Yes Contract's expiration type.
CLAIM_LABOUR_HOURS NUMBER

Claim labour hours
SECURITY_GROUP_ID NUMBER

Security group id
ATTRIBUTE_CATEGORY VARCHAR2 (30)
DFF column category
ATTRIBUTE1 VARCHAR2 (150)
DFF column
ATTRIBUTE2 VARCHAR2 (150)
DFF column
ATTRIBUTE3 VARCHAR2 (150)
DFF column
ATTRIBUTE4 VARCHAR2 (150)
DFF column
ATTRIBUTE5 VARCHAR2 (150)
DFF column
ATTRIBUTE6 VARCHAR2 (150)
DFF column
ATTRIBUTE7 VARCHAR2 (150)
DFF column
ATTRIBUTE8 VARCHAR2 (150)
DFF column
ATTRIBUTE9 VARCHAR2 (150)
DFF column
ATTRIBUTE10 VARCHAR2 (150)
DFF column
ATTRIBUTE11 VARCHAR2 (150)
DFF column
ATTRIBUTE12 VARCHAR2 (150)
DFF column
ATTRIBUTE13 VARCHAR2 (150)
DFF column
ATTRIBUTE14 VARCHAR2 (150)
DFF column
ATTRIBUTE15 VARCHAR2 (150)
DFF column
Query Text

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


SELECT WARRANTY_CONTRACT_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      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
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM AHL.AHL_WARRANTY_CONTRACTS_B;

Dependencies

[top of page]

AHL.AHL_WARRANTY_CONTRACTS_B does not reference any database object

AHL.AHL_WARRANTY_CONTRACTS_B is referenced by following:

SchemaAHL
ViewAHL_WARRANTY_CONTRACTS_B#