DBA Data[Home] [Help] [Dependency Information]

TABLE: AHL.AHL_ROUTES_B

Object Details
Object Name: AHL_ROUTES_B
Object Type: TABLE
Owner: AHL
FND Design Data: TableAHL.AHL_ROUTES_B
Subobject Name:
Status: VALID


This table stores the Route attributes. Each Route is made up of one or more Operations. The Route authoring process is basically selecting pre-defined operations for a Route. The Operations have details of tasks and resources that are needed in order to complete any type of maintenance. The attribute REVISION_STATUS_CODE can have the values Draft or Current. If the status of a Route is Current and any of its attributes are changed the previous version of the record is copied to a history table AHL_ROUTES_H_B and the revision number is incremented. Resource such as manpower , machines, tools, consumable materials can also be allocated to a route.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AHL_ROUTES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnROUTE_ID
AHL_ROUTES_B_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnROUTE_NO
ColumnAPPLICATION_USG_CODE
ColumnREVISION_NUMBER
Columns
Name Datatype Length Mandatory Comments
ROUTE_ID NUMBER
Yes Primary Key, unique identifier of a Route
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_NO VARCHAR2 (30) Yes User defined attribute to identify a Route
REVISION_NUMBER NUMBER
Yes Version number of the route which indicates how many times a route was modified
REVISION_STATUS_CODE VARCHAR2 (30) Yes This attribute indicates the status of the operations, Whether it is current, draft, or archived
ACTIVE_START_DATE DATE

This attribute indicates the date from which the Route will be activated
ACTIVE_END_DATE DATE

This attribute indicates the date from which the Route will be deactivated
PRODUCT_TYPE_CODE VARCHAR2 (30)
Identifier for product type
ZONE_CODE VARCHAR2 (30)
Identifier for Zone
ROUTE_CATEGORY_CODE VARCHAR2 (30)
No longer used
ROUTE_TYPE_CODE VARCHAR2 (30)
This is an identifier of the type of the route
WORK_CENTER_CODE VARCHAR2 (30)
No longer used
SYSTEM_CODE1 VARCHAR2 (30)
SYSTEM_CODE2 VARCHAR2 (30)
SYSTEM_CODE3 VARCHAR2 (30)
PROCESS_CODE VARCHAR2 (30)
This is a production planning parameter
OPERATOR_CODE VARCHAR2 (30)
No longer used
OPERATOR_PARTY_ID NUMBER

Identifier of the operator of the Route
RTPRIM_SKILL_TYPE_CODE VARCHAR2 (30)
No longer used
SKILL_COMPETENCE_ID NUMBER (15)
Obsolete. This attribute identifies the primary skill required for a route (skill_type)
TIME_SPAN NUMBER

Total time span needed for a route.
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
QA_PLAN_ID NUMBER

Foreign key to QA_PLANS
SERVICE_ITEM_ID NUMBER

Foreign key to MTL_SYSTEM_ITEMS
SERVICE_ITEM_ORG_ID NUMBER

Organization ID for the item
TASK_TEMPLATE_GROUP_ID NUMBER

Foreign key to TASK_TEMPLATE_GROUPS_B
ACCOUNTING_CLASS_CODE VARCHAR2 (10)
Foreign key to WIP_ACCOUNTING_CLASSES
ACCOUNTING_CLASS_ORG_ID NUMBER

