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_RT_OPER_INTERFACE

Object Details

Object Name:	AHL_RT_OPER_INTERFACE
Object Type:	TABLE
Owner:	AHL
Subobject Name:
Status:	VALID

Interface table to hold the status of processing enigma route/operation record

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
CONTEXT	VARCHAR2	(30)	Yes	Enimga Context
PUBLISH_DATE	DATE		Yes	Publish date
ROUTE_ID	VARCHAR2	(80)		Enigma route identifier
PDF	VARCHAR2	(100)		Enigma change pdf document name
REVISION_DATE	DATE			Enigma document revision date
OPERATION_ID	VARCHAR2	(80)		Enigma operation identifier
PARENT_ROUTE_ID	VARCHAR2	(80)		Parent Route identifier
CHANGE_FLAG	VARCHAR2	(1)	Yes	Change flag
ATA_CODE	VARCHAR2	(30)		ATA Code
DESCRIPTION	VARCHAR2	(2000)		Change description
STATUS	VARCHAR2	(30)		Process status
REASON	VARCHAR2	(2000)		Reason
ENIGMA_ID	VARCHAR2	(80)		Enigma document identifier

Query Text

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


SELECT CONTEXT
,      PUBLISH_DATE
,      ROUTE_ID
,      PDF
,      REVISION_DATE
,      OPERATION_ID
,      PARENT_ROUTE_ID
,      CHANGE_FLAG
,      ATA_CODE
,      DESCRIPTION
,      STATUS
,      REASON
,      ENIGMA_ID
FROM AHL.AHL_RT_OPER_INTERFACE;

Dependencies

[top of page]

AHL.AHL_RT_OPER_INTERFACE does not reference any database object

AHL.AHL_RT_OPER_INTERFACE is referenced by following:

APPS: AHL_RT_OPER_INTERFACE