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: XDP.XDP_FE_SW_GEN_LOOKUP

Object Details

Object Name:	XDP_FE_SW_GEN_LOOKUP
Object Type:	TABLE
Owner:	XDP
FND Design Data:	XDP.XDP_FE_SW_GEN_LOOKUP
Subobject Name:
Status:	VALID

XDP_FE_SW_GENERIC_LOOKUP is the definition table for Software Generics. This table holds available Software Generics for a Fulfillment Element Type.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XDP_FE_SW_GEN_LOOKUP_U1	NORMAL	UNIQUE	APPS_TS_SEED	FE_SW_GEN_LOOKUP_ID ZD_EDITION_NAME
XDP_FE_SW_GEN_LOOKUP_U2	NORMAL	UNIQUE	APPS_TS_SEED	FETYPE_ID SW_GENERIC ADAPTER_TYPE ZD_EDITION_NAME

Columns

Name	Datatype	Length	Mandatory	Comments
FE_SW_GEN_LOOKUP_ID	NUMBER		Yes	Fulfillment Element Software Generic Identifier
FETYPE_ID	NUMBER		Yes	Fulfillment Element Type Identfier to which this Software Generic belongs to
SW_GENERIC	VARCHAR2	(40)	Yes	Software Generic name
ADAPTER_TYPE	VARCHAR2	(40)	Yes	Adapter Type for this Software Generic
SW_START_PROC	VARCHAR2	(80)		Connect Procedure for this Software Generic
SW_EXIT_PROC	VARCHAR2	(80)		Disconnect Procedure for this Software Generic
CREATION_DATE	DATE		Yes	Standardwho Column
LAST_UPDATE_DATE	DATE		Yes	Standardwho Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standardwho Column
CREATED_BY	NUMBER	(15)	Yes	Standardwho Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standardwho Column
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT FE_SW_GEN_LOOKUP_ID
,      FETYPE_ID
,      SW_GENERIC
,      ADAPTER_TYPE
,      SW_START_PROC
,      SW_EXIT_PROC
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM XDP.XDP_FE_SW_GEN_LOOKUP;

Dependencies

[top of page]

XDP.XDP_FE_SW_GEN_LOOKUP does not reference any database object

XDP.XDP_FE_SW_GEN_LOOKUP is referenced by following:

XDP: XDP_FE_SW_GEN_LOOKUP#