[Home] [Help] [Dependency Information]
Object Name: | CSD_REPAIR_ACTUAL_LINES# |
---|---|
Object Type: | VIEW |
Owner: | CSD |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REPAIR_ACTUAL_LINE_ID | NUMBER | Yes | ||
REPAIR_ACTUAL_ID | NUMBER | Yes | ||
ESTIMATE_DETAIL_ID | NUMBER | Yes | ||
ITEM_COST | NUMBER | |||
RESOURCE_ID | NUMBER | |||
CONTEXT | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | Yes | ||
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
SECURITY_GROUP_ID | NUMBER | |||
REPAIR_LINE_ID | NUMBER | |||
JUSTIFICATION_NOTES | VARCHAR2 | (240) | ||
OVERRIDE_CHARGE_FLAG | VARCHAR2 | (1) | ||
ACTUAL_SOURCE_CODE | VARCHAR2 | (30) | ||
ACTUAL_SOURCE_ID | NUMBER | |||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
LOCATOR_ID | NUMBER | |||
LOC_SEGMENT1 | VARCHAR2 | (40) | ||
LOC_SEGMENT2 | VARCHAR2 | (40) | ||
LOC_SEGMENT3 | VARCHAR2 | (40) | ||
LOC_SEGMENT4 | VARCHAR2 | (40) | ||
LOC_SEGMENT5 | VARCHAR2 | (40) | ||
LOC_SEGMENT6 | VARCHAR2 | (40) | ||
LOC_SEGMENT7 | VARCHAR2 | (40) | ||
LOC_SEGMENT8 | VARCHAR2 | (40) | ||
LOC_SEGMENT9 | VARCHAR2 | (40) | ||
LOC_SEGMENT10 | VARCHAR2 | (40) | ||
LOC_SEGMENT11 | VARCHAR2 | (40) | ||
LOC_SEGMENT12 | VARCHAR2 | (40) | ||
LOC_SEGMENT13 | VARCHAR2 | (40) | ||
LOC_SEGMENT14 | VARCHAR2 | (40) | ||
LOC_SEGMENT15 | VARCHAR2 | (40) | ||
LOC_SEGMENT16 | VARCHAR2 | (40) | ||
LOC_SEGMENT17 | VARCHAR2 | (40) | ||
LOC_SEGMENT18 | VARCHAR2 | (40) | ||
LOC_SEGMENT19 | VARCHAR2 | (40) | ||
LOC_SEGMENT20 | VARCHAR2 | (40) | ||
LOT_NUMBER | VARCHAR2 | (80) | ||
WARRANTY_CLAIM_FLAG | VARCHAR2 | (1) | ||
WARRANTY_NUMBER | VARCHAR2 | (80) | ||
WARRANTY_STATUS_CODE | VARCHAR2 | (1) | ||
REPLACED_ITEM_ID | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT REPAIR_ACTUAL_LINE_ID
, REPAIR_ACTUAL_ID
, ESTIMATE_DETAIL_ID
, ITEM_COST
, RESOURCE_ID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID
, REPAIR_LINE_ID
, JUSTIFICATION_NOTES
, OVERRIDE_CHARGE_FLAG
, ACTUAL_SOURCE_CODE
, ACTUAL_SOURCE_ID
, ATTRIBUTE_CATEGORY
, LOCATOR_ID
, LOC_SEGMENT1
, LOC_SEGMENT2
, LOC_SEGMENT3
, LOC_SEGMENT4
, LOC_SEGMENT5
, LOC_SEGMENT6
, LOC_SEGMENT7
, LOC_SEGMENT8
, LOC_SEGMENT9
, LOC_SEGMENT10
, LOC_SEGMENT11
, LOC_SEGMENT12
, LOC_SEGMENT13
, LOC_SEGMENT14
, LOC_SEGMENT15
, LOC_SEGMENT16
, LOC_SEGMENT17
, LOC_SEGMENT18
, LOC_SEGMENT19
, LOC_SEGMENT20
, LOT_NUMBER
, WARRANTY_CLAIM_FLAG
, WARRANTY_NUMBER
, WARRANTY_STATUS_CODE
, REPLACED_ITEM_ID
FROM CSD.CSD_REPAIR_ACTUAL_LINES#;
|
|
|