APPS.MSC_ANALYSIS_PKG dependencies on MSC_SUPPLIES

Line 1351: from msc_supplies ms,

1347: and nvl(mbid.period_type, 0) = 0;
1348: */
1349: cursor c_tp_cost_new (p_plan_id in number, l_otype1 in number, l_otype2 in number, l_otype3 in number) is
1350: select round(sum(nvl(((ms.new_order_quantity * msi.unit_weight) * mism.cost_per_weight_unit),0)),6)
1351: from msc_supplies ms,
1352: msc_system_items msi,
1353: msc_interorg_ship_methods mism,
1354: msc_plans mp
1355: WHERE ms.plan_id = p_plan_id

Line 1599: ' from msc_supplies ms, '||

1595:
1596:
1597: sql_stat := ' select round(sum(nvl(((ms.new_order_quantity * '||
1598: ' msi.unit_weight) * mism.cost_per_weight_unit),0)),6), 0'||
1599: ' from msc_supplies ms, '||
1600: ' msc_system_items msi, '||
1601: ' msc_interorg_ship_methods mism '||
1602: ' WHERE ms.plan_id = :1 ' ||
1603: ' and ms.organization_id != ms.source_organization_id '||