DBA Data[Home] [Help]

APPS.INV_RSV_DETAIL_STAGE_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 74: FROM mtl_secondary_inventories

70: IF l_rsv_rec.subinventory_code IS NOT NULL AND l_rsv_rec.organization_id IS NOT NULL THEN
71: BEGIN
72: SELECT NVL(reservable_type, 1)
73: INTO l_sub_reservable_type
74: FROM mtl_secondary_inventories
75: WHERE organization_id = l_rsv_rec.organization_id
76: AND secondary_inventory_name = l_rsv_rec.subinventory_code;
77: EXCEPTION
78: WHEN OTHERS THEN