[Home] [Help]
481: mic.sr_category_id AS sr_category_id, mic.category_name AS category_name,
482: mp.compile_designator AS plan_name,
483: mtp.organization_code AS org_name,
484: msi.item_name AS item_name, cust.partner_id
485: FROM msc_plans mp, msc_system_items msi, msc_item_categories mic, msc_trading_partners mtp, msc_trading_partners cust,
486: msc_safety_stocks mss,
487: (SELECT demands.plan_id, demands.sr_instance_id, demands.organization_id, demands.using_assembly_item_id,
488: demands.customer_id, demands.demand_id
489: FROM msc_demands demands
532: mic.sr_category_id AS sr_category_id, mic.category_name AS category_name,
533: mp.compile_designator AS plan_name,
534: mtp.organization_code AS org_name,
535: cust.partner_id, cust.partner_name, cust.customer_class_code, msi.item_name AS item_name
536: FROM msc_plans mp, msc_system_items msi, msc_item_categories mic, msc_trading_partners mtp, msc_trading_partners cust,
537: (SELECT demands.plan_id, demands.sr_instance_id, demands.organization_id, demands.using_assembly_item_id,
538: demands.customer_id, demands.demand_id
539: FROM msc_demands demands
540: WHERE demands.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)) msd
646: msd.customer_id AS partner_id,
647: cust.partner_name AS partner_name,
648: cust.customer_class_code AS customer_class_code,
649: RECORD_SERVICE_LEVEL AS record_type
650: FROM msc_demands msd, msc_system_items msi,
651: msc_item_categories mic, msc_plans mp, msc_plan_organizations mpo,
652: msc_trading_partners cust
653: WHERE mp.plan_id = p_plan_id
654: AND msd.plan_id = msi.plan_id
747: NULL AS partner_id,
748: NULL AS partner_name,
749: NULL AS customer_class_code,
750: RECORD_SAFETY_STOCK AS record_type
751: FROM msc_safety_stocks mss, msc_system_items msi, msc_item_categories mic,
752: msc_plans mp, msc_plan_organizations mpo
753: WHERE mss.sr_instance_id = msi.sr_instance_id
754: AND mss.plan_id = msi.plan_id
755: AND mss.organization_id = msi.organization_id