Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | View based on workorder resource transactions |
Implementation/DBA Data: | APPS.AHL_WIP_RESOURCE_TXNS_V |
SELECT DISTINCT(WIPT.TRANSACTION_ID)
, AWOS.WORKORDER_ID
, AWOS.JOB_NUMBER
, WIPT.WIP_ENTITY_ID
, WIPT.OPERATION_SEQ_NUM
, WIPT.RESOURCE_SEQ_NUM
, WIPT.EMPLOYEE_ID
, PEPF.EMPLOYEE_NUMBER
, PEPF.FULL_NAME
, BOMR.RESOURCE_CODE
, BOMR.DESCRIPTION
, WIPT.RESOURCE_ID
, WIPT.DEPARTMENT_ID
, BOMD.DESCRIPTION DEPT_DESCRIPTION
, WIPT.PRIMARY_QUANTITY QUANTITY
, WIPT.USAGE_RATE_OR_AMOUNT
, WIPT.PRIMARY_UOM
, MUOM.UNIT_OF_MEASURE_TL UOM_MEANING
, WIPT.ACTIVITY_ID
, CSAT.ACTIVITY
, WIPT.REASON_ID
, MTLR.REASON_NAME
, WIPT.REFERENCE
, WORI.INSTANCE_ID
, WORI.SERIAL_NUMBER
, WIPT.TRANSACTION_DATE
, AWOS.VISIT_TASK_ID
, AWOS.JOB_STATUS_CODE
, AWOS.JOB_STATUS_MEANING
FROM AHL_WORKORDERS_V AWOS
, WIP_TRANSACTIONS WIPT
, BOM_RESOURCES BOMR
, BOM_DEPARTMENTS BOMD
, PER_PEOPLE_F PEPF
, MTL_UNITS_OF_MEASURE MUOM
, MTL_TRANSACTION_REASONS MTLR
, CST_ACTIVITIES CSAT
, WIP_OP_RESOURCE_INSTANCES WORI
WHERE WIPT.WIP_ENTITY_ID = AWOS.WIP_ENTITY_ID
AND WIPT.RESOURCE_ID = BOMR.RESOURCE_ID
AND WIPT.DEPARTMENT_ID = BOMD.DEPARTMENT_ID
AND WIPT.PRIMARY_UOM = MUOM.UOM_CODE
AND WIPT.INSTANCE_ID = WORI.INSTANCE_ID
AND WIPT.WIP_ENTITY_ID = WORI.WIP_ENTITY_ID
AND WIPT.OPERATION_SEQ_NUM = WORI.OPERATION_SEQ_NUM
AND WIPT.RESOURCE_SEQ_NUM = WORI.RESOURCE_SEQ_NUM
AND WIPT.REASON_ID = MTLR.REASON_ID(+)
AND WIPT.ACTIVITY_ID = CSAT.ACTIVITY_ID(+)
AND WIPT.EMPLOYEE_ID = PEPF.PERSON_ID(+)