[Home] [Help]
160: FROM msc_supplies sup,
161: msc_full_pegging mfp,
162: msc_demands md2,
163: msc_demands md,
164: msc_exception_details exp,
165: msc_system_items mi,
166: msc_trading_partners mtp,
167: mfg_lookups ml,
168: mfg_lookups sup_ml
333: FROM msc_supplies sup,
334: msc_full_pegging mfp,
335: msc_demands md2,
336: msc_demands md,
337: msc_exception_details exp,
338: msc_system_items mi,
339: msc_trading_partners mtp,
340: mfg_lookups ml,
341: mfg_lookups sup_ml
508: FROM msc_supplies sup,
509: msc_full_pegging mfp,
510: msc_demands md2,
511: msc_demands md,
512: msc_exception_details exp,
513: msc_system_items mi,
514: msc_trading_partners mtp,
515: mfg_lookups ml,
516: mfg_lookups sup_ml
545: p_plan_id in number) IS
546: SELECT vend.partner_id,
547: vend.partner_name
548: FROM msc_trading_partners vend,
549: msc_exception_details exp,
550: msc_supplies ms
551: WHERE vend.partner_id = nvl(exp.supplier_id, ms.supplier_id)
552: AND vend.partner_type = 1
553: AND ms.plan_id (+) = exp.plan_id
562: site.partner_site_id,
563: site.tp_site_code
564: FROM msc_trading_partners vend,
565: msc_trading_partner_sites site,
566: msc_exception_details exp,
567: msc_supplies ms
568: WHERE site.partner_site_id = nvl(exp.supplier_site_id,ms.supplier_site_id)
569: AND vend.partner_id = nvl(exp.supplier_id, ms.supplier_id)
570: AND vend.partner_type = 1
578: SELECT vend.partner_id,
579: vend.partner_name
580: FROM msc_trading_partners vend,
581: msc_demands rec,
582: msc_exception_details exp
583: WHERE vend.sr_tp_id = rec.customer_id
584: AND vend.sr_instance_id = rec.sr_instance_id
585: AND vend.partner_type = 2
586: AND rec.demand_id = exp.number1
1060: md.demand_id,
1061: md.latest_acceptable_date,
1062: msc_get_name.lookup_meaning('SYS_YES_NO',md.atp_override_flag) atp_override_flag
1063: from msc_demands md,
1064: msc_exception_details med
1065: where med.plan_id = md.plan_id
1066: and med.number1 = md.demand_id
1067: and med.sr_instance_id = md.sr_instance_id
1068: and med.plan_id = p_plan_id
2317: NVL(utilization_rate,quantity),supplier_id,
2318: supplier_site_id, inventory_item_id, organization_id, sr_instance_id
2319: INTO p_from_date,p_to_date,p_percent,p_partner_id,p_site_id,p_item_id,
2320: p_org_id,p_inst_id
2321: FROM msc_exception_details_v
2322: WHERE plan_id = arg_plan_id
2323: AND exception_id = arg_exception_id;
2324:
2325: -- Get the tolerance information
2476:
2477: CURSOR SUPCNT_C(p_exception_id in number,p_plan_id in number) IS
2478: SELECT name
2479: FROM msc_partner_contacts cont,
2480: msc_exception_details exp,
2481: msc_supplies ms
2482: WHERE exp.exception_detail_id = p_exception_id
2483: AND exp.plan_id = p_plan_id
2484: AND cont.partner_site_id = nvl(exp.supplier_site_id,ms.supplier_site_id)
2491: p_plan_id in number) IS
2492: SELECT so.salesrep_id
2493: FROM msc_sales_orders so,
2494: msc_demands mgr,
2495: msc_exception_details exp
2496: WHERE so.sales_order_number = mgr.order_number
2497: AND so.sr_instance_id = mgr.sr_instance_id
2498: AND mgr.plan_id = exp.plan_id
2499: AND mgr.demand_id = exp.number1
2512:
2513: CURSOR CUSTCNT_C(p_exception_id in number, p_plan_id in number) IS
2514: SELECT name
2515: FROM msc_partner_contacts cont, msc_demands mgr,
2516: msc_exception_details exp
2517: WHERE exp.exception_detail_id = p_exception_id
2518: AND exp.plan_id = p_plan_id
2519: AND cont.partner_id = mgr.customer_id
2520: AND cont.partner_site_id = mgr.customer_site_id