DBA Data[Home] [Help]

APPS.MSC_DRP_HORI_PLAN dependencies on MSC_SAFETY_STOCKS

Line 551: FROM msc_safety_stocks safety,

547: sum(safety.safety_stock_quantity * nvl(msi.unit_weight,0)) weight,
548: sum(safety.safety_stock_quantity * nvl(msi.unit_volume,0)) volume,
549: 0 quantity2,
550: 0 quantity3
551: FROM msc_safety_stocks safety,
552: msc_system_items msi,
553: msc_form_query mfq
554: WHERE trunc(safety.period_start_date) <= last_date
555: AND safety.organization_id = mfq.number2