DBA Data[Home] [Help]

APPS.MSC_SUPPLIER_PKG dependencies on MSC_BIS_INV_DETAIL

Line 91: from msc_bis_inv_detail mbid

87: mbid.supplier_id,
88: nvl(mbid.supplier_site_id, -23453) supplier_site_id,
89: trunc(mbid.detail_date) analysis_date,
90: mbid.supplier_usage required_qty
91: from msc_bis_inv_detail mbid
92: where l_plan_type in (6)
93: and mbid.plan_id=p_plan_id
94: and mbid.supplier_id is not null
95: union all

Line 265: from msc_bis_inv_detail mbid

261: first_value(mbid.supplier_capacity) over(
262: partition by mbid.inventory_item_id, mbid.supplier_id,
263: nvl(mbid.supplier_site_id, -23453),
264: trunc(mbid.detail_date)) avail_qty
265: from msc_bis_inv_detail mbid
266: where l_plan_type in (6)
267: and mbid.plan_id=p_plan_id
268: and mbid.supplier_id is not null
269: ) f,