[Home] [Help]
5507: wo.last_unit_completion_date
5508: into l_op_sdate,
5509: l_op_edate
5510: from wip_operations wo,
5511: wip_requirement_operations wro
5512: where wo.wip_entity_id = p_wip_entity_id
5513: and wo.operation_seq_num = l_job_op_seq_num
5514: and wro.wip_entity_id = wo.wip_entity_id
5515: and wro.operation_seq_num = wo.operation_seq_num
5715:
5716: begin
5717: select wro.quantity_issued
5718: into l_quantity_issued
5719: from wip_requirement_operations wro
5720: where wro.wip_entity_id = p_wip_entity_id
5721: and wro.operation_seq_num = l_job_op_seq_num
5722: and wro.inventory_item_id = l_item_old_id
5723: and wro.organization_id = p_org_id;
5740: into l_temp
5741: from dual
5742: where exists
5743: (select 1
5744: from wip_requirement_operations wro
5745: where wro.wip_entity_id = p_wip_entity_id
5746: and wro.organization_id =p_org_id
5747: and wro.operation_seq_num = l_job_op_seq_num
5748: and wro.inventory_item_id = l_item_old_id
5853: --check if component already defined for given job and operation.
5854: begin
5855: select 1
5856: into l_comp_duplicate
5857: from wip_requirement_operations wro
5858: where wro.wip_entity_id = p_wip_entity_id
5859: and wro.operation_seq_num =l_job_op_seq_num
5860: and wro.organization_id=p_org_id
5861: and wro.inventory_item_id=l_item_id;
10493: delete from wip_operation_yields
10494: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10495: delete from wip_operation_resources
10496: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10497: delete from wip_requirement_operations
10498: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10499: delete from wip_sub_operation_resources
10500: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10501: delete from wip_operation_resource_usage
10949: NULL;
10950:
10951: END;
10952:
10953: UPDATE wip_requirement_operations
10954: SET inventory_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id,
10955: required_quantity = ((required_quantity * l_sub_comp_bill_qpa)/quantity_per_assembly),
10956: quantity_per_assembly = l_sub_comp_bill_qpa,
10957: segment1 = l_segment1,
11117: end if;
11118: *******************/
11119: l_stmt_num := 920.2;
11120: --LBM enh : changed the expression for required quantity
11121: update wip_requirement_operations wro
11122: set wro.date_required = (
11123: select nvl(min(first_unit_start_date), v_wlji_fusd(v_idx))
11124: from wip_operations
11125: where organization_id = v_wlji_org_id(v_idx)
11821: 'Inserted '||SQL%ROWCOUNT||' rows into mtlt');
11822: end if;
11823:
11824: l_stmt_num := 1030;
11825: UPDATE WIP_REQUIREMENT_OPERATIONS
11826: set wip_supply_type = 1
11827: where wip_entity_id = v_wlji_wip_entity_id(v_idx)
11828: and operation_seq_num = 10
11829: and inventory_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id;
19959: if p_error_code <> 0 then
19960: raise e_wljdi_common_error;
19961: end if;
19962:
19963: delete wip_requirement_operations
19964: where wip_entity_id = p_wip_entity_id
19965: and organization_id = p_org_id
19966: and operation_seq_num = l_job_op_seq_num
19967: and inventory_item_id = l_item_old_id;
20013: if p_error_code <> 0 then
20014: raise e_wljdi_common_error;
20015: end if;
20016:
20017: INSERT INTO WIP_REQUIREMENT_OPERATIONS
20018: (inventory_item_id,
20019: organization_id,
20020: wip_entity_id,
20021: operation_seq_num,
20367: raise e_wljdi_common_error;
20368: end if;
20369:
20370: l_stmt_num := 550.3;
20371: UPDATE WIP_REQUIREMENT_OPERATIONS
20372: set date_required = l_v_comp(l_in).date_required,
20373: last_update_date = p_last_updt_date,
20374: last_updated_by = p_last_updt_by,
20375: last_update_login = p_last_updt_login,
20927: or wpb.pl_overhead_out <> 0
20928: or wpb.pl_outside_processing_out <> 0
20929: or exists (
20930: select 'x'
20931: from wip_requirement_operations
20932: where organization_id = p_organization_id
20933: and wip_entity_id = p_wip_entity_id
20934: and quantity_issued <> 0)
20935: or exists (
21431: ||l_stmt_num||'): '|| SQL%ROWCOUNT);
21432: end if; */
21433:
21434: l_stmt_num := 110;
21435: update wip_requirement_operations
21436: set quantity_issued = required_quantity
21437: where wip_entity_id = p_wip_entity_id
21438: and operation_seq_num < l_max_op_seq_num
21439: and wip_supply_type not in (2, 4, 5, 6); -- Fix for bug #2685463