[Home] [Help] [Dependency Information]

TABLE: PV.PV_ALLOWED_STATUSES

Object Details

Object Name:	PV_ALLOWED_STATUSES
Object Type:	TABLE
Owner:	PV
FND Design Data:	PV.PV_ALLOWED_STATUSES
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PV_ALLOWED_STATUSES_U1	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ALLOWED_STATUS_ID
PV_ALLOWED_STATUSES_N1	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	TO_STATUS_CODE
PV_ALLOWED_STATUSES_N2	NORMAL	NONUNIQUE	APPS_TS_ARCHIVE	FROM_STATUS_CODE

Columns

Query Text

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

SELECT ALLOWED_STATUS_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      STATUS_CATEGORY
,      STATUS_TYPE
,      FROM_STATUS_CODE
,      TO_STATUS_CODE
,      SECURITY_GROUP_ID
,      ENABLED_FLAG
,      LOV_FLAG
,      TIMEOUT_NOTIFY_FLAG
,      DURATION_VIEW_TYPE_CODE
,      NOTIFY_PT_FLAG
,      NOTIFY_CM_FLAG
,      NOTIFY_LAM_FLAG
,      NOTIFY_SUPPORT_REP_FLAG
FROM PV.PV_ALLOWED_STATUSES;

Dependencies

[top of page]

PV.PV_ALLOWED_STATUSES does not reference any database object

PV.PV_ALLOWED_STATUSES is referenced by following:

APPS

PV_ALLOWED_STATUSES