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: ZPB.ZPB_ACCOUNT_STATES

Object Details

Object Name:	ZPB_ACCOUNT_STATES
Object Type:	TABLE
Owner:	ZPB
Subobject Name:
Status:	VALID

This table stores user account states, e.g. new user, current user, expired user

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZPB_ACCOUNT_STATES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	BUSINESS_AREA_ID USER_ID RESP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
SUBJECT_ID	RAW	(16)	Yes	Foreign key into bism.subjects
GROUP_ID	RAW	(16)	Yes	Foreign key into bism.groups
USER_ID	NUMBER		Yes	foreign key into fnd_users
RESP_ID	NUMBER		Yes	foreign key into fnd_responsibility
ASSIGNEE	VARCHAR2	(100)		Name of designated user who is assigned all of the user data scoping and ownership privileges. Only applicable for expired users.
ACCOUNT_STATUS	NUMBER			Column represents a user account as either new, current or expired
READ_SCOPE	NUMBER	(1)		User read scope
WRITE_SCOPE	NUMBER	(1)		User write scope
OWNERSHIP	NUMBER	(1)		ownership
METADATA_SCOPE	NUMBER	(1)		Metadata scope
CREATION_DATE	DATE		Yes	Standard who column
LAST_LOGIN_DATE	DATE			Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
LAST_UPDATE_DATE	DATE		Yes	Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Who column
CREATED_BY	NUMBER	(15)	Yes	Standard who column
BUSINESS_AREA_ID	NUMBER	(10)	Yes	Business Area ID
HAS_READ_ACCESS	NUMBER			Does the user have read access
ACCOUNT_STATUS_UPDATE_DATE	DATE			Tracks when the account status field changes.

Query Text

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


SELECT SUBJECT_ID
,      GROUP_ID
,      USER_ID
,      RESP_ID
,      ASSIGNEE
,      ACCOUNT_STATUS
,      READ_SCOPE
,      WRITE_SCOPE
,      OWNERSHIP
,      METADATA_SCOPE
,      CREATION_DATE
,      LAST_LOGIN_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      BUSINESS_AREA_ID
,      HAS_READ_ACCESS
,      ACCOUNT_STATUS_UPDATE_DATE
FROM ZPB.ZPB_ACCOUNT_STATES;

Dependencies

[top of page]

ZPB.ZPB_ACCOUNT_STATES does not reference any database object

ZPB.ZPB_ACCOUNT_STATES is referenced by following:

APPS: ZPB_ACCOUNT_STATES