[Home] [Help]
5501: wo.last_unit_completion_date
5502: into l_op_sdate,
5503: l_op_edate
5504: from wip_operations wo,
5505: wip_requirement_operations wro
5506: where wo.wip_entity_id = p_wip_entity_id
5507: and wo.operation_seq_num = l_job_op_seq_num
5508: and wro.wip_entity_id = wo.wip_entity_id
5509: and wro.operation_seq_num = wo.operation_seq_num
5709:
5710: begin
5711: select wro.quantity_issued
5712: into l_quantity_issued
5713: from wip_requirement_operations wro
5714: where wro.wip_entity_id = p_wip_entity_id
5715: and wro.operation_seq_num = l_job_op_seq_num
5716: and wro.inventory_item_id = l_item_old_id
5717: and wro.organization_id = p_org_id;
5734: into l_temp
5735: from dual
5736: where exists
5737: (select 1
5738: from wip_requirement_operations wro
5739: where wro.wip_entity_id = p_wip_entity_id
5740: and wro.organization_id =p_org_id
5741: and wro.operation_seq_num = l_job_op_seq_num
5742: and wro.inventory_item_id = l_item_old_id
5847: --check if component already defined for given job and operation.
5848: begin
5849: select 1
5850: into l_comp_duplicate
5851: from wip_requirement_operations wro
5852: where wro.wip_entity_id = p_wip_entity_id
5853: and wro.operation_seq_num =l_job_op_seq_num
5854: and wro.organization_id=p_org_id
5855: and wro.inventory_item_id=l_item_id;
10395: delete from wip_operation_yields
10396: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10397: delete from wip_operation_resources
10398: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10399: delete from wip_requirement_operations
10400: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10401: delete from wip_sub_operation_resources
10402: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10403: delete from wip_operation_resource_usage
10847: NULL;
10848:
10849: END;
10850:
10851: UPDATE wip_requirement_operations
10852: SET inventory_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id,
10853: required_quantity = ((required_quantity * l_sub_comp_bill_qpa)/quantity_per_assembly),
10854: quantity_per_assembly = l_sub_comp_bill_qpa,
10855: segment1 = l_segment1,
11015: end if;
11016: *******************/
11017: l_stmt_num := 920.2;
11018: --LBM enh : changed the expression for required quantity
11019: update wip_requirement_operations wro
11020: set wro.date_required = (
11021: select nvl(min(first_unit_start_date), v_wlji_fusd(v_idx))
11022: from wip_operations
11023: where organization_id = v_wlji_org_id(v_idx)
11717: 'Inserted '||SQL%ROWCOUNT||' rows into mtlt');
11718: end if;
11719:
11720: l_stmt_num := 1030;
11721: UPDATE WIP_REQUIREMENT_OPERATIONS
11722: set wip_supply_type = 1
11723: where wip_entity_id = v_wlji_wip_entity_id(v_idx)
11724: and operation_seq_num = 10
11725: and inventory_item_id = v_wsli(v_wlji_src_line_id(v_idx)).inventory_item_id;
19367: if p_error_code <> 0 then
19368: raise e_wljdi_common_error;
19369: end if;
19370:
19371: delete wip_requirement_operations
19372: where wip_entity_id = p_wip_entity_id
19373: and organization_id = p_org_id
19374: and operation_seq_num = l_job_op_seq_num
19375: and inventory_item_id = l_item_old_id;
19421: if p_error_code <> 0 then
19422: raise e_wljdi_common_error;
19423: end if;
19424:
19425: INSERT INTO WIP_REQUIREMENT_OPERATIONS
19426: (inventory_item_id,
19427: organization_id,
19428: wip_entity_id,
19429: operation_seq_num,
19775: raise e_wljdi_common_error;
19776: end if;
19777:
19778: l_stmt_num := 550.3;
19779: UPDATE WIP_REQUIREMENT_OPERATIONS
19780: set date_required = l_v_comp(l_in).date_required,
19781: last_update_date = p_last_updt_date,
19782: last_updated_by = p_last_updt_by,
19783: last_update_login = p_last_updt_login,
20271: or wpb.pl_overhead_out <> 0
20272: or wpb.pl_outside_processing_out <> 0
20273: or exists (
20274: select 'x'
20275: from wip_requirement_operations
20276: where organization_id = p_organization_id
20277: and wip_entity_id = p_wip_entity_id
20278: and quantity_issued <> 0)
20279: or exists (
20766: ||l_stmt_num||'): '|| SQL%ROWCOUNT);
20767: end if; */
20768:
20769: l_stmt_num := 110;
20770: update wip_requirement_operations
20771: set quantity_issued = required_quantity
20772: where wip_entity_id = p_wip_entity_id
20773: and operation_seq_num < l_max_op_seq_num
20774: and wip_supply_type not in (2, 4, 5, 6); -- Fix for bug #2685463