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

TABLE: CSL.CSL_HZ_RELATIONSHIPS_ACC

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


Table stores therelationships between entities per resource which needs to be replicated


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
CSL_HZ_RELATIONSHIPS_ACC_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOUNTER
CSL_HZ_RELATIONSHIPS_ACC_U1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRESOURCE_ID
ColumnRELATIONSHIP_ID
ColumnDIRECTIONAL_FLAG
CSL_HZ_RELATIONSHIPS_ACC_U2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACCESS_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Yes Mobile resource ID, references to JTF_RS_RESOURCE_EXTNS.RESOURCE_ID
RELATIONSHIP_ID NUMBER
Yes The unique identifier of a relationship
DIRECTIONAL_FLAG VARCHAR2 (1) Yes Indicates if this is a directional relationship, such as parent-to-child or headquarters-to-branch. F for a forward relationship and B for a backward relationship.
ACCESS_ID NUMBER

PK - Indentifier for replication
COUNTER NUMBER

Counter, indicates the amount of reasons for the record to be replicated
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER (15) Yes Standard who column
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER (15) Yes Standard who column
Query Text

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


SELECT RESOURCE_ID
,      RELATIONSHIP_ID
,      DIRECTIONAL_FLAG
,      ACCESS_ID
,      COUNTER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
FROM CSL.CSL_HZ_RELATIONSHIPS_ACC;

Dependencies

[top of page]

CSL.CSL_HZ_RELATIONSHIPS_ACC does not reference any database object

CSL.CSL_HZ_RELATIONSHIPS_ACC is referenced by following:

SchemaAPPS
SynonymCSL_HZ_RELATIONSHIPS_ACC