[Home] [Help] [Dependency Information]
Object Name: | AHL_ROUTE_OPERATIONS |
---|---|
Object Type: | TABLE |
Owner: | AHL |
FND Design Data: | AHL.AHL_ROUTE_OPERATIONS |
Subobject Name: | |
Status: | VALID |
This table stores the association between Routes and Operations. Any particular Route can have many Operations and any particular Operation can have many Routes. This table also stores the sequence in which the task or Operation must be accomplished. The attribute REVISION_STATUS_CODE can have the values Draft or Current in the table AHL_ROUTES_B. If the status of a Route is Current and any of the attributes of this record are changed, the previous version of the record is copied to a history table AHL_ROUTE_OPERATIONS_H.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AHL_ROUTE_OPERATIONS_U1 | NORMAL | UNIQUE | APPS_TS_SEED | ROUTE_OPERATION_ID |
AHL_ROUTE_OPERATIONS_U2 | NORMAL | UNIQUE | APPS_TS_SEED |
ROUTE_ID
OPERATION_ID STEP |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROUTE_OPERATION_ID | NUMBER | Yes | Primary Key, unique identifier of a Route operation association | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Stores locking sequence number | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ROUTE_ID | NUMBER | Yes | Unique identifier of a Route | |
OPERATION_ID | NUMBER | Yes | Unique identifier of an Operation | |
STEP | NUMBER | Yes | This attribute stores the order in which the operations must be completed | |
REVISION_NUMBER | NUMBER | Version number of the route which indicates how many times a route was modified | ||
ACTIVE_START_DATE | DATE | No longer used | ||
ACTIVE_END_DATE | DATE | No longer used | ||
CHECK_POINT_FLAG | VARCHAR2 | (1) | Identifier for logical grouping of operations | |
SECURITY_GROUP_ID | NUMBER | Used in application hosting | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT ROUTE_OPERATION_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ROUTE_ID
, OPERATION_ID
, STEP
, REVISION_NUMBER
, ACTIVE_START_DATE
, ACTIVE_END_DATE
, CHECK_POINT_FLAG
, SECURITY_GROUP_ID
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM AHL.AHL_ROUTE_OPERATIONS;
AHL.AHL_ROUTE_OPERATIONS does not reference any database object
AHL.AHL_ROUTE_OPERATIONS is referenced by following:
|
|
|