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

TABLE: CS.CS_SR_CONTACTS_EXT_B

Object Details
Object Name: CS_SR_CONTACTS_EXT_B
Object Type: TABLE
Owner: CS
FND Design Data: TableCS.CS_SR_CONTACTS_EXT_B
Subobject Name:
Status: VALID


Table to store Party Role Extensible Attribute records.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CS_SR_CONTACTS_EXT_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXTENSION_ID
CS_SR_CONTACTS_EXT_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnINCIDENT_ID
ColumnCONTEXT
Columns
Name Datatype Length Mandatory Comments
EXTENSION_ID NUMBER
Yes System generated number that uniquely identifies the extension row.
INCIDENT_ID NUMBER
Yes Service request number from cs_incidents_all_b table.
CONTEXT VARCHAR2 (30) Yes Classification of an external attribute associated with a Service Request Contact/Associated Party
ATTR_GROUP_ID NUMBER
Yes Identifier of the attribute group.
CREATION_DATE DATE
Yes Standard WHO column.
CREATED_BY NUMBER (15) Yes Standard WHO column.
LAST_UPDATE_DATE DATE
Yes Standard WHO column.
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column.
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column.
C_EXT_ATTR1 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR2 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR3 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR4 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR5 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR6 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR7 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR8 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR9 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR10 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR11 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR12 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR13 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR14 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR15 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR16 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR17 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR18 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR19 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR20 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR21 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR22 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR23 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR24 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR25 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR26 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR27 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR28 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR29 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR30 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR31 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR32 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR33 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR34 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR35 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR36 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR37 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR38 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR39 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR40 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR41 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR42 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR43 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR44 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR45 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR46 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR47 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR48 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR49 VARCHAR2 (150)
Character based extensible attribute column.
C_EXT_ATTR50 VARCHAR2 (150)
Character based extensible attribute column.
N_EXT_ATTR1 NUMBER

Number based extensible attribute column.
N_EXT_ATTR2 NUMBER

Number based extensible attribute column.
N_EXT_ATTR3 NUMBER

Number based extensible attribute column.
N_EXT_ATTR4 NUMBER

Number based extensible attribute column.
N_EXT_ATTR5 NUMBER

Number based extensible attribute column.
N_EXT_ATTR6 NUMBER

Number based extensible attribute column.
N_EXT_ATTR7 NUMBER

Number based extensible attribute column.
N_EXT_ATTR8 NUMBER

Number based extensible attribute column.
N_EXT_ATTR9 NUMBER

Number based extensible attribute column.
N_EXT_ATTR10 NUMBER

Number based extensible attribute column.
N_EXT_ATTR11 NUMBER

Number based extensible attribute column.
N_EXT_ATTR12 NUMBER

Number based extensible attribute column.
N_EXT_ATTR13 NUMBER

Number based extensible attribute column.
N_EXT_ATTR14 NUMBER

Number based extensible attribute column.
N_EXT_ATTR15 NUMBER

Number based extensible attribute column.
N_EXT_ATTR16 NUMBER

Number based extensible attribute column.
N_EXT_ATTR17 NUMBER

Number based extensible attribute column.
N_EXT_ATTR18 NUMBER

Number based extensible attribute column.
N_EXT_ATTR19 NUMBER

Number based extensible attribute column.
N_EXT_ATTR20 NUMBER

Number based extensible attribute column.
N_EXT_ATTR21 NUMBER

Number based extensible attribute column.
N_EXT_ATTR22 NUMBER

Number based extensible attribute column.
N_EXT_ATTR23 NUMBER

Number based extensible attribute column.
N_EXT_ATTR24 NUMBER

Number based extensible attribute column.
N_EXT_ATTR25 NUMBER

Number based extensible attribute column.
D_EXT_ATTR1 DATE

Date based extensible attribute column.
D_EXT_ATTR2 DATE

Date based extensible attribute column.
D_EXT_ATTR3 DATE

Date based extensible attribute column.
D_EXT_ATTR4 DATE

Date based extensible attribute column.
D_EXT_ATTR5 DATE

Date based extensible attribute column.
D_EXT_ATTR6 DATE

Date based extensible attribute column.
D_EXT_ATTR7 DATE

Date based extensible attribute column.
D_EXT_ATTR8 DATE

Date based extensible attribute column.
D_EXT_ATTR9 DATE

Date based extensible attribute column.
D_EXT_ATTR10 DATE

Date based extensible attribute column.
D_EXT_ATTR11 DATE

Date based extensible attribute column.
D_EXT_ATTR12 DATE

Date based extensible attribute column.
D_EXT_ATTR13 DATE

Date based extensible attribute column.
D_EXT_ATTR14 DATE

Date based extensible attribute column.
D_EXT_ATTR15 DATE

Date based extensible attribute column.
D_EXT_ATTR16 DATE

Date based extensible attribute column.
D_EXT_ATTR17 DATE

Date based extensible attribute column.
D_EXT_ATTR18 DATE

Date based extensible attribute column.
D_EXT_ATTR19 DATE

Date based extensible attribute column.
D_EXT_ATTR20 DATE

Date based extensible attribute column.
D_EXT_ATTR21 DATE

Date based extensible attribute column.
D_EXT_ATTR22 DATE

Date based extensible attribute column.
D_EXT_ATTR23 DATE

Date based extensible attribute column.
D_EXT_ATTR24 DATE

Date based extensible attribute column.
D_EXT_ATTR25 DATE

