[Home] [Help]
View: CSS_DEF_IR_DEFECTS_V
| Product: | CSS - Support (obsolete) |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT DEFECT_ID
, OBJECT_VERSION_NUMBER
, DEFECT_NUMBER
, CATEGORY_TYPE
, FILED_DATE
, UPDATED_DATE
, RESOLVED_DATE
, CLOSED_DATE
, RESOLVED_FLAG
, OPEN_FLAG
, DELETED_FLAG
, PUBLISH_EXT_FLAG
, COMMIT_TO_FIX_FLAG
, PROBLEM_TYPE_ID
, PHASE_ID
, STATUS_ID
, SEVERITY_ID
, PRIORITY_ID
, FILER_ID
, UPDATED_BY_ID
, PHASE_OWNER_ID
, PHASE_OWNER_RESOURCE_TYPE
, TERRITORY_ID
, PRODUCT_INV_ITEM_ID
, PRODUCT_REVISION
, PRODUCT_REVISION_DESC
, COMPONENT_INV_ITEM_ID
, COMPONENT_REVISION
, COMPONENT_REVISION_DESC
, SUB_COMPONENT_INV_ITEM_ID
, SUB_COMPONENT_REVISION
, SUB_COMPONENT_REVISION_DESC
, FIRST_FOUND_IN_REVISION
, FIRST_FOUND_IN_REVISION_DESC
, FIX_BY_LEVEL
, FIX_BY_REVISION
, FIX_BY_REVISION_DESC
, FIXED_IN_LEVEL
, FIXED_IN_REVISION
, FIXED_IN_REVISION_DESC
, PLATFORM_INV_ITEM_ID
, PLATFORM_REVISION
, PLATFORM_REVISION_DESC
, PLATFORM_SPECIFIC_FLAG
, ORIGINATING_CUSTOMER_ID
, EXT_CUSTOMER_FLAG
, FREQUENCY_CODE
, LIFE_CYCLE_CODE
, ACTUAL_COST
, ACTUAL_COST_UOM
, ESTIMATED_COST
, ESTIMATED_COST_UOM
, ESTIMATED_RESOLUTION_DATE
, ESTIMATED_CLOSURE_DATE
, SYSTEM_RESOLUTION_DATE
, SYSTEM_CLOSURE_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
FROM CSS_DEF_DEFECTS_B
Columns
| Name |
| DEFECT_ID |
| OBJECT_VERSION_NUMBER |
| DEFECT_NUMBER |
| CATEGORY_TYPE |
| FILED_DATE |
| UPDATED_DATE |
| RESOLVED_DATE |
| CLOSED_DATE |
| RESOLVED_FLAG |
| OPEN_FLAG |
| DELETED_FLAG |
| PUBLISH_EXT_FLAG |
| COMMIT_TO_FIX_FLAG |
| PROBLEM_TYPE_ID |
| PHASE_ID |
| STATUS_ID |
| SEVERITY_ID |
| PRIORITY_ID |
| FILER_ID |
| UPDATED_BY_ID |
| PHASE_OWNER_ID |
| PHASE_OWNER_RESOURCE_TYPE |
| TERRITORY_ID |
| PRODUCT_INV_ITEM_ID |
| PRODUCT_REVISION |
| PRODUCT_REVISION_DESC |
| COMPONENT_INV_ITEM_ID |
| COMPONENT_REVISION |
| COMPONENT_REVISION_DESC |
| SUB_COMPONENT_INV_ITEM_ID |
| SUB_COMPONENT_REVISION |
| SUB_COMPONENT_REVISION_DESC |
| FIRST_FOUND_IN_REVISION |
| FIRST_FOUND_IN_REVISION_DESC |
| FIX_BY_LEVEL |
| FIX_BY_REVISION |
| FIX_BY_REVISION_DESC |
| FIXED_IN_LEVEL |
| FIXED_IN_REVISION |
| FIXED_IN_REVISION_DESC |
| PLATFORM_INV_ITEM_ID |
| PLATFORM_REVISION |
| PLATFORM_REVISION_DESC |
| PLATFORM_SPECIFIC_FLAG |
| ORIGINATING_CUSTOMER_ID |
| EXT_CUSTOMER_FLAG |
| FREQUENCY_CODE |
| LIFE_CYCLE_CODE |
| ACTUAL_COST |
| ACTUAL_COST_UOM |
| ESTIMATED_COST |
| ESTIMATED_COST_UOM |
| ESTIMATED_RESOLUTION_DATE |
| ESTIMATED_CLOSURE_DATE |
| SYSTEM_RESOLUTION_DATE |
| SYSTEM_CLOSURE_DATE |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |
| ATTRIBUTE1 |
| ATTRIBUTE2 |
| ATTRIBUTE3 |
| ATTRIBUTE4 |
| ATTRIBUTE5 |
| ATTRIBUTE6 |
| ATTRIBUTE7 |
| ATTRIBUTE8 |
| ATTRIBUTE9 |
| ATTRIBUTE10 |
| ATTRIBUTE11 |
| ATTRIBUTE12 |
| ATTRIBUTE13 |
| ATTRIBUTE14 |
| ATTRIBUTE15 |
| CONTEXT |