[Home] [Help]
| Product: | CSS - Support (obsolete) |
|---|---|
| Description: | |
| Implementation/DBA Data: | Not implemented in this database |
SELECT DEF.DEFECT_ID
, DEF.DEFECT_NUMBER
, SEV.NAME SEVERITY_NAME
, PROD.CONCATENATED_SEGMENTS PRODUCT_NUMBER
, PROD.DESCRIPTION PRODUCT_DESCRIPTION
, CSS_DEF_MTL_API.GET_REVISION_DESCRIPTION(DEF.PRODUCT_INV_ITEM_ID
, DEF.PRODUCT_REVISION
, DEF.PRODUCT_REVISION_DESC) PRODUCT_VERSION
, CSS_DEF_MTL_API.GET_ITEM_CONCAT_SEGMENTS(DEF.COMPONENT_INV_ITEM_ID) COMPONENT_NUMBER
, CSS_DEF_MTL_API.GET_ITEM_DESCRIPTION(DEF.COMPONENT_INV_ITEM_ID) COMPONENT_DESCRIPTION
, CSS_DEF_MTL_API.GET_ITEM_CONCAT_SEGMENTS(DEF.SUB_COMPONENT_INV_ITEM_ID) SUB_COMPONENT_NUMBER
, CSS_DEF_MTL_API.GET_ITEM_DESCRIPTION(DEF.SUB_COMPONENT_INV_ITEM_ID) SUB_COMP_DESCRIPTION
, CSS_DEF_MTL_API.GET_ITEM_CONCAT_SEGMENTS(DEF.PLATFORM_INV_ITEM_ID) PLATFORM_NUMBER
, CSS_DEF_MTL_API.GET_ITEM_DESCRIPTION(DEF.PLATFORM_INV_ITEM_ID) PLATFORM_DESCRIPTION
, DEF.SUMMARY
, PHA.NAME PHASE_NAME
, STA.NAME STATUS_NAME
, PTY.NAME PROBLEM_TYPE_NAME
, HZ.PARTY_NAME CUSTOMER_NAME
, HZ.PARTY_NUMBER CUSTOMER_NUMBER
, LK.MEANING CUSTOMER_TYPE
, DEF.UPDATED_DATE LAST_UPDATED
, DEF.FILED_DATE DATE_CREATED
, DEF.ESTIMATED_RESOLUTION_DATE ESTIMATED_RESOLUTION
, DEF.RESOLVED_DATE ACTUAL_RESOLUTION
, DEF.ESTIMATED_CLOSURE_DATE ESTIMATED_CLOSURE
, PRI.NAME PRIORITY_NAME
, DEF.PHASE_OWNER_ID RESOURCE_ID
, DEF.PHASE_OWNER_RESOURCE_TYPE RESOURCE_TYPE
, O.WEB_FUNCTION_NAME IEU_OBJECT_FUNCTION
, O.WEB_FUNCTION_PARAMETERS IEU_OBJECT_PARAMETERS
, NULL IEU_MEDIA_TYPE_UUID
, 'DEFECT_ID' IEU_PARAM_PK_COL
, TO_CHAR(DEF.DEFECT_ID) IEU_PARAM_PK_VALUE
FROM CSS_DEF_DEFECTS_VL DEF
, CSS_DEF_PHASES_VL PHA
, CSS_DEF_PROB_TYPES_VL PTY
, CSS_DEF_SEVERITIES_VL SEV
, CSS_DEF_PRIORITIES_VL PRI
, CSS_DEF_STATUSES_VL STA
, MTL_SYSTEM_ITEMS_VL PROD
, HZ_PARTIES HZ
, CSS_LOOKUPS LK
, JTF_OBJECTS_B O
WHERE DEF.PHASE_ID = PHA.PHASE_ID
AND DEF.PROBLEM_TYPE_ID = PTY.PROBLEM_TYPE_ID
AND DEF.SEVERITY_ID = SEV.SEVERITY_ID
AND DEF.PRIORITY_ID = PRI.PRIORITY_ID(+)
AND DEF.STATUS_ID = STA.STATUS_ID(+)
AND DEF.PRODUCT_INV_ITEM_ID = PROD.INVENTORY_ITEM_ID
AND PROD.ORGANIZATION_ID = CSS_DEF_MTL_API.GET_INV_ORGANIZATION_ID
AND DEF.ORIGINATING_CUSTOMER_ID = HZ.PARTY_ID
AND DEF.EXT_CUSTOMER_FLAG = LK.LOOKUP_CODE
AND LK.LOOKUP_TYPE = 'CSS_DEF_CUSTOMER_TYPE'
AND O.OBJECT_CODE = DECODE(DEF.CATEGORY_TYPE
, 'DEFECT'
, 'DF'
, 'ENH')
AND DEF.DELETED_FLAG = 'N'
AND DEF.OPEN_FLAG = 'Y'
AND DEF.CATEGORY_TYPE = 'DEFECT'