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: PA.PA_DIST_LIST_ITEMS

Object Details

Object Name:	PA_DIST_LIST_ITEMS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_DIST_LIST_ITEMS
Subobject Name:
Status:	VALID

The table PA_DIST_ LIST_ITEMS defines list of recipients who can access a particular object. The recipient can be a role or project team member or an email address

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PA_DIST_LIST_ITEM_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LIST_ITEM_ID
PA_DIST_LIST_ITEM_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	LIST_ID RECIPIENT_TYPE RECIPIENT_ID

Columns

Name	Datatype	Length	Mandatory	Comments
LIST_ITEM_ID	NUMBER	(15)	Yes	Serial number of an access list item with in an access list.
LIST_ID	NUMBER	(15)	Yes	Unique identifier of an access list
RECIPIENT_TYPE	VARCHAR2	(30)	Yes	Recipient type getting access to the object. It can be role or Internal Person OR external member (hz_party)
RECIPIENT_ID	VARCHAR2	(150)	Yes	Identifier of the Recipient id.
ACCESS_LEVEL	NUMBER	(2)		The level of access the recipient can have on the accessed object. It is specific to the access that is allowed on the object 1.View access 2.Update Access
MENU_ID	NUMBER	(15)		Access privilege allowed to the recipient
LAST_UPDATED_BY	NUMBER		Yes	Standard WHO Columns
CREATED_BY	NUMBER		Yes	Standard WHO Columns
CREATION_DATE	DATE		Yes	Standard WHO Columns
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Columns
LAST_UPDATE_LOGIN	NUMBER		Yes	Standard WHO Columns
RECORD_VERSION_NUMBER	NUMBER		Yes	The sequence number for lock strategy in self service applications
EMAIL	VARCHAR2	(1)		Indicator that recipient will receive email or not.

Query Text

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


SELECT LIST_ITEM_ID
,      LIST_ID
,      RECIPIENT_TYPE
,      RECIPIENT_ID
,      ACCESS_LEVEL
,      MENU_ID
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RECORD_VERSION_NUMBER
,      EMAIL
FROM PA.PA_DIST_LIST_ITEMS;

Dependencies

[top of page]

PA.PA_DIST_LIST_ITEMS does not reference any database object

PA.PA_DIST_LIST_ITEMS is referenced by following:

PA: PA_DIST_LIST_ITEMS#