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_SEARCH_WORKORDERS_V

Object Details

Object Name:	AHL_SEARCH_WORKORDERS_V
Object Type:	VIEW
Owner:	APPS
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	Primary Key from AHL_WORKORDERS
WIP_ENTITY_ID	NUMBER			WipEntityID
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores locking sequence number
JOB_NUMBER	VARCHAR2	(80)	Yes	Job Number
JOB_DESCRIPTION	VARCHAR2	(240)		Job Description
TASK_QUANTITY	NUMBER			Task Quantity derived from visit task.
ORGANIZATION_ID	NUMBER			OrganizationID
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	Organization Name
DEPARTMENT_NAME	VARCHAR2	(240)		DEPARTMENT_NAME
DEPARTMENT_ID	NUMBER			DEPARTMENT ID
DEPARTMENT_CLASS_CODE	VARCHAR2	(10)		DEPARTMENT CLASS CODE
JOB_STATUS_CODE	VARCHAR2	(30)	Yes	JOB STATUS CODE
JOB_STATUS_MEANING	VARCHAR2	(80)		JOB_STATUS_MEANING
SCHEDULED_START_DATE	DATE		Yes	SCHEDULED_START_DATE
SCHEDULED_END_DATE	DATE		Yes	SCHEDULED_END_DATE
ITEM_INSTANCE_ID	NUMBER			ITEM_INSTANCE_ID
UNIT_NAME	VARCHAR2	(4000)		UNIT NAME
WO_PART_NUMBER	VARCHAR2	(40)		WO_PART_NUMBER
SERIAL_NUMBER	VARCHAR2	(30)		SERIAL_NUMBER
VISIT_ID	NUMBER		Yes	primary key from AHL_VISITS_B table.
VISIT_NUMBER	NUMBER	(15)	Yes	VISIT NUMBER
VISIT_STATUS_CODE	VARCHAR2	(30)		VISIT_STATUS_CODE
VISIT_TASK_NUMBER	NUMBER	(15)	Yes	VISIT_TASK_NUMBER
MR_TITLE	VARCHAR2	(80)		MR Title
ROUTE_ID	NUMBER			Route ID
PROJECT_NAME	VARCHAR2	(30)		PROJECT NAME
PROJECT_TASK_NAME	VARCHAR2	(20)		PROJECT_TASK_NAME
INCIDENT_ID	NUMBER			INCIDENT_ID
INCIDENT_NUMBER	VARCHAR2	(64)		INCIDENT_NUMBER
CLASS_CODE	VARCHAR2	(10)	Yes	CLASS_CODE
UNIT_EFFECTIVITY_ID	NUMBER			UNIT_EFFECTIVITY_ID
UE_OBJECT_VERSION_NUMBER	NUMBER			UE_OBJECT_VERSION_NUMBER
UE_PLAN_ID	NUMBER			UE_PLAN_ID
UE_COLLECTION_ID	NUMBER			UE_COLLECTION_ID
UE_STATUS_CODE	VARCHAR2	(4000)		UE_STATUS_CODE
PLAN_ID	NUMBER			PLAN_ID
COLLECTION_ID	NUMBER			COLLECTION_ID
PRIORITY	NUMBER			PRIORITY
PRIORITY_MEANING	VARCHAR2	(80)		PRIORITY MEANING
CONFIRM_FAILURE_FLAG	VARCHAR2	(1)		CONFIRM_FAILURE_FLAG
OSP_ORDER_ID	NUMBER			OSP_ORDER_ID
OSP_ORDER_NUMBER	NUMBER			OSP_ORDER_NUMBER
PO_INTERFACE_HEADER_ID	NUMBER			PO_INTERFACE_HEADER_ID
OE_HEADER_ID	NUMBER			OE_HEADER_ID
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
UNIT_LOCKED_FLAG	VARCHAR2	(4000)		Indicates if Unit is locked.
ACTUAL_START_DATE	DATE			Workorder Actual Start Date.
ACTUAL_END_DATE	DATE			Workorder Actual End Date.
VISIT_TASK_ID	NUMBER			Visit Task Identifier.
VISIT_NAME	VARCHAR2	(80)		Visit Name
WO_TYPE_CODE	VARCHAR2	(30)		Internal code for Work Order type.
WO_TYPE_MEANING	VARCHAR2	(80)		Work Order type.
ALL_OPS_COMPLETE	VARCHAR2	(4000)		Flag indicating all operations are complete
FILE_LOCATION	VARCHAR2	(4000)		Job card relative path and filename.
JOB_CARD_EXISTS	VARCHAR2	(4000)		Indicator if generated work card exists.
LATEST_JC_STATUS	VARCHAR2	(4000)		Status of the most recent (in progress) work card request.
JOB_CARD_ERROR_MSG	VARCHAR2	(4000)		Error message when work card generation fails.
SERVICE_TYPE_CODE	VARCHAR2	(30)		Service type code of the associated Visit task (maps to Oracle Projects lookup type 'SERVICE TYPE').
SERVICE_TYPE	VARCHAR2	(80)		Service Type

Query Text

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


SELECT WORKORDER_ID
,      WIP_ENTITY_ID
,      OBJECT_VERSION_NUMBER
,      JOB_NUMBER
,      JOB_DESCRIPTION
,      TASK_QUANTITY
,      ORGANIZATION_ID
,      ORGANIZATION_NAME
,      DEPARTMENT_NAME
,      DEPARTMENT_ID
,      DEPARTMENT_CLASS_CODE
,      JOB_STATUS_CODE
,      JOB_STATUS_MEANING
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      ITEM_INSTANCE_ID
,      UNIT_NAME
,      WO_PART_NUMBER
,      SERIAL_NUMBER
,      VISIT_ID
,      VISIT_NUMBER
,      VISIT_STATUS_CODE
,      VISIT_TASK_NUMBER
,      MR_TITLE
,      ROUTE_ID
,      PROJECT_NAME
,      PROJECT_TASK_NAME
,      INCIDENT_ID
,      INCIDENT_NUMBER
,      CLASS_CODE
,      UNIT_EFFECTIVITY_ID
,      UE_OBJECT_VERSION_NUMBER
,      UE_PLAN_ID
,      UE_COLLECTION_ID
,      UE_STATUS_CODE
,      PLAN_ID
,      COLLECTION_ID
,      PRIORITY
,      PRIORITY_MEANING
,      CONFIRM_FAILURE_FLAG
,      OSP_ORDER_ID
,      OSP_ORDER_NUMBER
,      PO_INTERFACE_HEADER_ID
,      OE_HEADER_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      UNIT_LOCKED_FLAG
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      VISIT_TASK_ID
,      VISIT_NAME
,      WO_TYPE_CODE
,      WO_TYPE_MEANING
,      ALL_OPS_COMPLETE
,      FILE_LOCATION
,      JOB_CARD_EXISTS
,      LATEST_JC_STATUS
,      JOB_CARD_ERROR_MSG
,      SERVICE_TYPE_CODE
,      SERVICE_TYPE
FROM APPS.AHL_SEARCH_WORKORDERS_V;