eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: AR.HZ_DSS_ASSIGNMENTS

Object Details

Object Name:	HZ_DSS_ASSIGNMENTS
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_DSS_ASSIGNMENTS
Subobject Name:
Status:	VALID

The HZ_DSS_ASSIGNMENTS table stores assignments of data
sharing groups to instances of an entity. For example, a data sharing group
of Public can be assigned to a particular party, in other words, a specific
row in the HZ_PARTIES table.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_DSS_ASSIGNMENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_ID	NUMBER	(15)	Yes	Sequence generated unique identifier for an assignment
DSS_GROUP_CODE	VARCHAR2	(30)	Yes	Unique code for a data sharing group
STATUS	VARCHAR2	(1)	Yes	Status of this record
OWNER_TABLE_NAME	VARCHAR2	(30)	Yes	Table that the data sharing group is assigned to
OWNER_TABLE_ID1	VARCHAR2	(240)	Yes	Primary key of the data sharing group assignee
OWNER_TABLE_ID2	VARCHAR2	(240)		Primary key of the data sharing group assignee
OWNER_TABLE_ID3	VARCHAR2	(240)		Primary key of the data sharing group assignee
OWNER_TABLE_ID4	VARCHAR2	(240)		Primary key of the data sharing group assignee
OWNER_TABLE_ID5	VARCHAR2	(240)		Primary key of the data sharing group assignee
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Version number for locking purposes
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

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


SELECT ASSIGNMENT_ID
,      DSS_GROUP_CODE
,      STATUS
,      OWNER_TABLE_NAME
,      OWNER_TABLE_ID1
,      OWNER_TABLE_ID2
,      OWNER_TABLE_ID3
,      OWNER_TABLE_ID4
,      OWNER_TABLE_ID5
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
FROM AR.HZ_DSS_ASSIGNMENTS;

Dependencies

[top of page]

AR.HZ_DSS_ASSIGNMENTS does not reference any database object

AR.HZ_DSS_ASSIGNMENTS is referenced by following:

AR: HZ_DSS_ASSIGNMENTS#