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

TABLE: CSM.CSM_HA_PAYLOAD_DATA

Object Details
Object Name: CSM_HA_PAYLOAD_DATA
Object Type: TABLE
Owner: CSM
FND Design Data: TableCSM.CSM_HA_PAYLOAD_DATA
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSM_HA_PAYLOAD_DATA_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnHA_PAYLOAD_ID
SYS_IL0000510109C00015$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
SYS_IL0000510109C00017$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
CSM_HA_PAYLOAD_DATA_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPROCESSED
CSM_HA_PAYLOAD_DATA_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_NAME
Columns
Name Datatype Length Mandatory Comments
HA_PAYLOAD_ID NUMBER
Yes
OBJECT_NAME VARCHAR2 (100) Yes
PK_VALUE VARCHAR2 (1000) Yes
DML_TYPE VARCHAR2 (1) Yes
PARENT_PAYLOAD_ID NUMBER

MOBILE_DATA VARCHAR2 (1) Yes
PROCESSED VARCHAR2 (1) Yes
COMMENTS VARCHAR2 (4000)
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER
Yes
PAYLOAD XMLTYPE (2000)
CONTEXT XMLTYPE (2000)
STATUS VARCHAR2 (100)
Query Text

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


SELECT HA_PAYLOAD_ID
,      OBJECT_NAME
,      PK_VALUE
,      DML_TYPE
,      PARENT_PAYLOAD_ID
,      MOBILE_DATA
,      PROCESSED
,      COMMENTS
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PAYLOAD
,      CONTEXT
,      STATUS
FROM CSM.CSM_HA_PAYLOAD_DATA;

Dependencies

[top of page]

CSM.CSM_HA_PAYLOAD_DATA references the following:

SchemaSYS
PL/SQL PackageSTANDARD - show dependent code
TYPEXMLTYPE
CSM.CSM_HA_PAYLOAD_DATA is referenced by following:

SchemaCSM
ViewCSM_HA_PAYLOAD_DATA#