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

VIEW: APPS.CSL_CS_HZ_SR_CONTACT_PTS_V

Object Details
Object Name: CSL_CS_HZ_SR_CONTACT_PTS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


Mobile view to CS_HZ_SR_CONTACT_POINTS


[View Source]

Columns
Name Datatype Length Mandatory Comments
ACCESS_ID NUMBER

Indentifier to CSL_CS_HZ_SR_CONTACT_PTS_ACC
SR_CONTACT_POINT_ID NUMBER
Yes Service Request Contact Point Identifier. Uniquely identifies record.
CONTACT_TYPE VARCHAR2 (30) Yes Contact Type, for example PERSON or EMPLOYEE.
PARTY_ID NUMBER
Yes Contact Identifier of the person calling for SR.
INCIDENT_ID NUMBER
Yes Incident Identifier of SR.
CONTACT_POINT_TYPE VARCHAR2 (30)
Contact Point Type used for Service Request. For example, PHONEor EMAIL.
CONTACT_POINT_ID NUMBER

Contact Point Identifier. For example, Phone_Id or Email_Id.
PRIMARY_FLAG VARCHAR2 (1)
A Flag to indicate that this contact is the Primary Contact for the SR.
Query Text

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


SELECT ACCESS_ID
,      SR_CONTACT_POINT_ID
,      CONTACT_TYPE
,      PARTY_ID
,      INCIDENT_ID
,      CONTACT_POINT_TYPE
,      CONTACT_POINT_ID
,      PRIMARY_FLAG
FROM APPS.CSL_CS_HZ_SR_CONTACT_PTS_V;

Dependencies

[top of page]

APPS.CSL_CS_HZ_SR_CONTACT_PTS_V references the following:

SchemaAPPS
PL/SQL PackageASG_BASE - show dependent code
SynonymCSL_CS_HZ_SR_CONTACT_PTS_ACC
SynonymCS_HZ_SR_CONTACT_POINTS

APPS.CSL_CS_HZ_SR_CONTACT_PTS_V is not referenced by any database object