Date based extensible attribute column.
UOM_EXT_ATTR1 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR2 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR3 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR4 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR5 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR6 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR7 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR8 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR9 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR10 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR11 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR12 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR13 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR14 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR15 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR16 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR17 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR18 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR19 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR20 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR21 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR22 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR23 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR24 VARCHAR2 (3)
UOM based extensible attributes.
UOM_EXT_ATTR25 VARCHAR2 (3)
UOM based extensible attributes.
PARTY_ID NUMBER
Yes Identifier of a Service Request Contact Party
CONTACT_TYPE VARCHAR2 (30) Yes Contact Type
PARTY_ROLE_CODE VARCHAR2 (30) Yes Party role code
Query Text

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


SELECT EXTENSION_ID
,      INCIDENT_ID
,      CONTEXT
,      ATTR_GROUP_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      C_EXT_ATTR1
,      C_EXT_ATTR2
,      C_EXT_ATTR3
,      C_EXT_ATTR4
,      C_EXT_ATTR5
,      C_EXT_ATTR6
,      C_EXT_ATTR7
,      C_EXT_ATTR8
,      C_EXT_ATTR9
,      C_EXT_ATTR10
,      C_EXT_ATTR11
,      C_EXT_ATTR12
,      C_EXT_ATTR13
,      C_EXT_ATTR14
,      C_EXT_ATTR15
,      C_EXT_ATTR16
,      C_EXT_ATTR17
,      C_EXT_ATTR18
,      C_EXT_ATTR19
,      C_EXT_ATTR20
,      C_EXT_ATTR21
,      C_EXT_ATTR22
,      C_EXT_ATTR23
,      C_EXT_ATTR24
,      C_EXT_ATTR25
,      C_EXT_ATTR26
,      C_EXT_ATTR27
,      C_EXT_ATTR28
,      C_EXT_ATTR29
,      C_EXT_ATTR30
,      C_EXT_ATTR31
,      C_EXT_ATTR32
,      C_EXT_ATTR33
,      C_EXT_ATTR34
,      C_EXT_ATTR35
,      C_EXT_ATTR36
,      C_EXT_ATTR37
,      C_EXT_ATTR38
,      C_EXT_ATTR39
,      C_EXT_ATTR40
,      C_EXT_ATTR41
,      C_EXT_ATTR42
,      C_EXT_ATTR43
,      C_EXT_ATTR44
,      C_EXT_ATTR45
,      C_EXT_ATTR46
,      C_EXT_ATTR47
,      C_EXT_ATTR48
,      C_EXT_ATTR49
,      C_EXT_ATTR50
,      N_EXT_ATTR1
,      N_EXT_ATTR2
,      N_EXT_ATTR3
,      N_EXT_ATTR4
,      N_EXT_ATTR5
,      N_EXT_ATTR6
,      N_EXT_ATTR7
,      N_EXT_ATTR8
,      N_EXT_ATTR9
,      N_EXT_ATTR10
,      N_EXT_ATTR11
,      N_EXT_ATTR12
,      N_EXT_ATTR13
,      N_EXT_ATTR14
,      N_EXT_ATTR15
,      N_EXT_ATTR16
,      N_EXT_ATTR17
,      N_EXT_ATTR18
,      N_EXT_ATTR19
,      N_EXT_ATTR20
,      N_EXT_ATTR21
,      N_EXT_ATTR22
,      N_EXT_ATTR23
,      N_EXT_ATTR24
,      N_EXT_ATTR25
,      D_EXT_ATTR1
,      D_EXT_ATTR2
,      D_EXT_ATTR3
,      D_EXT_ATTR4
,      D_EXT_ATTR5
,      D_EXT_ATTR6
,      D_EXT_ATTR7
,      D_EXT_ATTR8
,      D_EXT_ATTR9
,      D_EXT_ATTR10
,      D_EXT_ATTR11
,      D_EXT_ATTR12
,      D_EXT_ATTR13
,      D_EXT_ATTR14
,      D_EXT_ATTR15
,      D_EXT_ATTR16
,      D_EXT_ATTR17
,      D_EXT_ATTR18
,      D_EXT_ATTR19
,      D_EXT_ATTR20
,      D_EXT_ATTR21
,      D_EXT_ATTR22
,      D_EXT_ATTR23
,      D_EXT_ATTR24
,      D_EXT_ATTR25
,      UOM_EXT_ATTR1
,      UOM_EXT_ATTR2
,      UOM_EXT_ATTR3
,      UOM_EXT_ATTR4
,      UOM_EXT_ATTR5
,      UOM_EXT_ATTR6
,      UOM_EXT_ATTR7
,      UOM_EXT_ATTR8
,      UOM_EXT_ATTR9
,      UOM_EXT_ATTR10
,      UOM_EXT_ATTR11
,      UOM_EXT_ATTR12
,      UOM_EXT_ATTR13
,      UOM_EXT_ATTR14
,      UOM_EXT_ATTR15
,      UOM_EXT_ATTR16
,      UOM_EXT_ATTR17
,      UOM_EXT_ATTR18
,      UOM_EXT_ATTR19
,      UOM_EXT_ATTR20
,      UOM_EXT_ATTR21
,      UOM_EXT_ATTR22
,      UOM_EXT_ATTR23
,      UOM_EXT_ATTR24
,      UOM_EXT_ATTR25
,      PARTY_ID
,      CONTACT_TYPE
,      PARTY_ROLE_CODE
FROM CS.CS_SR_CONTACTS_EXT_B;

Dependencies

[top of page]

CS.CS_SR_CONTACTS_EXT_B does not reference any database object

CS.CS_SR_CONTACTS_EXT_B is referenced by following:

SchemaAPPS
SynonymCS_SR_CONTACTS_EXT
SynonymCS_SR_CONTACTS_EXT_B