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]

VIEW: APPS.FND_IREP_CLASSES_VL

Object Details

Object Name:	FND_IREP_CLASSES_VL
Object Type:	VIEW
Owner:	APPS
FND Design Data:	FND.FND_IREP_CLASSES_VL
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
ROW_ID	ROWID	(10)
CLASS_ID	NUMBER	(15)	Yes
CLASS_NAME	VARCHAR2	(430)	Yes
IREP_NAME	VARCHAR2	(400)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes
SECURITY_GROUP_ID	NUMBER
CLASS_TYPE	VARCHAR2	(30)	Yes
PRODUCT_CODE	VARCHAR2	(8)	Yes
IMPLEMENTATION_NAME	VARCHAR2	(400)
DEPLOYED_FLAG	VARCHAR2	(1)	Yes
GENERATED_FLAG	VARCHAR2	(1)	Yes
ACTIVE_FLAG	VARCHAR2	(1)
COMPATIBILITY_FLAG	VARCHAR2	(1)	Yes
ASSOC_CLASS_ID	NUMBER	(15)
SCOPE_TYPE	VARCHAR2	(30)	Yes
LIFECYCLE_MODE	VARCHAR2	(30)	Yes
SOURCE_FILE_PRODUCT	VARCHAR2	(8)
SOURCE_FILE_PATH	VARCHAR2	(100)
SOURCE_FILE_NAME	VARCHAR2	(36)
SOURCE_FILE_VERSION	VARCHAR2	(150)
DESCRIPTION	CLOB	(4000)
XML_DESCRIPTION	CLOB	(4000)
STANDARD_TYPE	VARCHAR2	(30)
STANDARD_VERSION	VARCHAR2	(30)
STANDARD_SPEC	VARCHAR2	(240)
LOAD_ERR	VARCHAR2	(1)
LOAD_ERR_MSGS	VARCHAR2	(4000)
OPEN_INTERFACE_FLAG	VARCHAR2	(1)
MAP_CODE	VARCHAR2	(255)
DISPLAY_NAME	VARCHAR2	(240)	Yes
SHORT_DESCRIPTION	VARCHAR2	(2000)
IREP_LDR_PP_FLAG	VARCHAR2	(1)
IREP_HIDE_SCHEMA	VARCHAR2	(1)
INTERFACE_CLASS	VARCHAR2	(400)

Query Text

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


SELECT ROW_ID
,      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
,      ACTIVE_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
,      DISPLAY_NAME
,      SHORT_DESCRIPTION
,      IREP_LDR_PP_FLAG
,      IREP_HIDE_SCHEMA
,      INTERFACE_CLASS
FROM APPS.FND_IREP_CLASSES_VL;

Dependencies

[top of page]

APPS.FND_IREP_CLASSES_VL references the following:

APPS: FND_IREP_CLASSES; FND_IREP_CLASSES_TL

APPS.FND_IREP_CLASSES_VL is referenced by following:

APPS: FND_IREP_ALL_INTERFACES; SOA_GENERATE - show dependent code; WF_WS_GEN - show dependent code