[Home] [Help]
256: begin
257:
258: select sum( wo1.quantity_in_queue + wo1.quantity_running + wo1.quantity_waiting_to_move + wo1.quantity_rejected)
259: into l_qty
260: from wip_operations wo1
261: where wo1.wip_entity_id = p_wip_entity_id and
262: ( wo1.operation_seq_num =
263: ( select wo2.previous_operation_seq_num
264: from wip_operations wo2
260: from wip_operations wo1
261: where wo1.wip_entity_id = p_wip_entity_id and
262: ( wo1.operation_seq_num =
263: ( select wo2.previous_operation_seq_num
264: from wip_operations wo2
265: where wo2.wip_entity_id = p_wip_entity_id and
266: wo2.operation_seq_num = p_op_seq
267: )
268: or
267: )
268: or
269: wo1.operation_seq_num =
270: ( select max( wo3.operation_seq_num )
271: from wip_operations wo3
272: where wo3.wip_entity_id = p_wip_entity_id and
273: wo3.operation_seq_num < p_op_seq and
274: wo3.count_point_type = 1
275: )
630: begin
631:
632: select wo.scheduled_quantity, wo.quantity_completed, nvl(wo.cumulative_scrap_quantity, 0)
633: into l_op_qty, l_qty_completed, l_cumulative_scrap_qty
634: from wip_operations wo
635: where wo.organization_id = p_org_id and
636: wo.wip_entity_id = p_wip_entity_id and
637: wo.operation_seq_num = p_op_seq;
638:
730: decode(mp.include_resource_efficiency, 1, nvl(bdr.efficiency, 1), 1) efficiency,
731: wor.actual_start_date,
732: wor.assigned_units
733: from wip_discrete_jobs wdj,
734: wip_operations wo,
735: wip_operation_resources wor,
736: bom_resources br,
737: bom_department_resources bdr,
738: wip_parameters mp
839: l_qty number;
840: Begin
841: select wo.quantity_in_queue + wo.quantity_running
842: into l_qty
843: from wip_operations wo
844: where wo.wip_entity_id = p_wip_entity_id and wo.operation_seq_num = p_op_seq_num;
845:
846: return l_qty;
847: End get_jobop_queue_run_qty;
1427: end if;
1428:
1429: add_string(l_tmp, ' and ', '( ');
1430: add_string(l_tmp, ' 0 < (select (wo1.quantity_in_queue + wo1.quantity_running + wo1.quantity_waiting_to_move + wo1.quantity_rejected) ');
1431: add_string(l_tmp, ' from wip_operations wo1 where wo1.operation_seq_num = ');
1432: add_string(l_tmp, ' ( select max(wo2.operation_seq_num) from wip_operations wo2 ');
1433: add_string(l_tmp, ' where wo2.count_point_type = 1 and ');
1434: add_string(l_tmp, ' wo2.operation_seq_num < qrslt.operation_seq_num and ');
1435: add_string(l_tmp, ' wo2.wip_entity_id = wo1.wip_entity_id and ');
1428:
1429: add_string(l_tmp, ' and ', '( ');
1430: add_string(l_tmp, ' 0 < (select (wo1.quantity_in_queue + wo1.quantity_running + wo1.quantity_waiting_to_move + wo1.quantity_rejected) ');
1431: add_string(l_tmp, ' from wip_operations wo1 where wo1.operation_seq_num = ');
1432: add_string(l_tmp, ' ( select max(wo2.operation_seq_num) from wip_operations wo2 ');
1433: add_string(l_tmp, ' where wo2.count_point_type = 1 and ');
1434: add_string(l_tmp, ' wo2.operation_seq_num < qrslt.operation_seq_num and ');
1435: add_string(l_tmp, ' wo2.wip_entity_id = wo1.wip_entity_id and ');
1436: add_string(l_tmp, ' wo2.organization_id = wo1.organization_id ');
1436: add_string(l_tmp, ' wo2.organization_id = wo1.organization_id ');
1437: add_string(l_tmp, ' ) and wo1.wip_entity_id = qrslt.wip_entity_id )' );
1438: add_string(l_tmp, ' or ');
1439: add_string(l_tmp, ' 0 < (select (wo1.quantity_in_queue + wo1.quantity_running + wo1.quantity_waiting_to_move + wo1.quantity_rejected) ');
1440: add_string(l_tmp, ' from wip_operations wo1, wip_operations wo2 ');
1441: add_string(l_tmp, ' where wo2.previous_operation_seq_num = wo1.operation_seq_num and ');
1442: add_string(l_tmp, ' wo2.operation_seq_num = qrslt.operation_seq_num and ');
1443: add_string(l_tmp, ' wo2.wip_entity_id = qrslt.wip_entity_id and ');
1444: add_string(l_tmp, ' wo2.wip_entity_id = wo1.wip_entity_id )' );
1745: l_sql := l_sql || 'select wo.organization_id, wo.wip_entity_id, wo.operation_seq_num, wo.department_id, ';
1746: l_sql := l_sql || ' wo.first_unit_start_date, wo.last_unit_completion_date, ';
1747: l_sql := l_sql || ' wo.quantity_in_queue, wo.quantity_running, wo.quantity_waiting_to_move, wo.cumulative_scrap_quantity, ';
1748: l_sql := l_sql || ' wdj.start_quantity, wdj.quantity_completed, wdj.expedited, wdj.job_type, wdj.status_type ';
1749: l_sql := l_sql || 'from wip_operations wo, wip_discrete_jobs wdj ';
1750: l_sql := l_sql || 'where wo.organization_id = wdj.organization_id and ';
1751: l_sql := l_sql || ' wo.wip_entity_id = wdj.wip_entity_id and ';
1752: l_sql := l_sql || ' wo.actual_start_date is null ';
1753: l_sql := l_sql || ' ) qrslt ';
1896: l_sql := l_sql || 'select wo.organization_id, wo.wip_entity_id, wo.operation_seq_num, wo.department_id, ';
1897: l_sql := l_sql || ' wo.first_unit_start_date, wo.last_unit_completion_date, ';
1898: l_sql := l_sql || ' wo.quantity_in_queue, wo.quantity_running, wo.quantity_waiting_to_move, wo.cumulative_scrap_quantity, ';
1899: l_sql := l_sql || ' wdj.start_quantity, wdj.quantity_completed, wdj.expedited, wdj.job_type, wdj.status_type ';
1900: l_sql := l_sql || 'from wip_operations wo, wip_discrete_jobs wdj ';
1901: l_sql := l_sql || 'where wo.organization_id = wdj.organization_id and ';
1902: l_sql := l_sql || ' wo.wip_entity_id = wdj.wip_entity_id ';
1903: l_sql := l_sql || ' ) qrslt ';
1904: l_sql := l_sql || ' where ';
1976: select wo.organization_id, wo.department_id,
1977: wo.quantity_in_queue + wo.quantity_running,
1978: wo.quantity_waiting_to_move
1979: into l_org_id, l_dept_id, l_qty_queue_run, l_qty_to_move
1980: from wip_operations wo
1981: where wo.wip_entity_id = p_wip_entity_id and
1982: wo.operation_seq_num = p_op_seq;
1983:
1984: l_level_id := wip_ws_util.get_preference_level_id(WP_INCLUDE_COMPLETE_QTY, p_resp_key, l_org_id, l_dept_id);