Organication ID for the Accounting Class
SUB_ZONE_CODE VARCHAR2 (30)
Identifier for sub zone
SEGMENT1 VARCHAR2 (30)
Key flexfield
SEGMENT2 VARCHAR2 (30)
Key flexfield
SEGMENT3 VARCHAR2 (30)
Key flexfield
SEGMENT4 VARCHAR2 (30)
Key flexfield
SEGMENT5 VARCHAR2 (30)
Key flexfield
SEGMENT6 VARCHAR2 (30)
Key flexfield
SEGMENT7 VARCHAR2 (30)
Key flexfield
SEGMENT8 VARCHAR2 (30)
Key flexfield
SEGMENT9 VARCHAR2 (30)
Key flexfield
SEGMENT10 VARCHAR2 (30)
Key flexfield
SEGMENT11 VARCHAR2 (30)
Key flexfield
SEGMENT12 VARCHAR2 (30)
Key flexfield
SEGMENT13 VARCHAR2 (30)
Key flexfield
SEGMENT14 VARCHAR2 (30)
Key flexfield
SEGMENT15 VARCHAR2 (30)
Key flexfield
SUMMARY_FLAG VARCHAR2 (1)
Standard Key Flexfield Column
ENABLED_FLAG VARCHAR2 (1)
Standard Key Flexfield Column
START_DATE_ACTIVE DATE

This attribute indicates the date from which the Route will be activated.
END_DATE_ACTIVE DATE

This attribute indicates the date from which the Route will be deactivated.
QA_INSPECTION_TYPE VARCHAR2 (150)
QA_INSPECTION_TYPE
APPLICATION_USG_CODE VARCHAR2 (30)
Added new field application usg code
UNIT_RECEIPT_UPDATE_FLAG VARCHAR2 (1)
Unit Receipt Flag for Update
MODEL_CODE VARCHAR2 (30)
Model Code.
ENIGMA_ROUTE_ID VARCHAR2 (80)
Unique Identifier for Enigma Routes
ENIGMA_DOC_ID VARCHAR2 (80)
Unique identifier corresponding to Enigma document
FILE_ID NUMBER

File identifier corresponding to Enigma change document uploaded in FNDL_LOBS
ENIGMA_PUBLISH_DATE DATE

Date field derived from enigma change xml
JOBCARDLYT_CODE VARCHAR2 (30)
Enigma jobcard layout code.
ENIGMA_SOURCE_CODE VARCHAR2 (30)
Enigma source code to determine automatic, manual or cmro route.
WARRANTY_TEMPLATE_ID NUMBER

Warranty Template ID
DUPLICATE_FLAG VARCHAR2 (1)
Flat to indicate duplicate tasks for a RTS instance.
RETURN_TO_SUPPLY_FLAG VARCHAR2 (1)
Flag to indicate return to supply route.
Query Text

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


SELECT ROUTE_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ROUTE_NO
,      REVISION_NUMBER
,      REVISION_STATUS_CODE
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      PRODUCT_TYPE_CODE
,      ZONE_CODE
,      ROUTE_CATEGORY_CODE
,      ROUTE_TYPE_CODE
,      WORK_CENTER_CODE
,      SYSTEM_CODE1
,      SYSTEM_CODE2
,      SYSTEM_CODE3
,      PROCESS_CODE
,      OPERATOR_CODE
,      OPERATOR_PARTY_ID
,      RTPRIM_SKILL_TYPE_CODE
,      SKILL_COMPETENCE_ID
,      TIME_SPAN
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      QA_PLAN_ID
,      SERVICE_ITEM_ID
,      SERVICE_ITEM_ORG_ID
,      TASK_TEMPLATE_GROUP_ID
,      ACCOUNTING_CLASS_CODE
,      ACCOUNTING_CLASS_ORG_ID
,      SUB_ZONE_CODE
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      QA_INSPECTION_TYPE
,      APPLICATION_USG_CODE
,      UNIT_RECEIPT_UPDATE_FLAG
,      MODEL_CODE
,      ENIGMA_ROUTE_ID
,      ENIGMA_DOC_ID
,      FILE_ID
,      ENIGMA_PUBLISH_DATE
,      JOBCARDLYT_CODE
,      ENIGMA_SOURCE_CODE
,      WARRANTY_TEMPLATE_ID
,      DUPLICATE_FLAG
,      RETURN_TO_SUPPLY_FLAG
FROM AHL.AHL_ROUTES_B;

Dependencies

[top of page]

AHL.AHL_ROUTES_B does not reference any database object

AHL.AHL_ROUTES_B is referenced by following:

SchemaAHL
ViewAHL_ROUTES_B#