View: CS_SR_TERRITORY_V

Product:	CS - Service
Description:	This view shows information about Service Request, and this is being used by Territory Management.
Implementation/DBA Data:	APPS.CS_SR_TERRITORY_V

View Text

SELECT CSI.INCIDENT_ID
, PARTY.PARTY_ID
, LOC.COUNTRY
, PARTY_SITE.PARTY_SITE_ID
, LOC.CITY
, LOC.POSTAL_CODE
, LOC.STATE
, CONT_POINT.PHONE_AREA_CODE
, LOC.COUNTY
, PARTY.PARTY_NAME
, LOC.PROVINCE
, PROFILE.EMPLOYEES_TOTAL
, CSI.INCIDENT_TYPE_ID
, CSI.INCIDENT_SEVERITY_ID
, CSI.INCIDENT_URGENCY_ID
, CSI.PROBLEM_CODE
, CSI.INCIDENT_STATUS_ID
, CSI.PLATFORM_ID
, CSI.SITE_ID
, CSI.CUSTOMER_SITE_ID
, CSITL.SR_CREATION_CHANNEL
, CSI.INVENTORY_ITEM_ID
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM CS_INCIDENTS_ALL_B CSI
, HZ_PARTIES PARTY
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CONTACT_POINTS CONT_POINT
, HZ_ORGANIZATION_PROFILES PROFILE
, CS_INCIDENTS_ALL_TL CSITL
WHERE CSI.CUSTOMER_SITE_ID = PARTY_SITE.PARTY_SITE_ID
AND PARTY_SITE.PARTY_ID = PARTY.PARTY_ID
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_ID
AND PARTY.PARTY_ID = PARTY_SITE.PARTY_ID
AND ((PARTY.PARTY_TYPE = 'PERSON') OR (PARTY.PARTY_TYPE = 'ORGANIZATION'))
AND CONT_POINT.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CONT_POINT.OWNER_TABLE_ID(+) = PARTY.PARTY_ID
AND PROFILE.PARTY_ID = PARTY.PARTY_ID
AND CSI.INCIDENT_ID = CSITL.INCIDENT_ID
AND CSITL.LANGUAGE = USERENV('LANG')

Columns