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: XNP.XNP_SV_STATUS_TYPES_B

Object Details

Object Name:	XNP_SV_STATUS_TYPES_B
Object Type:	TABLE
Owner:	XNP
FND Design Data:	XNP.XNP_SV_STATUS_TYPES_B
Subobject Name:
Status:	VALID

XNP_SV_STATUS_TYPES_V stores the valid statuses that may be assigned to a SOA subscription version. Update to this table should be limited to a system administrator.
The subscription version status decides what information can be inserted and what information will be written to historical tables.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XNP_SV_STATUS_TYPES_B_U1	NORMAL	UNIQUE	APPS_TS_SEED	STATUS_TYPE_CODE
XNP_SV_STATUS_TYPES_B_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	INITIAL_FLAG
XNP_SV_STATUS_TYPES_B_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	PHASE_INDICATOR

Columns

Name	Datatype	Length	Mandatory	Comments
STATUS_TYPE_CODE	VARCHAR2	(20)	Yes	Code for the status type
PHASE_INDICATOR	VARCHAR2	(20)	Yes	Indicates the phase of the status type code
ACTIVE_FLAG	VARCHAR2	(1)	Yes	Indicates if the status is in use
INITIAL_FLAG	VARCHAR2	(1)	Yes	Initial status of a subscription version - Not used
INITIAL_FLAG_ENFORCE_SEQ	NUMBER		Yes	Enforces rule that only one row has INITIAL_FLAG set - Not used
DISPLAY_SEQUENCE	NUMBER		Yes	Sequence of status displayed on screens and reports
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments

Query Text

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


SELECT STATUS_TYPE_CODE
,      PHASE_INDICATOR
,      ACTIVE_FLAG
,      INITIAL_FLAG
,      INITIAL_FLAG_ENFORCE_SEQ
,      DISPLAY_SEQUENCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
FROM XNP.XNP_SV_STATUS_TYPES_B;

Dependencies

[top of page]

XNP.XNP_SV_STATUS_TYPES_B does not reference any database object

XNP.XNP_SV_STATUS_TYPES_B is referenced by following:

APPS: XNP_SV_STATUS_TYPES_B