DBA Data[Home] [Help]

APPS.MSC_HORIZONTAL_PLAN_SC dependencies on MSC_INVENTORY_LEVELS

Line 959: FROM msc_inventory_levels lvl,

955: min(lvl.Min_quantity) new_quantity,
956: min(0) old_quantity,
957: min(lvl.min_quantity_dos) dos,
958: 0
959: FROM msc_inventory_levels lvl,
960: msc_form_query list
961: WHERE lvl.inventory_date <= last_date
962: AND lvl.organization_id = list.number2
963: AND lvl.sr_instance_id = list.number3

Line 987: FROM msc_inventory_levels lvl,

983: max(lvl.Max_quantity) new_quantity,
984: max(0) old_quantity,
985: max(lvl.max_quantity_dos) dos,
986: 0
987: FROM msc_inventory_levels lvl,
988: msc_form_query list
989: WHERE lvl.inventory_date<= last_date
990: AND lvl.organization_id = list.number2
991: AND lvl.sr_instance_id = list.number3