View: CS_SR_TASK_TERRITORY_V

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

View Text

SELECT TASK.TASK_ID
, 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
, TASK.TASK_TYPE_ID
, TASK.TASK_STATUS_ID
, TASK.TASK_PRIORITY_ID
, 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 HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS HZACCT
, HZ_PARTY_SITES PARTY_SITE
, HZ_LOCATIONS LOC
, HZ_CONTACT_POINTS CONT_POINT
, HZ_ORGANIZATION_PROFILES PROFILE
, JTF_TASKS_VL TASK
, CS_INCIDENTS_ALL_B CSI
, CS_INCIDENTS_ALL_TL CSITL
WHERE CSI.INCIDENT_ID = TASK.SOURCE_OBJECT_ID
AND TASK.SOURCE_OBJECT_TYPE_CODE = 'SR'
AND TASK.CUSTOMER_ID = PARTY.PARTY_ID
AND TASK.CUSTOMER_ID = HZACCT.PARTY_ID (+)
AND TASK.CUST_ACCOUNT_ID = HZACCT.CUST_ACCOUNT_ID (+)
AND TASK.ADDRESS_ID = PARTY_SITE.PARTY_SITE_ID
AND PARTY.PARTY_ID = PARTY_SITE.PARTY_ID
AND PARTY_SITE.LOCATION_ID = LOC.LOCATION_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