[Home] [Help]
1737: if v_wljdi_job_op_seq_num(l_d) is not null then
1738: begin
1739: select 1
1740: into l_xst
1741: from wip_operations
1742: where wip_entity_id = p_wip_entity_id
1743: and organization_id = p_org_id
1744: and operation_seq_num = v_wljdi_job_op_seq_num(l_d);
1745: exception
2989: select first_unit_start_date,
2990: last_unit_start_date
2991: into l_op_start_date_old,
2992: l_op_compl_date_old
2993: from wip_operations
2994: where wip_entity_id = p_wip_entity_id
2995: and operation_seq_num = l_job_op_seq_num;
2996: EXCEPTION
2997: when others then
3238: select wo.first_unit_start_date,
3239: wo.last_unit_completion_date
3240: into l_op_sdate,
3241: l_op_edate
3242: from wip_operations wo
3243: where wo.wip_entity_id = p_wip_entity_id
3244: and wo.operation_seq_num = l_job_op_seq_num;
3245: else -- p_handle_wip_cur_op = 'N'
3246: l_stmt_num := 20;
3945: select wo.first_unit_start_date,
3946: wo.last_unit_completion_date
3947: into l_op_sdate,
3948: l_op_edate
3949: from wip_operations wo,
3950: bom_department_resources bdr
3951: where wo.wip_entity_id = p_wip_entity_id
3952: and wo.operation_seq_num = l_job_op_seq_num
3953: and wo.organization_id = p_org_id
4637: into l_res_sdate,
4638: l_res_edate,
4639: l_resource_id, -- this is used for validate instance_id
4640: l_department_id /*Added Department Id for bug 5476647*/
4641: from wip_operation_resources wor, wip_operations wo
4642: where wor.wip_entity_id = p_wip_entity_id
4643: and wor.organization_id = p_org_id
4644: and wor.operation_seq_num = l_job_op_seq_num
4645: and wor.resource_seq_num = l_res_seq_num
5500: select wo.first_unit_start_date,
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
5868: select wo.first_unit_start_date,
5869: wo.last_unit_completion_date
5870: into l_op_sdate,
5871: l_op_edate
5872: from wip_operations wo
5873: where wo.wip_entity_id = p_wip_entity_id
5874: and wo.operation_seq_num = l_job_op_seq_num;
5875: exception
5876: when no_data_found then
10389: begin
10390: l_stmt_num := 810;
10391: if(l_chg_alt_flag = 1 or l_chg_ref_flag = 1 or l_chg_rev_flag = 1) then
10392: -- Delete WO records
10393: delete from wip_operations
10394: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10395: delete from wip_operation_yields
10396: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
10397: delete from wip_operation_resources
10931: else
10932: l_qntydiff := 0;
10933: end if;
10934:
10935: update wip_operations
10936: set -- BD: BUG 3479666
10937: -- in option C, we should not change operation start/completion
10938: -- date based on job header level information
10939: --
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)
11024: and wip_entity_id = v_wlji_wip_entity_id(v_idx)
11025: and operation_seq_num = abs(wro.operation_seq_num)),
11026: last_updated_by = v_wlji_last_updt_by(v_idx),
11051: then
11052: l_stmt_num := 920.31;
11053: select min(operation_seq_num)
11054: into l_min_op_seq_num
11055: from wip_operations
11056: where wip_entity_id = v_wlji_wip_entity_id(v_idx);
11057: l_stmt_num := 920.32;
11058: select bd.scrap_account,
11059: bd.est_absorption_account,
11061: into l_scrap_account_10,
11062: l_est_scrap_abs_account_10,
11063: l_department_id
11064: from bom_departments bd,
11065: wip_operations wo
11066: where wo.wip_entity_id = v_wlji_wip_entity_id(v_idx)
11067: and wo.operation_seq_num = l_min_op_seq_num
11068: and bd.department_id = wo.department_id;
11069:
11485: set (current_job_op_seq_num,
11486: current_rtg_op_seq_num)
11487: =(select wo.operation_seq_num,
11488: wo.wsm_op_seq_num
11489: from wip_operations wo
11490: where organization_id = v_wlji_org_id(v_idx)
11491: and wip_entity_id = v_wlji_wip_entity_id(v_idx)
11492: and wo.quantity_in_queue
11493: + wo.quantity_running
13670: begin
13671:
13672: select nvl(p_new_res_tbl(l_index).dept_id,wo.department_id)
13673: into p_new_res_tbl(l_index).dept_id
13674: from bom_resources br,bom_department_resources bdr, wip_operations wo
13675: where br.resource_id = p_new_res_tbl(l_index).resource_id
13676: and br.resource_code = p_new_res_tbl(l_index).resource_code
13677: and (br.disable_date > sysdate or br.disable_date is null)
13678: and br.organization_id = p_org_id
13699: l_stmt_num := 170;
13700: begin
13701: select 1
13702: into l_dummy
13703: from wip_operations wo
13704: where wo.wip_entity_id = p_wip_entity_id
13705: and wo.organization_id = p_org_id
13706: and wo.operation_seq_num = p_job_op_seq_num
13707: and p_new_res_tbl(l_index).start_date >= wo.first_unit_start_date
15268: quantity_in_queue + quantity_running + quantity_waiting_to_move
15269: into l_cur_job_op_seq_num,
15270: l_cur_op_seq_id,
15271: l_cur_job_qty
15272: from wip_operations
15273: where wip_entity_id = p_wip_entity_id
15274: and (quantity_in_queue <> 0 or
15275: quantity_running <> 0 or
15276: quantity_waiting_to_move <> 0);
16886: raise e_wljdi_common_error;
16887: end if;
16888: l_stmt_num := 110.2;
16889: -- update WO for current operation
16890: UPDATE WIP_OPERATIONS
16891: set scheduled_quantity = NVL(l_op_qty, scheduled_quantity),
16892: first_unit_start_date = NVL(l_op_sdate, first_unit_start_date),
16893: first_unit_completion_date = NVL(l_op_edate, first_unit_completion_date),
16894: last_unit_start_date = NVL(l_op_sdate, last_unit_start_date),
17107: -- We'll store the data here quite simple..
17108: -- l_v_setup_op_res_num('Y-10-10') := 'Y';
17109: -- l_v_setup_op_res_num('(handle_curr_op)-(Op seq Num)-(resource seq num)') := 'Y';
17110: -- Indicates that setup resource has been added for the
17111: -- resource seq num 10, operation 10 in (WIP_OPERATIONS) --> handle curr op is Y'
17112: l_v_setup_op_res_num.delete;
17113: -- ST : Detailed Scheduling...
17114:
17115:
17869: -- ST : Detailed Scheduling ...
17870: -- If setup resources are added for a resource, keep track of it..
17871: IF l_job_op_seq_num IS NOT NULL THEN
17872:
17873: -- Added to WIP Operations...
17874: fnd_file.put_line(fnd_file.log,'Adding : ' || 'Y'||'-'||l_job_op_seq_num||'-'||l_temp_par_res_seq);
17875: l_v_setup_op_res_num('Y'||'-'||l_job_op_seq_num||'-'||l_temp_par_res_seq) := 'Y';
17876:
17877: ELSIF l_rtg_op_seq_num IS NOT NULL THEN
19553: wo.department_id,
19554: null,
19555: null,
19556: round(l_cur_job_qty*l_v_comp(l_in).qpa, 6)
19557: from wip_operations wo,
19558: mtl_system_items msi
19559: where wo.operation_seq_num = l_v_comp(l_in).job_op_seq_num
19560: and wo.wip_entity_id= p_wip_entity_id
19561: and msi.inventory_item_id = l_v_comp(l_in).item_id
20725: -- {{ Update quantity
20726: l_stmt_num := 80;
20727: select max(operation_seq_num)
20728: into l_max_op_seq_num
20729: from wip_operations
20730: where wip_entity_id = p_wip_entity_id;
20731:
20732: l_stmt_num := 90;
20733: update wip_operations wo
20729: from wip_operations
20730: where wip_entity_id = p_wip_entity_id;
20731:
20732: l_stmt_num := 90;
20733: update wip_operations wo
20734: set wo.previous_operation_seq_num = (
20735: select max(operation_seq_num)
20736: from wip_operations
20737: where wip_entity_id = p_wip_entity_id
20732: l_stmt_num := 90;
20733: update wip_operations wo
20734: set wo.previous_operation_seq_num = (
20735: select max(operation_seq_num)
20736: from wip_operations
20737: where wip_entity_id = p_wip_entity_id
20738: and operation_seq_num < wo.operation_seq_num),
20739: wo.next_operation_seq_num = (
20740: select min(operation_seq_num)
20737: where wip_entity_id = p_wip_entity_id
20738: and operation_seq_num < wo.operation_seq_num),
20739: wo.next_operation_seq_num = (
20740: select min(operation_seq_num)
20741: from wip_operations
20742: where wip_entity_id = p_wip_entity_id
20743: and operation_seq_num > wo.operation_seq_num),
20744: wo.quantity_in_queue =
20745: decode(operation_seq_num,
20756: end if;
20757:
20758: l_stmt_num := 100;
20759: /*This SQL is commneted as per bug 5125991
20760: update wip_operations
20761: set quantity_completed = p_start_quantity
20762: where wip_entity_id = p_wip_entity_id
20763: and operation_seq_num < l_max_op_seq_num;
20764: if lbji_debug = 'Y' then
20782: set (current_job_op_seq_num,
20783: current_rtg_op_seq_num)
20784: =(select wo.operation_seq_num,
20785: wo.wsm_op_seq_num
20786: from wip_operations wo
20787: where organization_id = p_org_id
20788: and wip_entity_id = p_wip_entity_id
20789: and wo.quantity_in_queue
20790: + wo.quantity_running
20808: set (current_job_op_seq_num,
20809: current_rtg_op_seq_num)
20810: =(select wo.operation_seq_num,
20811: wo.wsm_op_seq_num
20812: from wip_operations wo
20813: where organization_id = p_org_id
20814: and wip_entity_id = p_wip_entity_id
20815: and wo.quantity_in_queue
20816: + wo.quantity_running