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_SIGS

Object Details

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

digital signatures table

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
SYS_IL0000241120C00007$$	LOB	UNIQUE	APPS_TS_TX_DATA
SYS_IL0000241120C00008$$	LOB	UNIQUE	APPS_TS_TX_DATA
WF_DIG_SIGS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS SIG_ID
WF_DIG_SIGS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SIG_ID STATUS
WF_DIG_SIGS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CERT_ID STATUS
WF_DIG_SIGS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SIG_OBJ_ID SIG_OBJ_TYPE
WF_DIG_SIGS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REQUESTED_SIGNER_ID REQUESTED_SIGNER_TYPE
WF_DIG_SIGS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
WF_DIG_SIGS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SIGNED_DATE
WF_DIG_SIGS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VERIFIED_DATE
WF_DIG_SIGS_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VALIDATED_COMPLETE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
SIG_ID	NUMBER		Yes	signature id
CERT_ID	NUMBER			certificate id for signature
SIG_POLICY	VARCHAR2	(30)		signature policy used
SIG_FLAVOR	VARCHAR2	(30)		signature flavor
SIG_OBJ_TYPE	VARCHAR2	(20)	Yes	object type associated with sig
SIG_OBJ_ID	VARCHAR2	(30)	Yes	id of object associated with sig
PLAINTEXT	CLOB	(4000)		text to be signed
SIGNATURE	CLOB	(4000)		signature data
REQUESTED_SIGNER_TYPE	VARCHAR2	(20)		type of signer requested
REQUESTED_SIGNER_ID	VARCHAR2	(320)		id of signer requested
STATUS	NUMBER			status
CREATION_DATE	DATE			sig created on
SIGNED_DATE	DATE			sig signed on
VERIFIED_DATE	DATE			sig verified on
LAST_VALIDATION_ATTEMPT	DATE			attempted validation of sig last time on
VALIDATED_COMPLETE_DATE	DATE			actually validated on
ERRBUF	VARCHAR2	(2000)		error info
ERRSTACK	VARCHAR2	(2000)		error info
SECURITY_GROUP_ID	VARCHAR2	(32)		identifier reserved for hosting environment

Query Text

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


SELECT SIG_ID
,      CERT_ID
,      SIG_POLICY
,      SIG_FLAVOR
,      SIG_OBJ_TYPE
,      SIG_OBJ_ID
,      PLAINTEXT
,      SIGNATURE
,      REQUESTED_SIGNER_TYPE
,      REQUESTED_SIGNER_ID
,      STATUS
,      CREATION_DATE
,      SIGNED_DATE
,      VERIFIED_DATE
,      LAST_VALIDATION_ATTEMPT
,      VALIDATED_COMPLETE_DATE
,      ERRBUF
,      ERRSTACK
,      SECURITY_GROUP_ID
FROM APPLSYS.WF_DIG_SIGS;

Dependencies

[top of page]

APPLSYS.WF_DIG_SIGS does not reference any database object

APPLSYS.WF_DIG_SIGS is referenced by following:

APPLSYS: WF_DIG_SIGS#