APPS.MSC_ITEM_PKG dependencies on MSC_SAFETY_STOCKS

Line 1007: from msc_safety_stocks f, msc_hub_query d

1003: f.total_unpooled_safety_stock,
1004: rank() over (partition by f.plan_id,
1005: f.sr_instance_id, f.organization_id, f.inventory_item_id,
1006: d.date2 order by f.period_start_date desc) rn
1007: from msc_safety_stocks f, msc_hub_query d
1008: where f.plan_id=p_plan_id
1009: and p_plan_id <> -1
1010: and d.query_id=l_qid_last_date1
1011: and f.period_start_date <= d.date2