DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_PKG dependencies on MSC_SUPPLIER_REQUIREMENTS

Line 78: from msc_supplier_requirements msr

74: msr.supplier_id,
75: nvl(msr.supplier_site_id, -23453) supplier_site_id,
76: trunc(msr.consumption_date) analysis_date,
77: msr.consumed_quantity required_qty -- ignore overloaded_capacity
78: from msc_supplier_requirements msr
79: where l_plan_type not in (6)
80: and msr.plan_id=p_plan_id
81: and l_plan_constrained=SYS_YES
82: union all