View: CSS_DEF_DEFECTS_ALL_V

View Text

SELECT DEV.DEFECT_ID
, DEV.OBJECT_VERSION_NUMBER
, DEV.DEFECT_NUMBER
, DEV.ORG_ID /* OBSOLETED 11.5.4+ */
, DEV.TERRITORY_ID
, DEV.TERRITORY_NAME
, DEV.CATEGORY_TYPE
, DEV.PROBLEM_CATEGORY_ID
, DEV.PROBLEM_CATEGORY_NAME
, DEV.PROBLEM_TYPE_ID
, DEV.PROBLEM_TYPE_NAME
, DEV.PHASE_ID
, DEV.PHASE_NAME
, DEV.PROBLEM_TYPE_PHASE_ID
, DEV.REASON_ID /* OBSOLETED 11.5.4+ */
, DEV.REASON_NAME /* OBSOLETED 11.5.4+ */
, DEV.STATUS_ID
, DEV.STATUS_NAME
, DEV.OPEN_FLAG
, DEV.OPEN_MEANING
, DEV.STATUS_REASON_ID /* OBSOLETED 11.5.3 */
, DEV.STATUS_REASON_NAME /* OBSOLETED 11.5.3 */
, DEV.SEVERITY_ID
, DEV.SEVERITY_NAME
, DEV.DESC_STATUS_REASON /* OBSOLETED 11.5.3 */
, DEV.PRIORITY_ID
, DEV.PRIORITY_NAME
, DEV.INV_ORGANIZATION_ID
, DEV.PRODUCT_INV_ITEM_ID
, DEV.PRODUCT_DESCRIPTION
, DEV.PRODUCT_CONC_SEGMENTS
, DEV.PRODUCT_REVISION
, DEV.PRODUCT_REVISION_DESC
, DEV.FIRST_FOUND_IN_INV_ITEM_ID
, DEV.FIRST_FOUND_IN_DESCRIPTION
, DEV.FIRST_FOUND_IN_CONC_SEGMENTS
, DEV.FIRST_FOUND_IN_REVISION
, DEV.FIRST_FOUND_IN_REVISION_DESC
, DEV.COMPONENT_INV_ITEM_ID
, DEV.COMPONENT_DESCRIPTION
, DEV.COMPONENT_CONC_SEGMENTS
, DEV.COMPONENT_REVISION
, DEV.COMPONENT_REVISION_DESC
, DEV.SUB_COMP_INV_ITEM_ID
, DEV.SUB_COMP_DESCRIPTION
, DEV.SUB_COMPONENT_CONC_SEGMENTS
, DEV.SUB_COMPONENT_REVISION
, DEV.SUB_COMPONENT_REVISION_DESC
, DEV.FREQUENCY_CODE
, DEV.FREQUENCY_MEANING
, DEV.TESTCASE /* OBSOLETED 11.5.4+ */
, DEV.PUBLISH_EXT_FLAG
, DEV.PUBLISH_EXT_MEANING
, DEV.LIFE_CYCLE_CODE
, DEV.LIFE_CYCLE_MEANING
, DEV.TIER_CODE /* OBSOLETED 11.5.4+ */
, DEV.TIER_MEANING /* OBSOLETED 11.5.4+ */
, DEV.SUMMARY
, DEV.KEYWORDS /* OBSOLETED 11.5.3 */
, DEV.TEST_TYPE /* OBSOLETED 11.5.4+ */
, DEV.TEST_TYPE_MEANING /* OBSOLETED 11.5.4+ */
, DEV.TEST_NAME /* OBSOLETED 11.5.4+ */
, DEV.COMMITMENT_CODE /* OBSOLETED 11.5.3 */
, DEV.COMMITMENT_MEANING /* OBSOLETED 11.5.3 */
, DEV.COMMIT_TO_FIX_FLAG
, DEV.COMMIT_TO_FIX_MEANING
, DEV.RESOLUTION_CODE /* OBSOLETED 11.5.3 */
, DEV.RESOLUTION_MEANING /* OBSOLETED 11.5.3 */
, DEV.UI_DEFECT_FLAG /* OBSOLETED 11.5.4+ */
, DEV.UI_DEFECT_MEANING /* OBSOLETED 11.5.4+ */
, DEV.FUNC_DEFECT_FLAG /* OBSOLETED 11.5.4+ */
, DEV.FUNC_DEFECT_MEANING /* OBSOLETED 11.5.4+ */
, DEV.PLATFORM_SPECIFIC_FLAG
, DEV.PLATFORM_SPECIFIC_MEANING
, DEV.ESCALATION_LEVEL_CODE
, DEV.ESCALATION_LEVEL_MEANING
, DEV.ESCALATION_OWNER_ID
, DEV.ESCALATION_OWNER_RESOURCE_TYPE
, DEV.ESCALATION_OWNER_NAME
, DEV.ESTIMATED_COST
, DEV.ESTIMATED_COST_UOM
, DEV.ESTIMATED_COST_UOM_DESC
, DEV.ACTUAL_COST
, DEV.ACTUAL_COST_UOM
, DEV.ACTUAL_COST_UOM_DESC
, DEV.FIX_BY_INV_ITEM_ID
, DEV.FIX_BY_DESCRIPTION
, DEV.FIX_BY_CONC_SEGMENTS
, DEV.FIX_BY_REVISION
, DEV.FIX_BY_REVISION_DESC
, DEV.FIXED_IN_INV_ITEM_ID
, DEV.FIXED_IN_DESCRIPTION
, DEV.FIXED_IN_CONC_SEGMENTS
, DEV.FIXED_IN_REVISION
, DEV.FIXED_IN_REVISION_DESC
, DEV.FILER_ID
, DEV.FILER_RESOURCE_TYPE /* OBSOLETED 11.5.4+ */
, SUBSTR( CSS_DEF_UTIL_PVT.GET_USER_NAME( DEV.FILER_ID )
, 1
, 573 ) FILER_NAME
, DEV.FILED_DATE
, DEV.UPDATED_DATE
, DEV.ESTIMATED_RESOLUTION_DATE
, DEV.RESOLVED_DATE
, DEV.ESTIMATED_CLOSURE_DATE
, DEV.CLOSED_DATE
, DEV.SYS_RESPONSE_TIME /* OBSOLETED 11.5.3 */
, DEV.SYS_RESPONSE_UOM /* OBSOLETED 11.5.3 */
, DEV.SYS_RESOLUTION_TIME /* OBSOLETED 11.5.4+ */
, DEV.SYS_RESOLUTION_UOM /* OBSOLETED 11.5.4+ */
, DEV.SYS_RESOLUTION_UOM_DESC /* OBSOLETED 11.5.4+ */
, DEV.SYSTEM_RESOLUTION_DATE
, DEV.SYS_CLOSURE_TIME /* OBSOLETED 11.5.4+ */
, DEV.SYS_CLOSURE_UOM /* OBSOLETED 11.5.4+ */
, DEV.SYS_CLOSURE_UOM_DESC /* OBSOLETED 11.5.4+ */
, DEV.SYSTEM_CLOSURE_DATE
, DEV.DEV_OWNER_ID /* OBSOLETED 11.5.4+ */
, DEV.DEV_OWNER_RESOURCE_TYPE /* OBSOLETED 11.5.4+ */
, NULL DEV_OWNER_NAME /* OBSOLETED 11.5.4+ */
, DEV.DEV_TERRITORY_ID /* OBSOLETED 11.5.4+ */
, DEV.DEV_TERRITORY_NAME /* OBSOLETED 11.5.4+ */
, DEV.PHASE_OWNER_ID
, DEV.PHASE_OWNER_RESOURCE_TYPE
, SUBSTR( CSS_DEF_RESOURCE_UTIL_PVT.GET_RESOURCE_NAME( DEV.PHASE_OWNER_ID
, DEV.PHASE_OWNER_RESOURCE_TYPE )
, 1
, 573 ) PHASE_OWNER_NAME
, DEV.LAST_UPDATED_BY_RES_ID /* OBSOLETED 11.5.4+ */
, DEV.LAST_UPDATED_BY_RESOURCE_TYPE /* OBSOLETED 11.5.4+ */
, NULL LAST_UPDATED_BY_RES_NAME
, DEV.UPDATED_BY_ID
, SUBSTR( CSS_DEF_UTIL_PVT.GET_USER_NAME( DEV.UPDATED_BY_ID)
, 1
, 573 ) UPDATED_BY_NAME
, DEV.TEMPLATE_ID /* OBSOLETED 11.5.3 */
, DEV.CONTRIBUTED_TO_KB_FLAG
, DEV.CONTRIBUTED_TO_KB_MEANING
, DEV.DELETED_FLAG
, DEV.CREATED_BY
, DEV.CREATION_DATE
, DEV.LAST_UPDATED_BY
, DEV.LAST_UPDATE_DATE
, DEV.LAST_UPDATE_LOGIN
, DEV.ATTRIBUTE1
, DEV.ATTRIBUTE2
, DEV.ATTRIBUTE3
, DEV.ATTRIBUTE4
, DEV.ATTRIBUTE5
, DEV.ATTRIBUTE6
, DEV.ATTRIBUTE7
, DEV.ATTRIBUTE8
, DEV.ATTRIBUTE9
, DEV.ATTRIBUTE10
, DEV.ATTRIBUTE11
, DEV.ATTRIBUTE12
, DEV.ATTRIBUTE13
, DEV.ATTRIBUTE14
, DEV.ATTRIBUTE15
, DEV.CONTEXT
, DEV.PRODUCT_ITEM_ID /* OBSOLETED 11.5.4+ */
, DEV.PRODUCT_ITEM_NAME /* OBSOLETED 11.5.4+ */
, DEV.PRODUCT_ITEM_VERSION_ID /* OBSOLETED 11.5.4+ */
, DEV.PRODUCT_ITEM_VERSION /* OBSOLETED 11.5.4+ */
, DEV.COMPONENT_ITEM_ID /* OBSOLETED 11.5.4+ */
, DEV.COMPONENT_ITEM_NAME /* OBSOLETED 11.5.4+ */
, DEV.COMPONENT_ITEM_VERSION_ID /* OBSOLETED 11.5.4+ */
, DEV.COMPONENT_ITEM_VERSION /* OBSOLETED 11.5.4+ */
, DEV.SUB_COMPONENT_ITEM_ID /* OBSOLETED 11.5.4+ */
, DEV.SUB_COMPONENT_ITEM_NAME /* OBSOLETED 11.5.4+ */
, DEV.SUB_COMP_ITEM_VERSION_ID /* OBSOLETED 11.5.4+ */
, DEV.SUB_COMP_ITEM_VERSION /* OBSOLETED 11.5.4+ */
, DEV.EARLIEST_PROD_ITEM_ID /* OBSOLETED 11.5.4+ */
, DEV.EARLIEST_PROD_ITEM_NAME /* OBSOLETED 11.5.4+ */
, DEV.EARLIEST_PROD_ITEM_VERSION_ID /* OBSOLETED 11.5.4+ */
, DEV.EARLIEST_PROD_ITEM_VERSION /* OBSOLETED 11.5.4+ */
, DEV.PLANNED_BY_ITEM_TYPE /* OBSOLETED 11.5.4+ */
, DEV.PLANNED_BY_ITEM_ID /* OBSOLETED 11.5.4+ */
, DEV.PLANNED_BY_ITEM_NAME /* OBSOLETED 11.5.4+ */
, DEV.PLANNED_BY_ITEM_VERSION_ID /* OBSOLETED 11.5.4+ */
, DEV.PLANNED_BY_ITEM_VERSION /* OBSOLETED 11.5.4+ */
, DEV.FIXED_IN_ITEM_TYPE /* OBSOLETED 11.5.4+ */
, DEV.FIXED_IN_ITEM_ID /* OBSOLETED 11.5.4+ */
, DEV.FIXED_IN_ITEM_NAME /* OBSOLETED 11.5.4+ */
, DEV.FIXED_IN_ITEM_VERSION_ID /* OBSOLETED 11.5.4+ */
, DEV.FIXED_IN_ITEM_VERSION /* OBSOLETED 11.5.4+ */
FROM CSS_DEF_DEFECTS_ALL_NO_RES_V DEV

Columns