[Home] [Help]
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
169: WHERE exp.exception_type in
170: (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20,24,25,26,27,28,37,49,70)
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
342: WHERE exp.exception_type in
343: (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20,24,25,26,27,28,37,49,70)
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
517: WHERE exp.exception_type in
518: (1,2,3,6,7,8,9,10,12,13,14,15,16,17,18,19,20,24,25,26,27,28,37,49,70)
544: CURSOR SUPPLIER_C(p_exception_id in number,
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
560: SELECT vend.partner_id,
561: vend.partner_name,
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)
576: CURSOR CUSTOMER_C(p_exception_id in number,
577: p_plan_id in number) IS
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