APPS.INVIDIT3 dependencies on MTL_RESERVATIONS

Line 810: from mtl_reservations res,

806:
807: IF x_rsv_exists IS NOT NULL THEN
808: if (reservable_level = 1) then
809: select count(1) into x_rsv_exists
810: from mtl_reservations res,
811: mtl_parameters param
812: where res.inventory_item_id = p_item_id
813: AND res.organization_id = param.organization_id
814: and param.master_organization_id = p_master_org

Line 819: from mtl_reservations

815: and reservation_quantity > 0
816: and rownum = 1 ;
817: else
818: select count(1) into X_rsv_exists
819: from mtl_reservations
820: where organization_id = p_org_id
821: and inventory_item_id = p_item_id
822: and reservation_quantity > 0
823: and rownum = 1 ;