[Home] [Help]
373: select wrat.start_date as actual_date,
374: decode(wrat.action_flag,2,-wrat.duration,wrat.duration) as duration,
375: wrat.uom_code
376: from wip_resource_actual_times wrat,
377: wip_operations wo,
378: wip_entities we
379: where wrat.organization_id = org_id
380: and wrat.organization_id= wo.organization_id
381: and wrat.wip_entity_id = wo.wip_entity_id
400: select distinct wrat.wip_entity_id as wip_entity_id,
401: wrat.operation_seq_num as operation_seq_num,
402: get_index_for_date(wrat.start_date,wrat.organization_id,wo.department_id,res_id) as emp_index
403: from wip_resource_actual_times wrat,
404: wip_operations wo,
405: wip_entities we
406: where wrat.organization_id = org_id
407: and wrat.organization_id= wo.organization_id
408: and wrat.wip_entity_id = wo.wip_entity_id
416: and wrat.wip_entity_id is not null
417: and wrat.duration is not null
418: and wrat.start_date between start_time and end_time;
419:
420: /* cursor to get all records from wip_move_transactions, wip_operations for obtaining completed quantity */
421: /* Modified for Bug 7010115. */
422: -- Lot based jobs should not be considered for earned hours. So added condition on entity_type.
423: cursor eh_records(org_id number,
424: start_time date,
466: 0) as move_qty,
467: get_index_for_date(wmt.transaction_date,wmt.organization_id,wo.department_id,res_id) as emp_index
468: from
469: wip_move_transactions wmt,
470: wip_operations wo,
471: wip_entities we
472: where
473: wo.organization_id = org_id
474: and wo.organization_id = wmt.organization_id