DBA Data[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: ViewAHL.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
Name Datatype Length Mandatory Comments
WORKORDER_ID NUMBER

WIP_ENTITY_ID NUMBER

OBJECT_VERSION_NUMBER NUMBER

JOB_NUMBER VARCHAR2 (80)
JOB_DESCRIPTION VARCHAR2 (240)
ORGANIZATION_ID NUMBER

TASK_QUANTITY NUMBER

Task Quantity dervied from visit task.
ORGANIZATION_NAME VARCHAR2 (240)
DEPARTMENT_NAME VARCHAR2 (240)
DEPARTMENT_ID NUMBER

DEPARTMENT_CLASS_CODE VARCHAR2 (10)
DEPARTMENT_CODE VARCHAR2 (10)
JOB_STATUS_CODE VARCHAR2 (30)
JOB_STATUS_MEANING VARCHAR2 (80)
SCHEDULED_START_DATE DATE

SCHEDULED_START_HR VARCHAR2 (2)
SCHEDULED_START_MI VARCHAR2 (2)
SCHEDULED_END_DATE DATE

SCHEDULED_END_HR VARCHAR2 (2)
SCHEDULED_END_MI VARCHAR2 (2)
ACTUAL_START_DATE DATE

ACTUAL_START_HR VARCHAR2 (2)
ACTUAL_START_MI VARCHAR2 (2)
ACTUAL_END_DATE DATE

ACTUAL_END_HR VARCHAR2 (2)
ACTUAL_END_MI VARCHAR2 (2)
INVENTORY_ITEM_ID NUMBER

ITEM_INSTANCE_ID NUMBER

UNIT_NAME VARCHAR2 (4000)
ITEM_INSTANCE_NUMBER VARCHAR2 (30)
QUANTITY NUMBER

WO_PART_NUMBER VARCHAR2 (40)
ITEM_DESCRIPTION VARCHAR2 (240)
SERIAL_NUMBER VARCHAR2 (30)
ITEM_INSTANCE_UOM VARCHAR2 (3)
COMPLETION_SUBINVENTORY VARCHAR2 (10)
COMPLETION_LOCATOR_ID NUMBER

COMPLETION_LOCATOR_NAME VARCHAR2 (1)
VISIT_ID NUMBER

VISIT_NUMBER NUMBER (15)
VISIT_NAME VARCHAR2 (80)
VISIT_TASK_ID NUMBER

VISIT_STATUS_CODE VARCHAR2 (30)
MR_HEADER_ID NUMBER

VISIT_TASK_NUMBER NUMBER

MR_TITLE VARCHAR2 (80)
MR_ROUTE_ID NUMBER

ROUTE_ID NUMBER

ROUTE_TITLE VARCHAR2 (240)
ROUTE_NUMBER VARCHAR2 (30)
ROUTE_REVISION_NUMBER NUMBER

SERVICE_ITEM_ID NUMBER

SERVICE_ITEM_ORG_ID NUMBER

SERVICE_ITEM_DESCRIPTION VARCHAR2 (240)
SERVICE_ITEM_NUMBER VARCHAR2 (40)
SERVICE_ITEM_UOM VARCHAR2 (3)
PROJECT_ID NUMBER

PROJECT_NAME VARCHAR2 (30)
PROJECT_TASK_ID NUMBER

PROJECT_TASK_NAME VARCHAR2 (20)
INCIDENT_ID NUMBER

INCIDENT_NUMBER VARCHAR2 (64)
CLASS_CODE VARCHAR2 (10)
UNIT_EFFECTIVITY_ID NUMBER

UE_OBJECT_VERSION_NUMBER NUMBER

UE_PLAN_ID NUMBER

UE_COLLECTION_ID NUMBER

UE_STATUS_CODE VARCHAR2 (4000)
PLAN_ID NUMBER

COLLECTION_ID NUMBER

PRIORITY NUMBER

PRIORITY_MEANING VARCHAR2 (80)
CONFIRM_FAILURE_FLAG VARCHAR2 (1)
LOT_NUMBER VARCHAR2 (80)
OSP_ORDER_ID NUMBER

OSP_ORDER_NUMBER NUMBER

PO_INTERFACE_HEADER_ID NUMBER

OE_HEADER_ID NUMBER

FIRM_PLANNED_FLAG NUMBER

MASTER_WORKORDER_FLAG VARCHAR2 (1)
ATTRIBUTE_CATEGORY VARCHAR2 (30)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
HOLD_REASON_CODE VARCHAR2 (30)
Hold reason code
HOLD_REASON VARCHAR2 (80)
Hold Reason
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
FROM APPS.AHL_ALL_WORKORDERS_V;

Dependencies

[top of page]

APPS.AHL_ALL_WORKORDERS_V references the following:

SchemaAPPS
PL/SQL PackageAHL_COMPLETIONS_PVT - show dependent code
SynonymAHL_MR_HEADERS_B
ViewAHL_MR_ROUTES_APP_V
SynonymAHL_OSP_ORDERS_B
SynonymAHL_OSP_ORDER_LINES
ViewAHL_ROUTES_VL
SynonymAHL_UNIT_EFFECTIVITIES_B
PL/SQL PackageAHL_UTILITY_PVT - show dependent code
ViewAHL_VISITS_VL
SynonymAHL_VISIT_TASKS_B
ViewAHL_VISIT_TASKS_VL
SynonymAHL_WORKORDERS
SynonymBOM_DEPARTMENTS
SynonymCSI_ITEM_INSTANCES
SynonymCS_INCIDENTS_ALL_B
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUP_VALUES_VL
PL/SQL PackageFND_PROFILE - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
ViewHR_ORGANIZATION_UNITS
PL/SQL PackageHR_SECURITY - show dependent code
ViewMFG_LOOKUPS
PL/SQL PackageMO_GLOBAL - show dependent code
ViewMTL_ITEM_LOCATIONS_KFV
SynonymMTL_SYSTEM_ITEMS_KFV
ViewORG_ORGANIZATION_DEFINITIONS
SynonymPA_PROJECTS_ALL
SynonymPA_TASKS
ViewQA_PLANS_VAL_V
SynonymQA_PLAN_COLLECTION_TRIGGERS
SynonymQA_PLAN_TRANSACTIONS
SynonymQA_RESULTS
SynonymWIP_DISCRETE_JOBS
APPS.AHL_ALL_WORKORDERS_V is referenced by following:

SchemaAPPS
Package BodyAHL_PRD_WORKORDER_PVT - show dependent code