[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CONTEXT | VARCHAR2 | (30) | Yes | Enimga Context |
PUBLISH_DATE | DATE | Yes | Publish date | |
ROUTE_ID | VARCHAR2 | (80) | Enigma route identifier | |
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 |
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;
AHL.AHL_RT_OPER_INTERFACE does not reference any database object
AHL.AHL_RT_OPER_INTERFACE is referenced by following:
|
|
|