DBA Data[Home] [Help]

APPS.MSC_DRP_HORI_PLAN dependencies on MSC_INVENTORY_LEVELS

Line 585: FROM msc_inventory_levels mil,

581: sum(nvl(mil.max_quantity,0) * nvl(msi.unit_weight,0)) weight,
582: sum(nvl(mil.max_quantity,0) * nvl(msi.unit_volume,0)) volume,
583: sum(nvl(mil.target_quantity,0) * nvl(msi.unit_weight,0)) quantity2,
584: sum(nvl(mil.target_quantity,0) * nvl(msi.unit_volume,0)) quantity3
585: FROM msc_inventory_levels mil,
586: msc_system_items msi,
587: msc_form_query mfq
588: WHERE trunc(mil.inventory_date) <= last_date
589: AND mil.organization_id = mfq.number2