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

TABLE: CSL.CSL_CS_HZ_SR_CONTACT_PTS_INQ

Object Details
Object Name: CSL_CS_HZ_SR_CONTACT_PTS_INQ
Object Type: TABLE
Owner: CSL
Subobject Name:
Status: VALID


Inqueue table for CS_HZ_SR_CONTACT_POINTS containing data uploaded by mobile clients


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSL_CS_HZ_SR_CNTCT_PTS_INQ_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTRANID$$
ColumnCLID$$CS
ColumnSEQNO$$
Columns
Name Datatype Length Mandatory Comments
CLID$$CS VARCHAR2 (240)
Mobile username refers to FND_USER
SR_CONTACT_POINT_ID NUMBER

Service Request Contact Point Identifier. Uniquely identifies record.
CONTACT_TYPE VARCHAR2 (30)
Contact Type, for example PERSON or EMPLOYEE.
PARTY_ID NUMBER

Contact Identifier of the person calling for SR.
INCIDENT_ID NUMBER

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.
DMLTYPE$$ VARCHAR2 (1)
DML code
SEQNO$$ NUMBER (10)
Oracle Lite sequence number
TRANID$$ NUMBER (10)
Transaction id
VERSION$$ NUMBER (10)
Record version
Query Text

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


SELECT CLID$$CS
,      SR_CONTACT_POINT_ID
,      CONTACT_TYPE
,      PARTY_ID
,      INCIDENT_ID
,      CONTACT_POINT_TYPE
,      CONTACT_POINT_ID
,      PRIMARY_FLAG
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
FROM CSL.CSL_CS_HZ_SR_CONTACT_PTS_INQ;

Dependencies

[top of page]

CSL.CSL_CS_HZ_SR_CONTACT_PTS_INQ does not reference any database object

CSL.CSL_CS_HZ_SR_CONTACT_PTS_INQ is referenced by following:

SchemaCSL
ViewCSL_CS_HZ_SR_CONTACT_PTS_INQ#