DBA Data[Home] [Help]

APPS.WIP_OPERATIONS_GRP dependencies on MTL_UNITS_OF_MEASURE

Line 36: FROM mtl_units_of_measure

32: NULL ))
33: FROM wip_operation_resources_v wor
34: WHERE wor.wip_entity_id = p_wip_entity_id
35: AND wor.UOM_CODE in (SELECT UOM_CODE
36: FROM mtl_units_of_measure
37: WHERE UOM_CLASS = l_uomclass)
38: GROUP BY wor.operation_seq_num ;
39:
40: /* Cursor to get the progress percentage for an operation seq number */

Line 82: FROM mtl_units_of_measure

78: INTO l_scheduled_hours
79: FROM wip_operation_resources_v wor
80: WHERE wor.wip_entity_id = p_wip_entity_id
81: AND wor.UOM_CODE in (SELECT UOM_CODE
82: FROM mtl_units_of_measure
83: WHERE UOM_CLASS = l_uomclass);
84:
85: x_percentage_complete := l_total_complete / l_scheduled_hours;
86: