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: ViewAHL.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)
wo_part_number
ITEM_DESCRIPTION VARCHAR2 (240)
ItemDesc
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)
CLASS_CODE VARCHAR2 (10) Yes ClassCode
UNIT_EFFECTIVITY_ID NUMBER

UnitEffectivityId
UE_OBJECT_VERSION_NUMBER NUMBER

UE_PLAN_ID NUMBER

UE_COLLECTION_ID NUMBER

UE_STATUS_CODE VARCHAR2 (4000)
PLAN_ID NUMBER

PlanId
COLLECTION_ID NUMBER

CollectionId
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_NUMBER NUMBER

PO_INTERFACE_HEADER_ID NUMBER

OE_HEADER_ID NUMBER

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

FK to AHL_UNIT_CONFIG_HEADERS
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)
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
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
FROM APPS.AHL_WORKORDERS_V;

Dependencies

[top of page]

APPS.AHL_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
PL/SQL PackageAHL_PRD_SERN_CHANGE_PVT - show dependent code
ViewAHL_ROUTES_VL
SynonymAHL_UNIT_EFFECTIVITIES_B
PL/SQL PackageAHL_UTILITY_PVT - show dependent code
PL/SQL PackageAHL_UTIL_UC_PKG - show dependent code
ViewAHL_VISITS_VL
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_WORKORDERS_V is referenced by following:

SchemaAPPS
ViewAHL_PP_EMPLOYEE_ASSIGN_V
ViewAHL_PP_RESRC_REQ_ASG_V
Package BodyAHL_PRD_SERN_CHANGE_PVT - show dependent code
ViewAHL_SCHEDULE_MATERIALS_V
ViewAHL_SRH_MR_HISTORY_V
Package BodyAHL_VWP_MR_CST_PR_PVT - show dependent code
Package BodyAHL_VWP_VISIT_CST_PR_PVT - show dependent code