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_V

Object Details

Object Name:	AHL_WORKORDERS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_WORKORDERS_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	WORKORDER_ID
WIP_ENTITY_ID	NUMBER			WIP_ENTITY_ID
OBJECT_VERSION_NUMBER	NUMBER		Yes	Stores Locking Sequence Number
JOB_NUMBER	VARCHAR2	(80)	Yes	JobNumber
JOB_DESCRIPTION	VARCHAR2	(240)
ORGANIZATION_ID	NUMBER			OrgId
TASK_QUANTITY	NUMBER			Task Quantity derived from Visit task.
ORGANIZATION_NAME	VARCHAR2	(240)	Yes	ORGANIZATION_NAME
DEPARTMENT_NAME	VARCHAR2	(240)		DeptName
DEPARTMENT_ID	NUMBER			DeptId
DEPARTMENT_CLASS_CODE	VARCHAR2	(10)		Deparment Class Code
DEPARTMENT_CODE	VARCHAR2	(10)		DEPARTMENT_CODE
JOB_STATUS_CODE	VARCHAR2	(30)	Yes	JobStatusCode
JOB_STATUS_MEANING	VARCHAR2	(80)		JobStatusMeaning
SCHEDULED_START_DATE	DATE		Yes	ScheduleStartDate
SCHEDULED_START_HR	VARCHAR2	(2)		ScheduleStartHr
SCHEDULED_START_MI	VARCHAR2	(2)		ScheduleStartMin
SCHEDULED_END_DATE	DATE		Yes	ScheduleEndDate
SCHEDULED_END_HR	VARCHAR2	(2)		ScheduleEndHr
SCHEDULED_END_MI	VARCHAR2	(2)		ScheduleEndMin
ACTUAL_START_DATE	DATE			ActualStartDate
ACTUAL_START_HR	VARCHAR2	(2)		ActualStarttHr
ACTUAL_START_MI	VARCHAR2	(2)		ActualStartMin
ACTUAL_END_DATE	DATE			ActualEndDate
ACTUAL_END_HR	VARCHAR2	(2)		ActualEndHr
ACTUAL_END_MI	VARCHAR2	(2)		ActualEndMin
INVENTORY_ITEM_ID	NUMBER		Yes	InvItmeId
ITEM_INSTANCE_ID	NUMBER			ItemInstanceId
UNIT_NAME	VARCHAR2	(4000)		UnitName
ITEM_INSTANCE_NUMBER	VARCHAR2	(30)	Yes	ItemInstanceNumber
QUANTITY	NUMBER		Yes	quantity
WO_PART_NUMBER	VARCHAR2	(40)		Workorder Part Number
ITEM_DESCRIPTION	VARCHAR2	(240)		Workorder Item Description
SERIAL_NUMBER	VARCHAR2	(30)		SerialNumber
ITEM_INSTANCE_UOM	VARCHAR2	(3)	Yes	ItemInstanceUom
COMPLETION_SUBINVENTORY	VARCHAR2	(10)		CompletSubinventory
COMPLETION_LOCATOR_ID	NUMBER			CompleteLocatorId
COMPLETION_LOCATOR_NAME	CHAR	(1)		CompleteLocatorName
VISIT_ID	NUMBER		Yes	VisitId
VISIT_NUMBER	NUMBER	(15)	Yes	VisitNumber
VISIT_NAME	VARCHAR2	(80)		VisitName
VISIT_TASK_ID	NUMBER			visittaskId
VISIT_STATUS_CODE	VARCHAR2	(30)		VISIT_STATUS_CODE
MR_HEADER_ID	NUMBER			MrHeaderId
VISIT_TASK_NUMBER	NUMBER	(15)	Yes	VisitTaskNumber
MR_TITLE	VARCHAR2	(80)		MrTitle
MR_ROUTE_ID	NUMBER			MrRouteId
ROUTE_ID	NUMBER			RouteId
ROUTE_TITLE	VARCHAR2	(240)		Routetitle
ROUTE_NUMBER	VARCHAR2	(30)		RouteNumber
ROUTE_REVISION_NUMBER	NUMBER			RouteRevNum
SERVICE_ITEM_ID	NUMBER			ServiceItemId
SERVICE_ITEM_ORG_ID	NUMBER			ServiceItemOrgId
SERVICE_ITEM_DESCRIPTION	VARCHAR2	(240)		ServiceItemDes
SERVICE_ITEM_NUMBER	VARCHAR2	(40)		ServiceItemnum
SERVICE_ITEM_UOM	VARCHAR2	(3)		ServiceItemUom
PROJECT_ID	NUMBER			ProjectId
PROJECT_NAME	VARCHAR2	(30)		ProjectName
PROJECT_TASK_ID	NUMBER			ProjectTaskId
PROJECT_TASK_NAME	VARCHAR2	(20)		ProjectTaskName
INCIDENT_ID	NUMBER			IncidentId
INCIDENT_NUMBER	VARCHAR2	(64)		Incident Number
CLASS_CODE	VARCHAR2	(10)	Yes	ClassCode
UNIT_EFFECTIVITY_ID	NUMBER			UnitEffectivityId
UE_OBJECT_VERSION_NUMBER	NUMBER			Locking Sequence Number
UE_PLAN_ID	NUMBER			Unit Effectivity QA Plan Identifier
UE_COLLECTION_ID	NUMBER			Unit Effectivity QA Collection Identifier
UE_STATUS_CODE	VARCHAR2	(4000)		Unit Effectivity Status Code
PLAN_ID	NUMBER			Workorder QA Plan Identifier
COLLECTION_ID	NUMBER			Workorder QA Collection Identifier
PRIORITY	NUMBER			Priority
PRIORITY_MEANING	VARCHAR2	(80)		PriorityMeaning
CONFIRM_FAILURE_FLAG	VARCHAR2	(1)		ConfirmFailureFlag
LOT_NUMBER	VARCHAR2	(80)		LotNumber
OSP_ORDER_ID	NUMBER			OSP Order Identifier
OSP_ORDER_NUMBER	NUMBER			OSP Order Number
PO_INTERFACE_HEADER_ID	NUMBER			PO Interface Identifier
OE_HEADER_ID	NUMBER			Sales Order Identifier
FIRM_PLANNED_FLAG	NUMBER		Yes	Firm Planned Flag
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
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
UC_HEADER_ID	NUMBER			Unit Config Header Identifier
SERIAL_TAG_CODE	VARCHAR2	(4000)		Internal ID. Indicates if item instance serial number is temporary.
SERIAL_TAG_MEANING	VARCHAR2	(4000)		Indicates if item instance serial number is temporary.
ORIGINATING_WO_ID	NUMBER			Unique identifier for Originating Work Order.
ORIGINATING_WO_NAME	VARCHAR2	(80)		Name of the Originating Work Order.
UNIT_RECEIPT_UPDATE_FLAG	VARCHAR2	(1)		Unit Receipt Flag from the associated Route setup.
ALL_OPS_COMPLETE	VARCHAR2	(4000)		Flag indicating if all operations are complete for the workorder.
HOLD_REASON_CODE	VARCHAR2	(30)		Workorder Hold Reason Code
HOLD_REASON	VARCHAR2	(80)		Workorder Hold Reason
DATE_RELEASED	DATE			Date when Work Order was released.
DATE_COMPLETED	DATE			Date when work order was completed.
DATE_CLOSED	DATE			Date when work order was closed.
FILE_LOCATION	VARCHAR2	(4000)		Job card relative location(directory) 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 associated to the Visit task (maps to Oracle Projects lookup type 'Service Type').
SERVICE_TYPE	VARCHAR2	(80)		Service Type
TASK_WARRANTY_FLAG	VARCHAR2	(4000)		Task Warranty Flag
INSTANCE_WARRANTY_FLAG	VARCHAR2	(1)		Instance Warranty Flag
CONTRACT_NUMBER	NUMBER			Contract Number
WARRANTY_CLAIM_NUMBER	NUMBER			Warranty Claim Number
CLAIM_STATUS	VARCHAR2	(80)		Claim Status Meaning
ENTL_STATUS_CODE	VARCHAR2	(30)		Entitlement Status Code.
ENTL_STATUS	VARCHAR2	(80)		Entitlement Status
INSTANCE_ROUTING	VARCHAR2	(80)		Instance Routing for Workorder Instance
AOG_FLAG	VARCHAR2	(1)		AOG Flag
DEMAND_WORKORDER_ID	NUMBER			Demand Workorder Id
DEMAND_WORKORDER_NAME	VARCHAR2	(80)		Demand Workorder Name
AOG_FLAG_MEANING	VARCHAR2	(80)		AOG Flag Meaning

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
,      ORGANIZATION_ID
,      TASK_QUANTITY
,      ORGANIZATION_NAME
,      DEPARTMENT_NAME
,      DEPARTMENT_ID
,      DEPARTMENT_CLASS_CODE
,      DEPARTMENT_CODE
,      JOB_STATUS_CODE
,      JOB_STATUS_MEANING
,      SCHEDULED_START_DATE
,      SCHEDULED_START_HR
,      SCHEDULED_START_MI
,      SCHEDULED_END_DATE
,      SCHEDULED_END_HR
,      SCHEDULED_END_MI
,      ACTUAL_START_DATE
,      ACTUAL_START_HR
,      ACTUAL_START_MI
,      ACTUAL_END_DATE
,      ACTUAL_END_HR
,      ACTUAL_END_MI
,      INVENTORY_ITEM_ID
,      ITEM_INSTANCE_ID
,      UNIT_NAME
,      ITEM_INSTANCE_NUMBER
,      QUANTITY
,      WO_PART_NUMBER
,      ITEM_DESCRIPTION
,      SERIAL_NUMBER
,      ITEM_INSTANCE_UOM
,      COMPLETION_SUBINVENTORY
,      COMPLETION_LOCATOR_ID
,      COMPLETION_LOCATOR_NAME
,      VISIT_ID
,      VISIT_NUMBER
,      VISIT_NAME
,      VISIT_TASK_ID
,      VISIT_STATUS_CODE
,      MR_HEADER_ID
,      VISIT_TASK_NUMBER
,      MR_TITLE
,      MR_ROUTE_ID
,      ROUTE_ID
,      ROUTE_TITLE
,      ROUTE_NUMBER
,      ROUTE_REVISION_NUMBER
,      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
,      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
,      LOT_NUMBER
,      OSP_ORDER_ID
,      OSP_ORDER_NUMBER
,      PO_INTERFACE_HEADER_ID
,      OE_HEADER_ID
,      FIRM_PLANNED_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      UC_HEADER_ID
,      SERIAL_TAG_CODE
,      SERIAL_TAG_MEANING
,      ORIGINATING_WO_ID
,      ORIGINATING_WO_NAME
,      UNIT_RECEIPT_UPDATE_FLAG
,      ALL_OPS_COMPLETE
,      HOLD_REASON_CODE
,      HOLD_REASON
,      DATE_RELEASED
,      DATE_COMPLETED
,      DATE_CLOSED
,      FILE_LOCATION
,      JOB_CARD_EXISTS
,      LATEST_JC_STATUS
,      JOB_CARD_ERROR_MSG
,      SERVICE_TYPE_CODE
,      SERVICE_TYPE
,      TASK_WARRANTY_FLAG
,      INSTANCE_WARRANTY_FLAG
,      CONTRACT_NUMBER
,      WARRANTY_CLAIM_NUMBER
,      CLAIM_STATUS
,      ENTL_STATUS_CODE
,      ENTL_STATUS
,      INSTANCE_ROUTING
,      AOG_FLAG
,      DEMAND_WORKORDER_ID
,      DEMAND_WORKORDER_NAME
,      AOG_FLAG_MEANING
FROM APPS.AHL_WORKORDERS_V;

