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


VIEW: APPS.AHL_ROUTES_V

Object Details
Object Name: AHL_ROUTES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_ROUTES_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

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 operation, Whether it is current, draft, or archived
REVISION_STATUS VARCHAR2 (80) Yes Corresponding meaning for Revision_status_code
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 operation will be activated
END_DATE_ACTIVE DATE

This attribute indicates the date from which the operation will be deactivated
OPERATOR_PARTY_ID NUMBER

Identifier of the operator of the Route
OPERATOR_NAME VARCHAR2 (360)
Describe the party name of the operator.
SERVICE_ITEM_ID NUMBER

Foreign key to MTL_SYSTEM_ITEMS
SERVICE_ITEM_ORG_ID NUMBER

Organization ID for the item
SERVICE_ITEM_NUMBER VARCHAR2 (40)
Item Number
TASK_TEMPLATE_GROUP_ID NUMBER

Foreign key to TASK_TEMPLATE_GROUPS_B
TASK_TEMPLATE_GROUP VARCHAR2 (80)
Task template group name
ACCOUNTING_CLASS_CODE VARCHAR2 (10)
Foreign key to WIP_ACCOUNTING_CLASSES
ACCOUNTING_CLASS_ORG_ID NUMBER

Organication ID for the Accounting Class
ACCOUNTING_CLASS VARCHAR2 (240)
Accounting class name
ROUTE_TYPE_CODE VARCHAR2 (30)
This is an identifier of the type of the route
ROUTE_TYPE VARCHAR2 (80)
Corresponding meaning for Route_type_code
PRODUCT_TYPE_CODE VARCHAR2 (30)
Identifier for product type
PRODUCT_TYPE VARCHAR2 (80)
Corresponding meaning for Product_type_code
ZONE_CODE VARCHAR2 (30)
Identifier for Zone
ZONE VARCHAR2 (80)
Corresponding meaning for Zone_code
SUB_ZONE_CODE VARCHAR2 (30)
Identifier for sub zone
SUB_ZONE VARCHAR2 (80)
Sub zone meaning
PROCESS_CODE VARCHAR2 (30)
This is a production planning parameter
PROCESS VARCHAR2 (80)
Corresponding meaning for Process_code
APPLICATION_USG_CODE VARCHAR2 (30)
TIME_SPAN NUMBER

Time span needed for a route.
QA_INSPECTION_TYPE VARCHAR2 (150)
QA_INSPECTION_TYPE
QA_INSPECTION_TYPE_DESC VARCHAR2 (150)
QA_INSPECTION_TYPE_DESC
SEGMENT1 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT2 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT3 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT4 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT5 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT6 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT7 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT8 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT9 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT10 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT11 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT12 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT13 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT14 VARCHAR2 (30)
User defined attribute to identify an operation
SEGMENT15 VARCHAR2 (30)
User defined attribute to identify an operation
CONCATENATED_SEGMENTS CHAR (1)
User defined identifier of the operation
TITLE VARCHAR2 (240) Yes Title for the route
REMARKS VARCHAR2 (2000)
This attribute stores any remarks about an operation
REVISION_NOTES VARCHAR2 (2000)
Revison Notes
APPROVER_NOTE VARCHAR2 (2000)
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
UNIT_RECEIPT_UPDATE_FLAG VARCHAR2 (1)
UNIT_RECEIPT_UPDATE VARCHAR2 (80)
MODEL_CODE VARCHAR2 (30)
Model code
MODEL_MEANING VARCHAR2 (80)
Lookup meaning corresponding to model code
ENIGMA_DOC_ID VARCHAR2 (80)
Enigma document identifier
ENIGMA_ROUTE_ID VARCHAR2 (80)
Enigma Route identifier
FILE_ID NUMBER

Enigma change document identifier
ENIGMA_PUBLISH_DATE DATE

Enigma document publish date
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
,      REVISION_STATUS
,      SUMMARY_FLAG
,      ENABLED_FLAG
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      OPERATOR_PARTY_ID
,      OPERATOR_NAME
,      SERVICE_ITEM_ID
,      SERVICE_ITEM_ORG_ID
,      SERVICE_ITEM_NUMBER
,      TASK_TEMPLATE_GROUP_ID
,      TASK_TEMPLATE_GROUP
,      ACCOUNTING_CLASS_CODE
,      ACCOUNTING_CLASS_ORG_ID
,      ACCOUNTING_CLASS
,      ROUTE_TYPE_CODE
,      ROUTE_TYPE
,      PRODUCT_TYPE_CODE
,      PRODUCT_TYPE
,      ZONE_CODE
,      ZONE
,      SUB_ZONE_CODE
,      SUB_ZONE
,      PROCESS_CODE
,      PROCESS
,      APPLICATION_USG_CODE
,      TIME_SPAN
,      QA_INSPECTION_TYPE
,      QA_INSPECTION_TYPE_DESC
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      CONCATENATED_SEGMENTS
,      TITLE
,      REMARKS
,      REVISION_NOTES
,      APPROVER_NOTE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      UNIT_RECEIPT_UPDATE_FLAG
,      UNIT_RECEIPT_UPDATE
,      MODEL_CODE
,      MODEL_MEANING
,      ENIGMA_DOC_ID
,      ENIGMA_ROUTE_ID
,      FILE_ID
,      ENIGMA_PUBLISH_DATE
FROM APPS.AHL_ROUTES_V;

Dependencies

[top of page]

APPS.AHL_ROUTES_V references the following:

SchemaAPPS
ViewAHL_ROUTES_B_KFV
SynonymAHL_ROUTES_TL
SynonymFND_LOOKUP_VALUES
PL/SQL PackageFND_PROFILE - show dependent code
SynonymHZ_PARTIES
SynonymJTF_TASK_TEMP_GROUPS_B
SynonymJTF_TASK_TEMP_GROUPS_TL
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymQA_CHAR_VALUE_LOOKUPS
SynonymWIP_ACCOUNTING_CLASSES
APPS.AHL_ROUTES_V is referenced by following:

SchemaAPPS
Package BodyAHL_ENIGMA_ROUTE_OP_PUB - show dependent code
Package BodyAHL_RM_ROUTE_PVT - show dependent code