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.

[Home] [Help]

View: AHL_PP_EMPLOYEE_ASSIGN_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:
Implementation/DBA Data:	APPS.AHL_PP_EMPLOYEE_ASSIGN_V

View Text

SELECT AWAS.ASSIGNMENT_ID
, AWAS.OBJECT_VERSION_NUMBER
, AWAS.EMPLOYEE_ID
, PEPF.EMPLOYEE_NUMBER
, PEPF.FULL_NAME EMPLOYEE_NAME
, AWOS.WORKORDER_ID JOB_ID
, AWOS.JOB_NUMBER JOB_NUMBER
, AWOS.JOB_DESCRIPTION JOB_DESCRIPTION
, AWOS.JOB_STATUS_CODE
, AWOS.JOB_STATUS_MEANING JOB_STATUS_NAME
, AWOP.WORKORDER_OPERATION_ID OPERATION_ID
, AWOP.OPERATION_SEQUENCE_NUM OPERATION_SEQUENCE
, AWOP.SCHEDULED_START_DATE OPERATION_START_DATE
, AWOP.SCHEDULED_END_DATE OPERATION_END_DATE
, ADS.SHIFT_NUM SHIFT_NUMBER
, AWAS.ASSIGN_START_DATE ASSIGNMENT_START_DATE
, AWAS.ASSIGN_END_DATE ASSIGNMENT_END_DATE
, AWOS.ORGANIZATION_ID ORGANIZATION_ID
, AWOS.ORGANIZATION_NAME
, AWOS.DEPARTMENT_ID DEPARTMENT_ID
, AWOS.DEPARTMENT_NAME
, AWOS.VISIT_NUMBER
, AWOS.PRIORITY JOB_PRIORITY_CODE
, AWOS.PRIORITY_MEANING JOB_PRIORITY_NAME
, NULL
, AWOS.OBJECT_VERSION_NUMBER JOB_OBJECT_VERSION_NUMBER
, AWOS.COLLECTION_ID WO_COLLECTION_ID
, AWOS.PLAN_ID WO_PLAN_ID
, AWOS.ITEM_INSTANCE_ID
, AWOP.OBJECT_VERSION_NUMBER OPER_OBJECT_VERSION_NUMBER
, AWOP.STATUS_CODE OPERATION_STATUS_CODE
, AWOP.STATUS OPERATION_STATUS_MEANING
, AWOP.OPERATION_CODE
, AWOS.WIP_ENTITY_ID
, AWOS.VISIT_STATUS_CODE
, AWOS.INCIDENT_ID SERVICE_REQUEST_ID
, AWOP.PLAN_ID OPER_PLAN_ID
, AWOP.COLLECTION_ID OPER_COLLECTION_ID
, AWOS.ROUTE_ID
, AWOS.UNIT_EFFECTIVITY_ID
, AWOS.UE_OBJECT_VERSION_NUMBER
, AWOS.UE_PLAN_ID
, AWOS.UE_COLLECTION_ID
, AWOS.UE_STATUS_CODE
FROM AHL_WORK_ASSIGNMENTS AWAS
, AHL_WORKORDERS_V AWOS
, AHL_WORKORDER_OPERATIONS_V AWOP
, AHL_OPERATION_RESOURCES AOPR
, AHL_DEPARTMENT_SHIFTS ADS
, PER_PEOPLE_F PEPF
, PER_PERSON_TYPES PEPT
WHERE AWAS.OPERATION_RESOURCE_ID = AOPR.OPERATION_RESOURCE_ID
AND AWOP.WORKORDER_OPERATION_ID = AOPR.WORKORDER_OPERATION_ID
AND AWOP.WORKORDER_ID = AWOS.WORKORDER_ID
AND AWOS.DEPARTMENT_ID = ADS.DEPARTMENT_ID (+)
AND AWAS.EMPLOYEE_ID = PEPF.PERSON_ID
AND PEPT.PERSON_TYPE_ID = PEPF.PERSON_TYPE_ID
AND SYSTEM_PERSON_TYPE ='EMP'

Columns

Name
ASSIGNMENT_ID
OBJECT_VERSION_NUMBER
EMPLOYEE_ID
EMPLOYEE_NUMBER
EMPLOYEE_NAME
JOB_ID
JOB_NUMBER
JOB_DESCRIPTION
JOB_STATUS_CODE
JOB_STATUS_NAME
OPERATION_ID
OPERATION_SEQUENCE
OPERATION_START_DATE
OPERATION_END_DATE
SHIFT_NUMBER
ASSIGNMENT_START_DATE
ASSIGNMENT_END_DATE
ORGANIZATION_ID
ORGANIZATION_NAME
DEPARTMENT_ID
DEPARTMENT_NAME
VISIT_NUMBER
JOB_PRIORITY_CODE
JOB_PRIORITY_NAME
SHARED_FLAG
JOB_OBJECT_VERSION_NUMBER
WO_COLLECTION_ID
WO_PLAN_ID
ITEM_INSTANCE_ID
OPER_OBJECT_VERSION_NUMBER
OPERATION_STATUS_CODE
OPERATION_STATUS_MEANING
OPERATION_CODE
WIP_ENTITY_ID
VISIT_STATUS_CODE
SERVICE_REQUEST_ID
OPER_PLAN_ID
OPER_COLLECTION_ID
ROUTE_ID
UNIT_EFFECTIVITY_ID
UE_OBJECT_VERSION_NUMBER
UE_PLAN_ID
UE_COLLECTION_ID
UE_STATUS_CODE