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.FND_IREP_CLASSES

Object Details

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

Integration Repository information concerning executable interfaces

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FND_IREP_CLASSES_U1	NORMAL	UNIQUE	APPS_TS_SEED	CLASS_ID ZD_EDITION_NAME
FND_IREP_CLASSES_U2	NORMAL	UNIQUE	APPS_TS_SEED	CLASS_NAME ZD_EDITION_NAME
SYS_IL0000398759C00023$$	LOB	UNIQUE	APPS_TS_SEED
SYS_IL0000398759C00024$$	LOB	UNIQUE	APPS_TS_SEED
FND_IREP_CLASSES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	PRODUCT_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
CLASS_ID	NUMBER	(15)	Yes	primary key
CLASS_NAME	VARCHAR2	(430)	Yes	unique qualified name of interface
IREP_NAME	VARCHAR2	(400)		native name of interface
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)	Yes	Standard who column
SECURITY_GROUP_ID	NUMBER			Security Group ID
CLASS_TYPE	VARCHAR2	(30)	Yes	Product that owns interface
PRODUCT_CODE	VARCHAR2	(8)	Yes	Technology type
IMPLEMENTATION_NAME	VARCHAR2	(400)		Java Implementation name
DEPLOYED_FLAG	VARCHAR2	(1)	Yes	Deployed Flag
GENERATED_FLAG	VARCHAR2	(1)	Yes	Generated Flag
COMPATIBILITY_FLAG	VARCHAR2	(1)	Yes	Compatability Flag
ASSOC_CLASS_ID	NUMBER	(15)		Pointer to Base Class
SCOPE_TYPE	VARCHAR2	(30)	Yes	Scope
LIFECYCLE_MODE	VARCHAR2	(30)	Yes	Lifecycle
SOURCE_FILE_PRODUCT	VARCHAR2	(8)		Product for source file
SOURCE_FILE_PATH	VARCHAR2	(100)		Path for source file
SOURCE_FILE_NAME	VARCHAR2	(36)		Source file name
SOURCE_FILE_VERSION	VARCHAR2	(150)		Version of source file
DESCRIPTION	CLOB	(4000)		Description
XML_DESCRIPTION	CLOB	(4000)		WSDL or Schema
STANDARD_TYPE	VARCHAR2	(30)		Standard Type
STANDARD_VERSION	VARCHAR2	(30)		Version of Standard
STANDARD_SPEC	VARCHAR2	(240)		Specification for Standard
LOAD_ERR	VARCHAR2	(1)		Loading Error Flag
LOAD_ERR_MSGS	VARCHAR2	(4000)		Loading Error Buffer
OPEN_INTERFACE_FLAG	VARCHAR2	(1)		Open Interface Flag
MAP_CODE	VARCHAR2	(255)
IREP_LDR_PP_FLAG	VARCHAR2	(1)		Loader Post Processing Flag
IREP_HIDE_SCHEMA	VARCHAR2	(1)		Flag for Hide Schema
INTERFACE_CLASS	VARCHAR2	(400)		Interface Class
IREP_LDR_INTERNAL_FLAG	VARCHAR2	(1)
ACTIVE_FLAG	VARCHAR2	(1)
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT CLASS_ID
,      CLASS_NAME
,      IREP_NAME
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SECURITY_GROUP_ID
,      CLASS_TYPE
,      PRODUCT_CODE
,      IMPLEMENTATION_NAME
,      DEPLOYED_FLAG
,      GENERATED_FLAG
,      COMPATIBILITY_FLAG
,      ASSOC_CLASS_ID
,      SCOPE_TYPE
,      LIFECYCLE_MODE
,      SOURCE_FILE_PRODUCT
,      SOURCE_FILE_PATH
,      SOURCE_FILE_NAME
,      SOURCE_FILE_VERSION
,      DESCRIPTION
,      XML_DESCRIPTION
,      STANDARD_TYPE
,      STANDARD_VERSION
,      STANDARD_SPEC
,      LOAD_ERR
,      LOAD_ERR_MSGS
,      OPEN_INTERFACE_FLAG
,      MAP_CODE
,      IREP_LDR_PP_FLAG
,      IREP_HIDE_SCHEMA
,      INTERFACE_CLASS
,      IREP_LDR_INTERNAL_FLAG
,      ACTIVE_FLAG
,      ZD_EDITION_NAME
FROM APPLSYS.FND_IREP_CLASSES;

Dependencies

[top of page]

APPLSYS.FND_IREP_CLASSES does not reference any database object

APPLSYS.FND_IREP_CLASSES is referenced by following:

APPLSYS: FND_IREP_CLASSES#