[Home] [Help]
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
521: AND wor.organization_id = wo.organization_id
543: from bom_std_op_resources bsor,
544: bom_standard_operations bso,
545: bom_department_resources bdr,
546: bom_setup_transitions bst,
547: wip_operation_resources wor
548: WHERE wor.organization_id = p_organization_id
549: AND wor.wip_entity_id = p_wip_entity_id
550: AND wor.setup_id is not null
551: AND bst.resource_id = wor.resource_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
673: AND wor.organization_id = wo.organization_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
692: AND wor.organization_id = wo.organization_id
728: dept_ins.instance_id,
729: dept_ins.serial_number
730: from bom_department_resources dept_res,
731: bom_dept_res_instances dept_ins,
732: wip_operation_resources wor,
733: bom_setup_transitions bst,
734: bom_standard_operations bso,
735: bom_std_op_resources bsor
736: where wor.wip_entity_id = p_wip_entity_id
1651:
1652: BEGIN
1653: select wor.start_date, wor.completion_date
1654: into l_old_start_date, l_old_completion_date
1655: from wip_operation_resources wor
1656: where wor.wip_entity_id = p_wip_entity_id
1657: and wor.operation_seq_num = p_operation_seq_num
1658: and wor.resource_seq_num = p_resource_seq_num
1659: for update;
1664: end if;
1665:
1666: select wor.schedule_seq_num
1667: into l_sched_seq_num
1668: from wip_operation_resources wor
1669: where wor.wip_entity_id = p_wip_entity_id
1670: and wor.operation_seq_num = p_operation_seq_num
1671: and wor.resource_seq_num = p_resource_seq_num;
1672:
1671: and wor.resource_seq_num = p_resource_seq_num;
1672:
1673: if( l_sched_seq_num is null) then
1674: -- update op resource
1675: update wip_operation_resources wor
1676: set wor.start_date = p_new_start_date,
1677: wor.completion_date = p_new_completion_date,
1678: wor.last_update_date = sysdate
1679: where wor.wip_entity_id = p_wip_entity_id
1695: else -- for simutaneous resources
1696: l_offset := p_new_start_date - l_old_start_date;
1697: -- yl_debug.dump('offset=' || l_offset || ' subgrpnum=' || l_sub_grp_num);
1698: -- update op resources
1699: update wip_operation_resources wor
1700: set wor.start_date = wor.start_date + l_offset,
1701: wor.completion_date = wor.completion_date + l_offset,
1702: wor.last_update_date = sysdate
1703: where wor.wip_entity_id = p_wip_entity_id
1707: delete wip_operation_resource_usage woru
1708: where woru.wip_entity_id = p_wip_entity_id
1709: and woru.operation_seq_num = p_operation_seq_num
1710: and woru.resource_seq_num in
1711: ( select wor.resource_seq_num from wip_operation_resources wor
1712: where wor.wip_entity_id = p_wip_entity_id
1713: and wor.operation_seq_num = p_operation_seq_num
1714: and wor.schedule_seq_num = l_sched_seq_num
1715: );
1719: wori.completion_date = wori.completion_date + l_offset,
1720: wori.last_update_date = sysdate
1721: where wori.wip_entity_id = p_wip_entity_id
1722: and wori.operation_seq_num in
1723: ( select wor.resource_seq_num from wip_operation_resources wor
1724: where wor.wip_entity_id = p_wip_entity_id
1725: and wor.operation_seq_num = p_operation_seq_num
1726: and wor.schedule_seq_num = l_sched_seq_num
1727: );