DBA Data[Home] [Help]

APPS.POR_AUTOSOURCE_UTIL_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 266: FROM mtl_secondary_inventories msub,

262:
263: cursor c_avail_quantity is
264: SELECT msub.secondary_inventory_name,
265: (nvl(mos.total_qoh,0) - sum(nvl(mrs.primary_reservation_quantity,0))) avail_quantity
266: FROM mtl_secondary_inventories msub,
267: mtl_onhand_sub_v mos,
268: mtl_reservations mrs,
269: mtl_system_items msi
270: WHERE msub.organization_id = l_source_organization_id -- bug 5470125, do not bind p_source_organization_id