DBA Data[Home] [Help]

APPS.WIP_WS_DL_UTIL dependencies on WIP_RESOURCE_ACTUAL_TIMES

Line 692: from wip_resource_actual_times wrat

688: /* use duration, so it works for machine also */
689: /* also it will reflect the charged resource usage */
690: select sum(wrat.duration)
691: into l_used_usage
692: from wip_resource_actual_times wrat
693: where wrat.wip_entity_id = p_wip_entity_id
694: and wrat.operation_seq_num = p_op_seq_num
695: and wrat.resource_seq_num = p_resource_seq_num
696: and wrat.duration is not null