DBA Data[Home] [Help]

APPS.MSC_ANALYSIS_SAFETY_STOCK_PERF dependencies on MSC_SAFETY_STOCKS

Line 1657: FROM msc_plan_organizations mpo, msc_safety_stocks mss,

1653: 0 AS nr_sl_records,
1654: NULL AS partner_id,
1655: NULL AS customer_class_code,
1656: RECORD_SAFETY_STOCK AS record_type
1657: FROM msc_plan_organizations mpo, msc_safety_stocks mss,
1658: msc_system_items msi, msc_item_categories mic
1659: WHERE mss.sr_instance_id = msi.sr_instance_id
1660: AND mss.plan_id = msi.plan_id
1661: AND mss.organization_id = msi.organization_id

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

1794: 0 AS nr_sl_records,
1795: NULL AS partner_id,
1796: NULL AS customer_class_code,
1797: RECORD_SAFETY_STOCK AS record_type
1798: FROM msc_safety_stocks mss, msc_system_items msi, msc_item_categories mic,
1799: msc_plans mp, msc_plan_organizations mpo
1800: WHERE mss.sr_instance_id = msi.sr_instance_id
1801: AND mss.plan_id = msi.plan_id
1802: AND mss.organization_id = msi.organization_id