Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AHL_PP_REQUIREMENT_V |
SELECT AOPR.OPERATION_RESOURCE_ID REQUIREMENT_ID
, AOPR.RESOURCE_ID RESOURCE_ID
, AOPR.OBJECT_VERSION_NUMBER
, BOMR.RESOURCE_CODE
, BOMR.DESCRIPTION RESOURCE_NAME
, AOPR.RESOURCE_SEQUENCE_NUM RESOURCE_SEQUENCE
, AWOS.WORKORDER_ID JOB_ID
, AWOP.WORKORDER_OPERATION_ID OPERATION_ID
, AWOP.OPERATION_SEQUENCE_NUM OPERATION_SEQUENCE
, AWOP.STATUS_CODE OPERATION_STATUS_CODE
, AWOP.SCHEDULED_START_DATE OPERATION_START_DATE
, AWOP.SCHEDULED_END_DATE OPERATION_END_DATE
, AOPR.SCHEDULED_START_DATE REQUIRED_START_DATE
, AOPR.SCHEDULED_END_DATE REQUIRED_END_DATE
, BOMR.RESOURCE_TYPE RESOURCE_TYPE_CODE
, MFGL.MEANING RESOURCE_TYPE_NAME
, AOPR.DURATION
, BOMR.UNIT_OF_MEASURE UOM_CODE
, UOM.UNIT_OF_MEASURE UOM_NAME
, AOPR.QUANTITY
, AOPR.DURATION *AOPR.QUANTITY TOTAL_REQUIRED
, AWOP.OPERATION_CODE
, AWOP.STATUS STATUS
, AWOS.VISIT_TASK_ID
, AWOS.JOB_STATUS_CODE
, AWOS.JOB_STATUS_MEANING
FROM AHL_WORKORDERS_V AWOS
, AHL_WORKORDER_OPERATIONS_V AWOP
, AHL_OPERATION_RESOURCES AOPR
, BOM_RESOURCES BOMR
, MFG_LOOKUPS MFGL
, MTL_UNITS_OF_MEASURE UOM
WHERE AWOP.WORKORDER_ID = AWOS.WORKORDER_ID
AND AWOP.WORKORDER_OPERATION_ID = AOPR.WORKORDER_OPERATION_ID
AND AOPR.RESOURCE_ID = BOMR.RESOURCE_ID
AND MFGL.LOOKUP_CODE(+) = BOMR.RESOURCE_TYPE
AND MFGL.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'
AND UOM.UOM_CODE(+) = BOMR.UNIT_OF_MEASURE