DBA Data[Home] [Help]

APPS.WIP_WS_DL_UTIL dependencies on WIP_OPERATIONS

Line 260: from wip_operations wo1

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

Line 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

Line 271: from wip_operations wo3

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: )

Line 634: from wip_operations wo

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:

Line 734: wip_operations wo,

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

Line 843: from wip_operations wo

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;

Line 1417: add_string(l_tmp, ' from wip_operations wo1 where wo1.operation_seq_num = ');

1413: end if;
1414:
1415: add_string(l_tmp, ' and ', '( ');
1416: add_string(l_tmp, ' 0 < (select (wo1.quantity_in_queue + wo1.quantity_running + wo1.quantity_waiting_to_move + wo1.quantity_rejected) ');
1417: add_string(l_tmp, ' from wip_operations wo1 where wo1.operation_seq_num = ');
1418: add_string(l_tmp, ' ( select max(wo2.operation_seq_num) from wip_operations wo2 ');
1419: add_string(l_tmp, ' where wo2.count_point_type = 1 and ');
1420: add_string(l_tmp, ' wo2.operation_seq_num < qrslt.operation_seq_num and ');
1421: add_string(l_tmp, ' wo2.wip_entity_id = wo1.wip_entity_id and ');

Line 1418: add_string(l_tmp, ' ( select max(wo2.operation_seq_num) from wip_operations wo2 ');

1414:
1415: add_string(l_tmp, ' and ', '( ');
1416: add_string(l_tmp, ' 0 < (select (wo1.quantity_in_queue + wo1.quantity_running + wo1.quantity_waiting_to_move + wo1.quantity_rejected) ');
1417: add_string(l_tmp, ' from wip_operations wo1 where wo1.operation_seq_num = ');
1418: add_string(l_tmp, ' ( select max(wo2.operation_seq_num) from wip_operations wo2 ');
1419: add_string(l_tmp, ' where wo2.count_point_type = 1 and ');
1420: add_string(l_tmp, ' wo2.operation_seq_num < qrslt.operation_seq_num and ');
1421: add_string(l_tmp, ' wo2.wip_entity_id = wo1.wip_entity_id and ');
1422: add_string(l_tmp, ' wo2.organization_id = wo1.organization_id ');

Line 1426: add_string(l_tmp, ' from wip_operations wo1, wip_operations wo2 ');

1422: add_string(l_tmp, ' wo2.organization_id = wo1.organization_id ');
1423: add_string(l_tmp, ' ) and wo1.wip_entity_id = qrslt.wip_entity_id )' );
1424: add_string(l_tmp, ' or ');
1425: add_string(l_tmp, ' 0 < (select (wo1.quantity_in_queue + wo1.quantity_running + wo1.quantity_waiting_to_move + wo1.quantity_rejected) ');
1426: add_string(l_tmp, ' from wip_operations wo1, wip_operations wo2 ');
1427: add_string(l_tmp, ' where wo2.previous_operation_seq_num = wo1.operation_seq_num and ');
1428: add_string(l_tmp, ' wo2.operation_seq_num = qrslt.operation_seq_num and ');
1429: add_string(l_tmp, ' wo2.wip_entity_id = qrslt.wip_entity_id and ');
1430: add_string(l_tmp, ' wo2.wip_entity_id = wo1.wip_entity_id )' );

Line 1730: l_sql := l_sql || 'from wip_operations wo, wip_discrete_jobs wdj ';

1726: l_sql := l_sql || 'select wo.organization_id, wo.wip_entity_id, wo.operation_seq_num, wo.department_id, ';
1727: l_sql := l_sql || ' wo.first_unit_start_date, wo.last_unit_completion_date, ';
1728: l_sql := l_sql || ' wo.quantity_in_queue, wo.quantity_running, wo.quantity_waiting_to_move, wo.cumulative_scrap_quantity, ';
1729: l_sql := l_sql || ' wdj.start_quantity, wdj.quantity_completed, wdj.expedited, wdj.job_type, wdj.status_type ';
1730: l_sql := l_sql || 'from wip_operations wo, wip_discrete_jobs wdj ';
1731: l_sql := l_sql || 'where wo.organization_id = wdj.organization_id and ';
1732: l_sql := l_sql || ' wo.wip_entity_id = wdj.wip_entity_id and ';
1733: l_sql := l_sql || ' wo.actual_start_date is null ';
1734: l_sql := l_sql || ' ) qrslt ';

Line 1878: l_sql := l_sql || 'from wip_operations wo, wip_discrete_jobs wdj ';

1874: l_sql := l_sql || 'select wo.organization_id, wo.wip_entity_id, wo.operation_seq_num, wo.department_id, ';
1875: l_sql := l_sql || ' wo.first_unit_start_date, wo.last_unit_completion_date, ';
1876: l_sql := l_sql || ' wo.quantity_in_queue, wo.quantity_running, wo.quantity_waiting_to_move, wo.cumulative_scrap_quantity, ';
1877: l_sql := l_sql || ' wdj.start_quantity, wdj.quantity_completed, wdj.expedited, wdj.job_type, wdj.status_type ';
1878: l_sql := l_sql || 'from wip_operations wo, wip_discrete_jobs wdj ';
1879: l_sql := l_sql || 'where wo.organization_id = wdj.organization_id and ';
1880: l_sql := l_sql || ' wo.wip_entity_id = wdj.wip_entity_id ';
1881: l_sql := l_sql || ' ) qrslt ';
1882: l_sql := l_sql || ' where ';

Line 1958: from wip_operations wo

1954: select wo.organization_id, wo.department_id,
1955: wo.quantity_in_queue + wo.quantity_running,
1956: wo.quantity_waiting_to_move
1957: into l_org_id, l_dept_id, l_qty_queue_run, l_qty_to_move
1958: from wip_operations wo
1959: where wo.wip_entity_id = p_wip_entity_id and
1960: wo.operation_seq_num = p_op_seq;
1961:
1962: l_level_id := wip_ws_util.get_preference_level_id(WP_INCLUDE_COMPLETE_QTY, p_resp_key, l_org_id, l_dept_id);