[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';
1457: x_msg := '';
1458:
1459: select wdj.expedited
1460: into l_expedited
1461: from wip_discrete_jobs wdj
1462: where wdj.wip_entity_id = p_wip_entity_id;
1463:
1464: if( l_expedited is null or l_expedited = 'N') then
1465: update wip_discrete_jobs wdj
1461: from wip_discrete_jobs wdj
1462: where wdj.wip_entity_id = p_wip_entity_id;
1463:
1464: if( l_expedited is null or l_expedited = 'N') then
1465: update wip_discrete_jobs wdj
1466: set wdj.expedited = 'Y'
1467: where wdj.wip_entity_id = p_wip_entity_id;
1468: commit;
1469: else
1492: x_msg := '';
1493:
1494: select wdj.expedited
1495: into l_expedited
1496: from wip_discrete_jobs wdj
1497: where wdj.wip_entity_id = p_wip_entity_id;
1498:
1499: if( l_expedited = 'Y') then
1500: update wip_discrete_jobs wdj
1496: from wip_discrete_jobs wdj
1497: where wdj.wip_entity_id = p_wip_entity_id;
1498:
1499: if( l_expedited = 'Y') then
1500: update wip_discrete_jobs wdj
1501: set wdj.expedited = null /* set to N dosn't help on order */
1502: where wdj.wip_entity_id = p_wip_entity_id;
1503: commit;
1504: else
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 ';
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 ';