VIEW: APPS.WMS_WAVEPLAN_TIME_PER_TASK_V

Source

View Text - Preformatted

SELECT DISTINCT bsor.standard_operation_id user_task_type_id, bsor.usage_rate_or_amount, muom.uom_code, muom.unit_of_measure_tl, bso.operation_code, bso.operation_description FROM bom_std_op_resources bsor, ( SELECT a.standard_operation_id, MAX ( a.ROWID ) row_id FROM bom_std_op_resources a WHERE exists ( select 1 from bom_resources b where b.resource_id = a.resource_id and b.resource_type = 2 ) GROUP BY a.standard_operation_id ) bsor1, wms_waveplan_tasks_temp wwtt, bom_resources br, bom_standard_operations bso, mtl_units_of_measure_tl muom WHERE bsor1.row_id = bsor.ROWID AND br.resource_id = bsor.resource_id AND wwtt.result in ( 'X', 'Y', 'Z') AND muom.uom_code = br.unit_of_measure AND muom.language = userenv ( 'LANG') AND bso.standard_operation_id = wwtt.user_task_type_id AND bsor.standard_operation_id = wwtt.user_task_type_id AND bsor1.standard_operation_id = wwtt.user_task_type_id 

View Text - HTML Formatted

SELECT DISTINCT BSOR.STANDARD_OPERATION_ID USER_TASK_TYPE_ID
, BSOR.USAGE_RATE_OR_AMOUNT
, MUOM.UOM_CODE
, MUOM.UNIT_OF_MEASURE_TL
, BSO.OPERATION_CODE
, BSO.OPERATION_DESCRIPTION
FROM BOM_STD_OP_RESOURCES BSOR
, ( SELECT A.STANDARD_OPERATION_ID
, MAX ( A.ROWID ) ROW_ID
FROM BOM_STD_OP_RESOURCES A
WHERE EXISTS ( SELECT 1
FROM BOM_RESOURCES B
WHERE B.RESOURCE_ID = A.RESOURCE_ID
AND B.RESOURCE_TYPE = 2 ) GROUP BY A.STANDARD_OPERATION_ID ) BSOR1
, WMS_WAVEPLAN_TASKS_TEMP WWTT
, BOM_RESOURCES BR
, BOM_STANDARD_OPERATIONS BSO
, MTL_UNITS_OF_MEASURE_TL MUOM
WHERE BSOR1.ROW_ID = BSOR.ROWID
AND BR.RESOURCE_ID = BSOR.RESOURCE_ID
AND WWTT.RESULT IN ( 'X'
, 'Y'
, 'Z')
AND MUOM.UOM_CODE = BR.UNIT_OF_MEASURE
AND MUOM.LANGUAGE = USERENV ( 'LANG')
AND BSO.STANDARD_OPERATION_ID = WWTT.USER_TASK_TYPE_ID
AND BSOR.STANDARD_OPERATION_ID = WWTT.USER_TASK_TYPE_ID
AND BSOR1.STANDARD_OPERATION_ID = WWTT.USER_TASK_TYPE_ID