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: AHL.AHL_ENIGMA_RT_INTERFACE

Object Details

Object Name:	AHL_ENIGMA_RT_INTERFACE
Object Type:	TABLE
Owner:	AHL
FND Design Data:	AHL.AHL_ENIGMA_RT_INTERFACE
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
ENIGMA_ROUTE_ID	VARCHAR2	(80)	Eniga route identifier.
ATA_CODE	VARCHAR2	(30)	ATA code.
PDF_FILE_NAME	VARCHAR2	(100)	name of the PDF file associated with route.
ENIGMA_DOC_ID	VARCHAR2	(80)	Enigma document identifier.
DML_OPERATION	VARCHAR2	(2)	DML operation flag.
REVISION_DATE	DATE		Enigma document revision date.
CONTEXT	VARCHAR2	(30)	Context value passed by Enigma.
PUBLISH_DATE	DATE		Enigma publish date.
PROCESS_DATE	DATE		Date of process.
DESCRIPTION	VARCHAR2	(2000)	Route description.
ERROR_MESSAGE	VARCHAR2	(2000)	Error message detailed exception occuring during route processing.
ISRECOVERABLE	VARCHAR2	(1)	Flag to distinguish recoverable error from non-recoverable error.

Query Text

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


SELECT ENIGMA_ROUTE_ID
,      ATA_CODE
,      PDF_FILE_NAME
,      ENIGMA_DOC_ID
,      DML_OPERATION
,      REVISION_DATE
,      CONTEXT
,      PUBLISH_DATE
,      PROCESS_DATE
,      DESCRIPTION
,      ERROR_MESSAGE
,      ISRECOVERABLE
FROM AHL.AHL_ENIGMA_RT_INTERFACE;

Dependencies

[top of page]

AHL.AHL_ENIGMA_RT_INTERFACE does not reference any database object

AHL.AHL_ENIGMA_RT_INTERFACE is referenced by following:

AHL: AHL_ENIGMA_RT_INTERFACE#