Dependencies

[top of page]

APPS.AHL_WORKORDERS_V references the following:

APPS: AHL_COMPLETIONS_PVT - show dependent code; AHL_MR_HEADERS_B; AHL_MR_ROUTES_APP_V; AHL_OSP_ORDERS_B; AHL_OSP_ORDER_LINES; AHL_PRD_PRINT_PVT - show dependent code; AHL_PRD_SERN_CHANGE_PVT - show dependent code; AHL_ROUTES_VL; AHL_UNIT_EFFECTIVITIES_B; AHL_UTILITY_PVT - show dependent code; AHL_UTIL_UC_PKG - show dependent code; AHL_VISITS_VL; AHL_VISIT_INST_ROUTINGS; AHL_VISIT_TASKS_VL; AHL_WARRANTY_CLAIMS_B; AHL_WARRANTY_CONTRACTS_B; AHL_WARRANTY_ENTITLEMENTS; AHL_WARRANTY_ENTL_PVT - show dependent code; AHL_WORKORDERS; BOM_DEPARTMENTS; CSI_ITEM_INSTANCES; CS_INCIDENTS_ALL_B; FND_GLOBAL - show dependent code; FND_LOOKUP_VALUES_VL; FND_PROFILE - show dependent code; HR_GENERAL - show dependent code; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; MFG_LOOKUPS; MO_GLOBAL - show dependent code; MTL_ITEM_LOCATIONS_KFV; MTL_RESERVATIONS; MTL_SYSTEM_ITEMS_KFV; ORG_ORGANIZATION_DEFINITIONS; PA_LOOKUPS; PA_PROJECTS_ALL; PA_TASKS; QA_PLANS_VAL_V; QA_PLAN_COLLECTION_TRIGGERS; QA_PLAN_TRANSACTIONS; QA_RESULTS; WIP_DISCRETE_JOBS

APPS.AHL_WORKORDERS_V is referenced by following:

APPS: AHL_PP_EMPLOYEE_ASSIGN_V; AHL_PP_RESRC_REQ_ASG_V; AHL_PRD_DISPOSITION_PVT - show dependent code; AHL_PRD_SERN_CHANGE_PVT - show dependent code; AHL_PRD_WORKORDER_PUB - show dependent code; AHL_PRD_WORKORDER_PVT - show dependent code; AHL_SCHEDULE_MATERIALS_V; AHL_VWP_MR_CST_PR_PVT - show dependent code; AHL_VWP_VISIT_CST_PR_PVT - show dependent code