[Home] [Help] [Dependency Information]

VIEW: APPS.AHL_ALL_WORKORDERS_V

Object Details

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

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
,      MASTER_WORKORDER_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
,      HOLD_REASON_CODE
,      HOLD_REASON
,      AOG_FLAG
FROM APPS.AHL_ALL_WORKORDERS_V;

Dependencies

[top of page]

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_ROUTES_VL

AHL_UNIT_EFFECTIVITIES_B

AHL_UTILITY_PVT - show dependent code

AHL_VISITS_VL

AHL_VISIT_TASKS_B

AHL_VISIT_TASKS_VL

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_SYSTEM_ITEMS_KFV

ORG_ORGANIZATION_DEFINITIONS

PA_PROJECTS_ALL

PA_TASKS

QA_PLANS_VAL_V

QA_PLAN_COLLECTION_TRIGGERS

QA_PLAN_TRANSACTIONS

QA_RESULTS

WIP_DISCRETE_JOBS

APPS

AHL_PRD_WORKORDER_PVT - show dependent code