[Home] [Help]
| Product: | CSS - Support (obsolete) |
|---|---|
| Description: | Territory management |
| Implementation/DBA Data: | Not implemented in this database |
SELECT DEF.DEFECT_ID
, PAR.PARTY_ID
, PAR.COUNTRY
, TO_NUMBER(NULL) PARTY_SITE_ID
, PAR.CITY
, PAR.POSTAL_CODE
, PAR.STATE
, NULL AREA_CODE
, PAR.COUNTY
, PAR.PARTY_NAME COMP_NAME_RANGE
, PAR.PROVINCE
, TO_NUMBER(NULL) NUM_OF_EMPLOYEES
, DEF.PROBLEM_TYPE_ID
, DEF.PHASE_ID
, DEF.SEVERITY_ID
, DEF.PRIORITY_ID
, NULL TIER_CODE
, NULL UI_DEFECT_FLAG
, NULL FUNC_DEFECT_FLAG
, DEF.PLATFORM_SPECIFIC_FLAG
, TO_NUMBER(NULL) ERROR_CODE_ID
, DLA.LANGUAGE_ID LANGUAGE_CODE_ID
, DEF.PLATFORM_INV_ITEM_ID PLATFORM_ID
, DEF.PRODUCT_INV_ITEM_ID PRODUCT_ID
, DEF.COMPONENT_INV_ITEM_ID COMPONENT_ID
, DEF.SUB_COMPONENT_INV_ITEM_ID SUB_COMPONENT_ID
, DEF.ATTRIBUTE1
, DEF.ATTRIBUTE2
, DEF.ATTRIBUTE3
, DEF.ATTRIBUTE4
, DEF.ATTRIBUTE5
, DEF.ATTRIBUTE6
, DEF.ATTRIBUTE7
, DEF.ATTRIBUTE8
, DEF.ATTRIBUTE9
, DEF.ATTRIBUTE10
, DEF.ATTRIBUTE11
, DEF.ATTRIBUTE12
, DEF.ATTRIBUTE13
, DEF.ATTRIBUTE14
, DEF.ATTRIBUTE15
, DEF.CONTEXT
FROM CSS_DEF_DEFECTS_B DEF
, CSS_DEF_DEF_ERROR_CODES DER
, CSS_DEF_DEF_LANGUAGES DLA
, HZ_PARTIES PAR
WHERE DEF.DEFECT_ID = DER.DEFECT_ID(+)
AND DER.PRIMARY_FLAG(+) = 'Y'
AND DEF.DEFECT_ID = DLA.DEFECT_ID(+)
AND DLA.PRIMARY_FLAG(+) = 'Y'
AND DEF.ORIGINATING_CUSTOMER_ID = PAR.PARTY_ID