View: CSS_DEF_DEFECTS_VL

View Text

SELECT B.ROWID
, B.DEFECT_ID
, B.OBJECT_VERSION_NUMBER
, B.DEFECT_NUMBER
, B.CATEGORY_TYPE
, B.FILED_DATE
, B.UPDATED_DATE
, B.RESOLVED_DATE
, B.CLOSED_DATE
, B.RESOLVED_FLAG
, B.OPEN_FLAG
, B.DELETED_FLAG
, B.PUBLISH_EXT_FLAG
, B.COMMIT_TO_FIX_FLAG
, B.PROBLEM_TYPE_ID
, B.PHASE_ID
, B.STATUS_ID
, B.SEVERITY_ID
, B.PRIORITY_ID
, B.FILER_ID
, B.UPDATED_BY_ID
, B.PHASE_OWNER_ID
, B.PHASE_OWNER_RESOURCE_TYPE
, B.TERRITORY_ID
, B.PRODUCT_INV_ITEM_ID
, B.PRODUCT_REVISION
, B.PRODUCT_REVISION_DESC
, B.COMPONENT_INV_ITEM_ID
, B.COMPONENT_REVISION
, B.COMPONENT_REVISION_DESC
, B.SUB_COMPONENT_INV_ITEM_ID
, B.SUB_COMPONENT_REVISION
, B.SUB_COMPONENT_REVISION_DESC
, B.FIRST_FOUND_IN_REVISION
, B.FIRST_FOUND_IN_REVISION_DESC
, B.FIX_BY_LEVEL
, B.FIX_BY_REVISION
, B.FIX_BY_REVISION_DESC
, B.FIXED_IN_LEVEL
, B.FIXED_IN_REVISION
, B.FIXED_IN_REVISION_DESC
, B.PLATFORM_INV_ITEM_ID
, B.PLATFORM_REVISION
, B.PLATFORM_REVISION_DESC
, B.PLATFORM_SPECIFIC_FLAG
, B.ORIGINATING_CUSTOMER_ID
, B.EXT_CUSTOMER_FLAG
, B.FREQUENCY_CODE
, B.LIFE_CYCLE_CODE
, B.ACTUAL_COST
, B.ACTUAL_COST_UOM
, B.ESTIMATED_COST
, B.ESTIMATED_COST_UOM
, B.ESTIMATED_RESOLUTION_DATE
, B.ESTIMATED_CLOSURE_DATE
, B.SYSTEM_RESOLUTION_DATE
, B.SYSTEM_CLOSURE_DATE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.CONTEXT
, T.SUMMARY
FROM CSS_DEF_DEFECTS_B B
, CSS_DEF_DEFECTS_TL T
WHERE B.DEFECT_ID = T.DEFECT_ID
AND T.LANGUAGE = USERENV('LANG')

Columns