[Home] [Help] [Dependency Information]
Object Name: | AHL_WORKORDERS_OSP_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AHL.AHL_WORKORDERS_OSP_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WORKORDER_ID | NUMBER | Yes | Internal identifier for a Workorder. | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Record version number. | |
JOB_NUMBER | VARCHAR2 | (80) | Yes | Workorder Name |
ORGANIZATION_ID | NUMBER | Identifier for Organization which it belongs to.. | ||
DEPARTMENT_ID | NUMBER | Owning Dept | ||
DEPARTMENT_CLASS_CODE | VARCHAR2 | (10) | The code of the department, which the workoder_id belongs to derived from BOM_WORKORDERS. | |
DEPARTMENT_CODE | VARCHAR2 | (10) | The meaning of the department, which the workoder_id belongs to derived from BOM_WORKORDERS. | |
JOB_STATUS_CODE | VARCHAR2 | (30) | Yes | The status code of the associated Job. |
SCHEDULED_START_DATE | DATE | Yes | Scheduled Start Date | |
SCHEDULED_END_DATE | DATE | Yes | Scheduled End Date | |
ACTUAL_START_DATE | DATE | Actual Start Date | ||
ACTUAL_END_DATE | DATE | Actual End Date | ||
INVENTORY_ITEM_ID | NUMBER | Yes | Inventory Item Id | |
ITEM_INSTANCE_ID | NUMBER | Item Instance Id | ||
ITEM_INSTANCE_NUMBER | VARCHAR2 | (30) | Yes | Item Instance Number |
QUANTITY | NUMBER | Yes | Quantity | |
WO_PART_NUMBER | VARCHAR2 | (40) | Wo Part Number | |
ITEM_DESCRIPTION | VARCHAR2 | (240) | Item Description | |
SERIAL_NUMBER | VARCHAR2 | (30) | Serial Number | |
LOT_NUMBER | VARCHAR2 | (80) | ||
ITEM_INSTANCE_UOM | VARCHAR2 | (3) | Yes | Unit Of Measure of the associated Item Instance. |
VISIT_ID | NUMBER | Yes | Visit Id | |
VISIT_NUMBER | NUMBER | (15) | Yes | |
VISIT_TASK_ID | NUMBER | Visit Task Id | ||
VISIT_TASK_NUMBER | NUMBER | (15) | Yes | |
ROUTE_ID | NUMBER | Route Id | ||
SERVICE_ITEM_ID | NUMBER | Service Item Id | ||
SERVICE_ITEM_ORG_ID | NUMBER | Service Item Org Id | ||
SERVICE_ITEM_DESCRIPTION | VARCHAR2 | (240) | Service Item Description | |
SERVICE_ITEM_NUMBER | VARCHAR2 | (40) | Service Item Number | |
SERVICE_ITEM_UOM | VARCHAR2 | (3) | Service Item Uom | |
PROJECT_ID | NUMBER | Project Id | ||
PROJECT_NAME | VARCHAR2 | (30) | Project Name | |
PROJECT_TASK_ID | NUMBER | Project Task Id | ||
PROJECT_TASK_NAME | VARCHAR2 | (20) | Project Task Name |
Cut, paste (and edit) the following text to query this object:
SELECT WORKORDER_ID
, OBJECT_VERSION_NUMBER
, JOB_NUMBER
, ORGANIZATION_ID
, DEPARTMENT_ID
, DEPARTMENT_CLASS_CODE
, DEPARTMENT_CODE
, JOB_STATUS_CODE
, SCHEDULED_START_DATE
, SCHEDULED_END_DATE
, ACTUAL_START_DATE
, ACTUAL_END_DATE
, INVENTORY_ITEM_ID
, ITEM_INSTANCE_ID
, ITEM_INSTANCE_NUMBER
, QUANTITY
, WO_PART_NUMBER
, ITEM_DESCRIPTION
, SERIAL_NUMBER
, LOT_NUMBER
, ITEM_INSTANCE_UOM
, VISIT_ID
, VISIT_NUMBER
, VISIT_TASK_ID
, VISIT_TASK_NUMBER
, ROUTE_ID
, SERVICE_ITEM_ID
, SERVICE_ITEM_ORG_ID
, SERVICE_ITEM_DESCRIPTION
, SERVICE_ITEM_NUMBER
, SERVICE_ITEM_UOM
, PROJECT_ID
, PROJECT_NAME
, PROJECT_TASK_ID
, PROJECT_TASK_NAME
FROM APPS.AHL_WORKORDERS_OSP_V;
|
|
|