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_ASSIGNMENT_V

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

View Text

SELECT AWAS.ASSIGNMENT_ID
, AWAS.OBJECT_VERSION_NUMBER
, AWAS.EMPLOYEE_ID
, PEPF.EMPLOYEE_NUMBER
, PEPF.FULL_NAME EMPLOYEE_NAME
, APRV.JOB_ID JOB_ID
, APRV.OPERATION_ID OPERATION_ID
, APRV.OPERATION_SEQUENCE OPERATION_SEQUENCE
, APRV.OPERATION_STATUS_CODE OPERATION_STATUS_CODE
, APRV.STATUS OPERATION_STATUS_MEAN
, APRV.OPERATION_START_DATE OPERATION_START_DATE
, APRV.OPERATION_END_DATE OPERATION_END_DATE
, AWAS.ASSIGN_START_DATE ASSIGNMENT_START_DATE
, AWAS.ASSIGN_END_DATE ASSIGNMENT_END_DATE
, AWAS.INSTANCE_ID INSTANCE_ID
, AWAS.SERIAL_NUMBER SERIAL_NUMBER
, APRV.RESOURCE_TYPE_CODE RESOURCE_TYPE_CODE
, APRV.RESOURCE_TYPE_NAME RESOURCE_TYPE_NAME
, APRV.RESOURCE_ID RESOURCE_ID
, APRV.REQUIREMENT_ID OPERATION_RESOURCE_ID
, APRV.RESOURCE_CODE RESOURCE_CODE
, APRV.RESOURCE_NAME RESOURCE_NAME
, APRV.RESOURCE_SEQUENCE RESOURCE_SEQUENCE
FROM AHL_WORK_ASSIGNMENTS AWAS
, AHL_PP_REQUIREMENT_V APRV
, PER_PEOPLE_F PEPF
, PER_PERSON_TYPES PEPT
WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
AND AWAS.EMPLOYEE_ID = PEPF.PERSON_ID
AND PEPT.PERSON_TYPE_ID = PEPF.PERSON_TYPE_ID
AND PEPT.SYSTEM_PERSON_TYPE = 'EMP' UNION SELECT AWAS.ASSIGNMENT_ID
, AWAS.OBJECT_VERSION_NUMBER
, AWAS.EMPLOYEE_ID
, NULL
, NULL
, APRV.JOB_ID JOB_ID
, APRV.OPERATION_ID OPERATION_ID
, APRV.OPERATION_SEQUENCE OPERATION_SEQUENCE
, APRV.OPERATION_STATUS_CODE OPERATION_STATUS_CODE
, APRV.STATUS OPERATION_STATUS_MEAN
, APRV.OPERATION_START_DATE OPERATION_START_DATE
, APRV.OPERATION_END_DATE OPERATION_END_DATE
, AWAS.ASSIGN_START_DATE ASSIGNMENT_START_DATE
, AWAS.ASSIGN_END_DATE ASSIGNMENT_END_DATE
, AWAS.INSTANCE_ID INSTANCE_ID
, AWAS.SERIAL_NUMBER SERIAL_NUMBER
, APRV.RESOURCE_TYPE_CODE RESOURCE_TYPE_CODE
, APRV.RESOURCE_TYPE_NAME RESOURCE_TYPE_NAME
, APRV.RESOURCE_ID RESOURCE_ID
, APRV.REQUIREMENT_ID OPERATION_RESOURCE_ID
, APRV.RESOURCE_CODE RESOURCE_CODE
, APRV.RESOURCE_NAME RESOURCE_NAME
, APRV.RESOURCE_SEQUENCE RESOURCE_SEQUENCE
FROM AHL_WORK_ASSIGNMENTS AWAS
, AHL_PP_REQUIREMENT_V APRV
WHERE AWAS.OPERATION_RESOURCE_ID = APRV.REQUIREMENT_ID
AND AWAS.SERIAL_NUMBER IS NOT NULL

Columns

Name
ASSIGNMENT_ID
OBJECT_VERSION_NUMBER
EMPLOYEE_ID
EMPLOYEE_NUMBER
EMPLOYEE_NAME
JOB_ID
OPERATION_ID
OPERATION_SEQUENCE
OPERATION_STATUS_CODE
OPERATION_STATUS_MEAN
OPERATION_START_DATE
OPERATION_END_DATE
ASSIGNMENT_START_DATE
ASSIGNMENT_END_DATE
INSTANCE_ID
SERIAL_NUMBER
RESOURCE_TYPE_CODE
RESOURCE_TYPE_NAME
RESOURCE_ID
REQUIREMENT_ID
RESOURCE_CODE
RESOURCE_NAME
RESOURCE_SEQUENCE