DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_PKG dependencies on MSC_SUPPLIES

Line 202: MSC_SUPPLIES ms,

198: sum(msc_supplier_pkg.supplier_spend_value (ms.new_order_quantity,
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