DBA Data[Home] [Help]

APPS.POR_AUTOSOURCE_UTIL_PKG dependencies on MTL_SECONDARY_INVENTORIES

Line 300: FROM mtl_secondary_inventories msub,

296:
297: cursor c_avail_quantity is
298: SELECT msub.secondary_inventory_name,
299: (nvl(mos.total_qoh,0) - sum(nvl(mrs.primary_reservation_quantity,0))) avail_quantity
300: FROM mtl_secondary_inventories msub,
301: mtl_onhand_sub_v mos,
302: mtl_reservations mrs,
303: mtl_system_items msi
304: WHERE msub.organization_id = l_source_organization_id -- bug 5470125, do not bind p_source_organization_id