DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_PKG dependencies on MSC_SYSTEM_ITEMS

Line 203: MSC_SYSTEM_ITEMS msi,

199: nvl(ms.DELIVERY_PRICE,msi.list_price), ms.order_type)) buy_order_value,
200: sum(msc_supplier_pkg.is_new_buy_order(ms.order_type, l_plan_type, msi.purchasing_enabled_flag)) buy_order_count
201: from
202: MSC_SUPPLIES ms,
203: MSC_SYSTEM_ITEMS msi,
204: msc_plans mp,
205: msc_trading_partners mtp
206: where
207: mp.plan_id = p_plan_id