[Home] [Help]
152: ms.transaction_id,
153: msc_gantt_utils.isCriticalSupply(x_plan_id, g_end_demand_id,
154: ms.transaction_id, ms.sr_instance_id) critical_supply
155: from msc_full_pegging mfp,
156: msc_supplies ms
157: where mfp.demand_id = x_demand_id
158: and mfp.plan_id = x_plan_id
159: and ms.plan_id = mfp.plan_id
160: and ms.transaction_id = mfp.transaction_id
243: mrr.operation_seq_num, mrr.routing_sequence_id)) critical_flag,
244: mrr.operation_seq_num,
245: mrr.resource_seq_num
246: from msc_resource_requirements mrr,
247: msc_supplies ms
248: where mrr.plan_id = x_plan_id
249: and mrr.sr_instance_id = x_instance_id
250: and mrr.organization_id = x_org_id
251: and mrr.supply_id = x_supply_id
276: ms.new_wip_start_date, ms.new_ship_date,ms.new_schedule_date,
277: ms.source_supplier_id) start_date,
278: ms.order_type
279: from msc_form_query mfq,
280: msc_supplies ms,
281: msc_system_items msi
282: where mfq.query_id = x_dem_op_query_id
283: and mfq.number1 = x_supply_id
284: and ms.plan_id = x_plan_id
310: ms.order_type
311: from msc_full_pegging mfp1,
312: msc_full_pegging mfp2,
313: msc_form_query mfq,
314: msc_supplies ms,
315: msc_system_items msi
316: where mfp1.plan_id = x_plan_id
317: and mfp1.sr_instance_id = x_instance_id
318: and mfp1.transaction_id = x_supply_id
355: ms.source_supplier_id) start_date,
356: ms.order_type
357: from msc_full_pegging mfp1,
358: msc_full_pegging mfp2,
359: msc_supplies ms,
360: msc_system_items msi
361: where mfp1.plan_id = x_plan_id
362: and mfp1.sr_instance_id = x_instance_id
363: and mfp1.transaction_id = x_supply_id
391: ms.source_supplier_id) start_date,
392: ms.order_type
393: from msc_full_pegging mfp1,
394: msc_full_pegging mfp2,
395: msc_supplies ms,
396: msc_system_items msi
397: where mfp1.plan_id = x_plan_id
398: and mfp1.sr_instance_id = x_instance_id
399: and mfp1.transaction_id = x_supply_id
428: msc_gantt_utils.isCriticalSupply(x_plan_id,g_end_demand_id,
429: ms.transaction_id, ms.sr_instance_id)) critical_supply,
430: ms.new_wip_start_date start_date,
431: ms.order_type
432: from msc_supplies ms
433: where ms.plan_id = x_plan_id
434: and ms.sr_instance_id = x_instance_id
435: and ms.disposition_id = x_supply_id
436: -- and ms.order_type in (14,15,16,17,28)
452: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
453: ms.transaction_id, ms.sr_instance_id) critical_supply
454: from msc_full_pegging mfp1,
455: msc_full_pegging mfp2,
456: msc_supplies ms,
457: msc_demands md,
458: msc_form_query mfq
459: where mfp1.plan_id = x_plan_id
460: and mfp1.transaction_id = x_supply_id
484: msc_gantt_utils.isCriticalSupply(ms.plan_id, g_end_demand_id,
485: ms.transaction_id, ms.sr_instance_id) critical_supply
486: from msc_full_pegging mfp1,
487: msc_full_pegging mfp2,
488: msc_supplies ms,
489: msc_demands md
490: where mfp1.plan_id = x_plan_id
491: and mfp1.transaction_id = x_supply_id
492: and mfp1.sr_instance_id = x_instance_id
1029: l_ordertype msc_gantt_utils.number_arr;
1030:
1031: cursor c_order_type (p_plan number, p_inst number, p_trx number) is
1032: select ms.order_type, ms.disposition_id
1033: from msc_supplies ms
1034: where ms.plan_id = p_plan
1035: and ms.sr_instance_id = p_inst
1036: and ms.transaction_id = p_trx;
1037:
1845: nvl(ms.supplier_id, mbp_null_value),
1846: nvl(ms.supplier_site_id, mbp_null_value)
1847: bulk collect into v_inst_id, v_org_id, v_item_id, v_supp_id, v_supp_site_id
1848: from msc_gantt_query mgq,
1849: msc_supplies ms
1850: where mgq.query_id = p_from_query_id
1851: and mgq.row_index = p_from_index
1852: and ms.plan_id = g_plan_id
1853: and ms.sr_instance_id = mgq.sr_instance_id