eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.AHL_WORKORDERS_OSP_V

Object Details

Object Name:	AHL_WORKORDERS_OSP_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_WORKORDERS_OSP_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
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

Query Text

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;

Dependencies

[top of page]

APPS.AHL_WORKORDERS_OSP_V references the following:

APPS: AHL_ROUTES_B; AHL_VISITS_B; AHL_VISIT_TASKS_B; AHL_WORKORDERS; BOM_DEPARTMENTS; CSI_ITEM_INSTANCES; HR_GENERAL - show dependent code; HR_SECURITY - show dependent code; MO_GLOBAL - show dependent code; MTL_SYSTEM_ITEMS_KFV; ORG_ORGANIZATION_DEFINITIONS; PA_PROJECTS_ALL; PA_TASKS; WIP_DISCRETE_JOBS

APPS.AHL_WORKORDERS_OSP_V is referenced by following:

APPS: AHL_OSP_ORDER_LINES_V