[Home] [Help]
512: select distinct nvl(dept_res.share_from_dept_id, dept_res.department_id),
513: dept_res.resource_id,
514: NVL(dept_res.available_24_hours_flag, 2)
515: from bom_department_resources dept_res,
516: wip_operations wo,
517: wip_operation_resources wor
518: WHERE wo.wip_entity_id = p_wip_entity_id
519: AND wo.organization_id = p_organization_id
520: AND wor.wip_entity_id = wo.wip_entity_id
526: select distinct nvl(dept_res.share_from_dept_id, dept_res.department_id),
527: dept_res.resource_id,
528: NVL(dept_res.available_24_hours_flag, 2)
529: from bom_department_resources dept_res,
530: wip_operations wo,
531: wip_sub_operation_resources wsor
532: WHERE wo.wip_entity_id = p_wip_entity_id
533: AND wo.organization_id = p_organization_id
534: AND wsor.wip_entity_id = wo.wip_entity_id
664: dept_ins.instance_id,
665: dept_ins.serial_number
666: from bom_department_resources dept_res,
667: bom_dept_res_instances dept_ins,
668: wip_operations wo,
669: wip_operation_resources wor
670: WHERE wo.wip_entity_id = p_wip_entity_id
671: AND wo.organization_id = p_organization_id
672: AND wor.wip_entity_id = wo.wip_entity_id
683: ins_changes.instance_id,
684: ins_changes.serial_number
685: from bom_department_resources dept_res,
686: bom_res_instance_changes ins_changes,
687: wip_operations wo,
688: wip_operation_resources wor
689: WHERE wo.wip_entity_id = p_wip_entity_id
690: AND wo.organization_id = p_organization_id
691: AND wor.wip_entity_id = wo.wip_entity_id
709: dept_ins.instance_id,
710: dept_ins.serial_number
711: from bom_department_resources dept_res,
712: bom_dept_res_instances dept_ins,
713: wip_operations wo,
714: wip_sub_operation_resources wsor
715: WHERE wo.wip_entity_id = p_wip_entity_id
716: AND wo.organization_id = p_organization_id
717: AND wsor.wip_entity_id = wo.wip_entity_id
1604: end if;
1605:
1606: SELECT SUM(((WO.QUANTITY_COMPLETED+wo.QUANTITY_SCRAPPED)/wo.SCHEDULED_QUANTITY)*(wo.LAST_UNIT_COMPLETION_DATE - wo.FIRST_UNIT_START_DATE)),
1607: SUM(wo.LAST_UNIT_COMPLETION_DATE - wo.FIRST_UNIT_START_DATE) into completed, total
1608: from wip_operations wo,
1609: wip_discrete_jobs wdj
1610: where wdj.wip_entity_id = p_wip_entity_id
1611: and wo.wip_entity_id = wdj.wip_entity_id
1612: and wo.organization_id = wdj.organization_id;
1731: /* check if operation start/completion dates need to be updated also */
1732: /* here asume the first/last unit will be the same ??*/
1733: select wo.first_unit_start_date, wo.last_unit_completion_date
1734: into l_old_start_date, l_old_completion_date
1735: from wip_operations wo
1736: where wo.wip_entity_id = p_wip_entity_id
1737: and wo.operation_seq_num = p_operation_seq_num
1738: for update;
1739:
1751: else
1752: l_new_completion_date := p_new_completion_date;
1753: end if;
1754:
1755: update wip_operations wo
1756: set wo.first_unit_start_date = l_new_start_date,
1757: wo.last_unit_start_date = l_new_start_date,
1758: wo.first_unit_completion_date = l_new_completion_date,
1759: wo.last_unit_completion_date = l_new_completion_date,