DBA Data[Home] [Help]

APPS.MSC_ANALYSIS_SAFETY_STOCK dependencies on MSC_SAFETY_STOCKS

Line 486: msc_safety_stocks mss,

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
490: WHERE demands.origination_type IN (6,7,8,9,11,12,15,22,28,29,30)) msd

Line 751: FROM msc_safety_stocks mss, msc_system_items msi, msc_item_categories mic,

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