[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | AHL_ROUTES_B# |
|---|---|
| Object Type: | VIEW |
| Owner: | AHL |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROUTE_ID | NUMBER | Yes | ||
| OBJECT_VERSION_NUMBER | NUMBER | Yes | ||
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| CREATION_DATE | DATE | Yes | ||
| CREATED_BY | NUMBER | (15) | Yes | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| ROUTE_NO | VARCHAR2 | (30) | Yes | |
| REVISION_NUMBER | NUMBER | Yes | ||
| REVISION_STATUS_CODE | VARCHAR2 | (30) | Yes | |
| ACTIVE_START_DATE | DATE | |||
| ACTIVE_END_DATE | DATE | |||
| PRODUCT_TYPE_CODE | VARCHAR2 | (30) | ||
| ZONE_CODE | VARCHAR2 | (30) | ||
| ROUTE_CATEGORY_CODE | VARCHAR2 | (30) | ||
| ROUTE_TYPE_CODE | VARCHAR2 | (30) | ||
| WORK_CENTER_CODE | VARCHAR2 | (30) | ||
| SYSTEM_CODE1 | VARCHAR2 | (30) | ||
| SYSTEM_CODE2 | VARCHAR2 | (30) | ||
| SYSTEM_CODE3 | VARCHAR2 | (30) | ||
| PROCESS_CODE | VARCHAR2 | (30) | ||
| OPERATOR_CODE | VARCHAR2 | (30) | ||
| OPERATOR_PARTY_ID | NUMBER | |||
| RTPRIM_SKILL_TYPE_CODE | VARCHAR2 | (30) | ||
| SKILL_COMPETENCE_ID | NUMBER | (15) | ||
| TIME_SPAN | NUMBER | |||
| SECURITY_GROUP_ID | NUMBER | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
| ATTRIBUTE1 | VARCHAR2 | (150) | ||
| ATTRIBUTE2 | VARCHAR2 | (150) | ||
| ATTRIBUTE3 | VARCHAR2 | (150) | ||
| ATTRIBUTE4 | VARCHAR2 | (150) | ||
| ATTRIBUTE5 | VARCHAR2 | (150) | ||
| ATTRIBUTE6 | VARCHAR2 | (150) | ||
| ATTRIBUTE7 | VARCHAR2 | (150) | ||
| ATTRIBUTE8 | VARCHAR2 | (150) | ||
| ATTRIBUTE9 | VARCHAR2 | (150) | ||
| ATTRIBUTE10 | VARCHAR2 | (150) | ||
| ATTRIBUTE11 | VARCHAR2 | (150) | ||
| ATTRIBUTE12 | VARCHAR2 | (150) | ||
| ATTRIBUTE13 | VARCHAR2 | (150) | ||
| ATTRIBUTE14 | VARCHAR2 | (150) | ||
| ATTRIBUTE15 | VARCHAR2 | (150) | ||
| QA_PLAN_ID | NUMBER | |||
| SERVICE_ITEM_ID | NUMBER | |||
| SERVICE_ITEM_ORG_ID | NUMBER | |||
| TASK_TEMPLATE_GROUP_ID | NUMBER | |||
| ACCOUNTING_CLASS_CODE | VARCHAR2 | (10) | ||
| ACCOUNTING_CLASS_ORG_ID | NUMBER | |||
| SUB_ZONE_CODE | VARCHAR2 | (30) | ||
| SEGMENT1 | VARCHAR2 | (30) | ||
| SEGMENT2 | VARCHAR2 | (30) | ||
| SEGMENT3 | VARCHAR2 | (30) | ||
| SEGMENT4 | VARCHAR2 | (30) | ||
| SEGMENT5 | VARCHAR2 | (30) | ||
| SEGMENT6 | VARCHAR2 | (30) | ||
| SEGMENT7 | VARCHAR2 | (30) | ||
| SEGMENT8 | VARCHAR2 | (30) | ||
| SEGMENT9 | VARCHAR2 | (30) | ||
| SEGMENT10 | VARCHAR2 | (30) | ||
| SEGMENT11 | VARCHAR2 | (30) | ||
| SEGMENT12 | VARCHAR2 | (30) | ||
| SEGMENT13 | VARCHAR2 | (30) | ||
| SEGMENT14 | VARCHAR2 | (30) | ||
| SEGMENT15 | VARCHAR2 | (30) | ||
| SUMMARY_FLAG | VARCHAR2 | (1) | ||
| ENABLED_FLAG | VARCHAR2 | (1) | ||
| START_DATE_ACTIVE | DATE | |||
| END_DATE_ACTIVE | DATE | |||
| QA_INSPECTION_TYPE | VARCHAR2 | (150) | ||
| APPLICATION_USG_CODE | VARCHAR2 | (30) | ||
| UNIT_RECEIPT_UPDATE_FLAG | VARCHAR2 | (1) | ||
| MODEL_CODE | VARCHAR2 | (30) | ||
| ENIGMA_ROUTE_ID | VARCHAR2 | (80) | ||
| ENIGMA_DOC_ID | VARCHAR2 | (80) | ||
| FILE_ID | NUMBER | |||
| ENIGMA_PUBLISH_DATE | DATE | |||
| JOBCARDLYT_CODE | VARCHAR2 | (30) | ||
| ENIGMA_SOURCE_CODE | VARCHAR2 | (30) | ||
| WARRANTY_TEMPLATE_ID | NUMBER | |||
| DUPLICATE_FLAG | VARCHAR2 | (1) | ||
| RETURN_TO_SUPPLY_FLAG | VARCHAR2 | (1) |
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#;
AHL
AHL_ROUTES_B
APPS
AHL_ROUTES_B
|
|
|
|