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

VIEW: APPS.CS_SR_TERRITORY_V

Object Details
Object Name: CS_SR_TERRITORY_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_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
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 Customer site Identifier.
CITY VARCHAR2 (60)
City of 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 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 employees working for the company.
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 of 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 SERVICE_REQUEST_ID
,      PARTY_ID
,      COUNTRY
,      PARTY_SITE_ID
,      CITY
,      POSTAL_CODE
,      STATE
,      AREA_CODE
,      COUNTY
,      COMP_NAME_RANGE
,      PROVINCE
,      NUM_OF_EMPLOYEES
,      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_TERRITORY_V;

Dependencies

[top of page]

APPS.CS_SR_TERRITORY_V references the following:

SchemaAPPS
SynonymCS_INCIDENTS_ALL_B
SynonymCS_INCIDENTS_ALL_TL
SynonymHZ_CONTACT_POINTS
SynonymHZ_LOCATIONS
SynonymHZ_ORGANIZATION_PROFILES
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES

APPS.CS_SR_TERRITORY_V is not referenced by any database object