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: APPLSYS.WF_DIG_CERTS

Object Details

Object Name:	WF_DIG_CERTS
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.WF_DIG_CERTS
Subobject Name:
Status:	VALID

digital certificates table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000241109C00001$$	LOB	UNIQUE	APPS_TS_TX_DATA

Columns

Name	Datatype	Length	Mandatory	Comments
CERT	CLOB	(4000)	Yes	certificate data
CERT_ID	NUMBER		Yes	certificate ID
CERT_TYPE	VARCHAR2	(30)	Yes	type of certificate
PARENT_CERT_ID	NUMBER			pointer to parent certificate
OWNER_ID	VARCHAR2	(320)		id of entity associated
OWNER_DOMAIN	VARCHAR2	(20)		type of entity associated with certificate
VALID	VARCHAR2	(1)	Yes	valid flag
SOT_FLAG	VARCHAR2	(1)	Yes	source of truth flag
INTERMEDIATE_FLAG	VARCHAR2	(1)	Yes	intermediate flag
FINGERPRINT	VARCHAR2	(64)		fingerprint of certificate
EXPIRE	DATE			expire date
SECURITY_GROUP_ID	VARCHAR2	(32)		identifier reserved for hosting environment
SUBJECTDN	VARCHAR2	(1024)		The subject name of the certificate

Query Text

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


SELECT CERT
,      CERT_ID
,      CERT_TYPE
,      PARENT_CERT_ID
,      OWNER_ID
,      OWNER_DOMAIN
,      VALID
,      SOT_FLAG
,      INTERMEDIATE_FLAG
,      FINGERPRINT
,      EXPIRE
,      SECURITY_GROUP_ID
,      SUBJECTDN
FROM APPLSYS.WF_DIG_CERTS;

Dependencies

[top of page]

APPLSYS.WF_DIG_CERTS does not reference any database object

APPLSYS.WF_DIG_CERTS is referenced by following:

APPLSYS: WF_DIG_CERTS#