eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CS_SR_TASK_TERRITORY_V

Object Details

Object Name:	CS_SR_TASK_TERRITORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SR_TASK_TERRITORY_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TASK_ID	NUMBER		Yes	Task identifier.
SERVICE_REQUEST_ID	NUMBER	(15)	Yes	Service request identifier.
PARTY_ID	NUMBER	(15)	Yes	Customer Identifier.
COUNTRY	VARCHAR2	(60)	Yes	Country of the customer as mentioned in the customer address.
PARTY_SITE_ID	NUMBER	(15)	Yes	Party site identifier.
CITY	VARCHAR2	(60)		Stateof the customer as mentioned in the customer address.
POSTAL_CODE	VARCHAR2	(60)		Postal code of the customer as mentioned in the customer address.
STATE	VARCHAR2	(60)		State of the customer as mentioned in the customer address.
AREA_CODE	VARCHAR2	(10)		Area Code of the customer phone number.
COUNTY	VARCHAR2	(60)		County of the customer as mentioned in the customer address.
COMP_NAME_RANGE	VARCHAR2	(360)	Yes	Company Name
PROVINCE	VARCHAR2	(60)		Province of the customer as mentioned in the customer address.
NUM_OF_EMPLOYEES	NUMBER			Number of total employees for the company.
TASK_TYPE_ID	NUMBER		Yes	Task type Identifier.
TASK_STATUS_ID	NUMBER		Yes	Task status identifier.
TASK_PRIORITY_ID	NUMBER			Task priority identifier.
INCIDENT_TYPE_ID	NUMBER	(15)	Yes	service Request Type Identifier.
INCIDENT_SEVERITY_ID	NUMBER	(15)	Yes	service Request severity Identifier.
INCIDENT_URGENCY_ID	NUMBER	(15)		Service Request Urgency Identifier.
PROBLEM_CODE	VARCHAR2	(50)		Problem Code specified in the Service Request
INCIDENT_STATUS_ID	NUMBER	(15)	Yes	Service Request status identifier.
PLATFORM_ID	NUMBER			Platform identifier.
SUPPORT_SITE_ID	NUMBER			Support Site Identifier.
CUSTOMER_SITE_ID	NUMBER			Customer site identifier.
SR_CREATION_CHANNEL	VARCHAR2	(50)		Service Request creation channel (eg. phone , web,email)
INVENTORY_ITEM_ID	NUMBER	(15)		Item identifier.
ATTRIBUTE1	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE2	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE3	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE4	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE5	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE6	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE7	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE8	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE9	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE10	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE11	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE12	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE13	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE14	VARCHAR2	(0)		Descriptive flexfield segment column.
ATTRIBUTE15	VARCHAR2	(0)		Descriptive flexfield segment column.

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TASK_ID
,      SERVICE_REQUEST_ID
,      PARTY_ID
,      COUNTRY
,      PARTY_SITE_ID
,      CITY
,      POSTAL_CODE
,      STATE
,      AREA_CODE
,      COUNTY
,      COMP_NAME_RANGE
,      PROVINCE
,      NUM_OF_EMPLOYEES
,      TASK_TYPE_ID
,      TASK_STATUS_ID
,      TASK_PRIORITY_ID
,      INCIDENT_TYPE_ID
,      INCIDENT_SEVERITY_ID
,      INCIDENT_URGENCY_ID
,      PROBLEM_CODE
,      INCIDENT_STATUS_ID
,      PLATFORM_ID
,      SUPPORT_SITE_ID
,      CUSTOMER_SITE_ID
,      SR_CREATION_CHANNEL
,      INVENTORY_ITEM_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.CS_SR_TASK_TERRITORY_V;

Dependencies

[top of page]

APPS.CS_SR_TASK_TERRITORY_V references the following:

APPS: CS_INCIDENTS_ALL_B; CS_INCIDENTS_ALL_TL; HZ_CONTACT_POINTS; HZ_CUST_ACCOUNTS; HZ_LOCATIONS; HZ_ORGANIZATION_PROFILES; HZ_PARTIES; HZ_PARTY_SITES; JTF_TASKS_VL

APPS.CS_SR_TASK_TERRITORY_V is not referenced by any database object