[Home] [Help]
290: Is
291: select count(distinct ool.sold_to_org_id)
292: from HZ_CUST_ACCOUNTS cust_accnt, mtl_reservations mr,
293: mtl_sales_orders mso, oe_order_lines_all ool
294: , wip_discrete_jobs wdj
295: where mso.sales_order_id = mr.demand_source_header_id
296: and mr.demand_source_line_id = ool.line_id
297: and mr.demand_source_type_id = 2
298: and mr.supply_source_type_id = 5
305: Is
306: select cust_party.party_name
307: from HZ_CUST_ACCOUNTS cust_accnt, HZ_PARTIES cust_party,
308: mtl_reservations mr, mtl_sales_orders mso, oe_order_lines_all ool,
309: wip_discrete_jobs wdj
310: where mso.sales_order_id = mr.demand_source_header_id
311: and mr.demand_source_line_id = ool.line_id
312: and mr.demand_source_type_id = 2
313: and mr.supply_source_type_id = 5
346: cursor c_num_sales_orders(p_org_id number, p_wip_entity_id number)
347: Is
348: select count(distinct mso.segment1)
349: from mtl_reservations mr, mtl_sales_orders mso,
350: oe_order_lines_all ool, wip_discrete_jobs wdj
351: where mso.sales_order_id = mr.demand_source_header_id
352: and mr.demand_source_line_id = ool.line_id
353: and mr.demand_source_type_id = 2
354: and mr.supply_source_type_id = 5
360: cursor c_sales_orders(p_org_id number, p_wip_entity_id number)
361: Is
362: select mso.concatenated_segments
363: from mtl_reservations mr, mtl_sales_orders_kfv mso,
364: oe_order_lines_all ool, wip_discrete_jobs wdj
365: where mso.sales_order_id = mr.demand_source_header_id
366: and mr.demand_source_line_id = ool.line_id
367: and mr.demand_source_type_id = 2
368: and mr.supply_source_type_id = 5
508: begin
509: select decode(wdj.project_id, null, null,
510: pjm_project.all_proj_idtonum(wdj.project_id))
511: into l_name
512: from wip_discrete_jobs wdj
513: where wdj.wip_entity_id = p_wip_entity_id;
514:
515: return l_name;
516: Exception
527: begin
528: select decode(wdj.task_id, null, null,
529: pjm_project.all_task_idtonum(wdj.task_id))
530: into l_name
531: from wip_discrete_jobs wdj
532: where wdj.wip_entity_id = p_wip_entity_id;
533:
534: return l_name;
535: Exception
729: null) usage,
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,
854: l_status_type number;
855: Begin
856: select wdj.status_type
857: into l_status_type
858: from wip_discrete_jobs wdj
859: where wdj.wip_entity_id = p_wip_entity_id;
860:
861: if( l_status_type <> 3 ) then /* not released */
862: return 'N';
1474: x_msg := '';
1475:
1476: select wdj.expedited
1477: into l_expedited
1478: from wip_discrete_jobs wdj
1479: where wdj.wip_entity_id = p_wip_entity_id;
1480:
1481: if( l_expedited is null or l_expedited = 'N') then
1482: update wip_discrete_jobs wdj
1478: from wip_discrete_jobs wdj
1479: where wdj.wip_entity_id = p_wip_entity_id;
1480:
1481: if( l_expedited is null or l_expedited = 'N') then
1482: update wip_discrete_jobs wdj
1483: set wdj.expedited = 'Y'
1484: where wdj.wip_entity_id = p_wip_entity_id;
1485: commit;
1486: else
1509: x_msg := '';
1510:
1511: select wdj.expedited
1512: into l_expedited
1513: from wip_discrete_jobs wdj
1514: where wdj.wip_entity_id = p_wip_entity_id;
1515:
1516: if( l_expedited = 'Y') then
1517: update wip_discrete_jobs wdj
1513: from wip_discrete_jobs wdj
1514: where wdj.wip_entity_id = p_wip_entity_id;
1515:
1516: if( l_expedited = 'Y') then
1517: update wip_discrete_jobs wdj
1518: set wdj.expedited = null /* set to N dosn't help on order */
1519: where wdj.wip_entity_id = p_wip_entity_id;
1520: commit;
1521: else
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 ';