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_OP_INTERFACE

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
ENIGMA_OP_ID	VARCHAR2	(80)	Enigma Operation Identifier.
ATA_CODE	VARCHAR2	(30)	ATA Code.
ENIGMA_DOC_ID	VARCHAR2	(80)	Enigma document identifier.
DML_OPERATION	VARCHAR2	(1)	DML operation flag.
OPERATOR	VARCHAR2	(30)	Field for Operation KFF segment.
EQUIPMENT	VARCHAR2	(30)	Field for Operation KFF segment.
OEM_DOC_TYPE	VARCHAR2	(30)	Field for Operation KFF segment.
CHAPTER_SECTION_SUBJECT	VARCHAR2	(30)	Field for Operation KFF segment.
AMTOSS_FUNCTION	VARCHAR2	(30)	Field for Operation KFF segment.
OP_SEQ	VARCHAR2	(30)	Field for Operation KFF segment.
CONFIG_LETTER	VARCHAR2	(30)	Field for Operation KFF segment.
PUBLISH_DATE	DATE		Enigma doc publish date.
PROCESS_DATE	DATE		Process date.
CONTEXT	VARCHAR2	(30)	Enigma context value.
DESCRIPTION	VARCHAR2	(2000)	Enigma operation description.
ERROR_MESSAGE	VARCHAR2	(2000)	Error message if any occured during record processing.
ISRECOVERABLE	VARCHAR2	(1)	Flag to indicate whether the error is recoverable or not.

Query Text

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


SELECT ENIGMA_OP_ID
,      ATA_CODE
,      ENIGMA_DOC_ID
,      DML_OPERATION
,      OPERATOR
,      EQUIPMENT
,      OEM_DOC_TYPE
,      CHAPTER_SECTION_SUBJECT
,      AMTOSS_FUNCTION
,      OP_SEQ
,      CONFIG_LETTER
,      PUBLISH_DATE
,      PROCESS_DATE
,      CONTEXT
,      DESCRIPTION
,      ERROR_MESSAGE
,      ISRECOVERABLE
FROM AHL.AHL_ENIGMA_OP_INTERFACE;

Dependencies

[top of page]

AHL.AHL_ENIGMA_OP_INTERFACE does not reference any database object

AHL.AHL_ENIGMA_OP_INTERFACE is referenced by following:

AHL: AHL_ENIGMA_OP_INTERFACE#