APPS.INVIDIT3 dependencies on MTL_RESERVATIONS

Line 776: from mtl_reservations res,

772:
773: IF x_rsv_exists IS NOT NULL THEN
774: if (reservable_level = 1) then
775: select count(1) into x_rsv_exists
776: from mtl_reservations res,
777: mtl_parameters param
778: where res.inventory_item_id = p_item_id
779: AND res.organization_id = param.organization_id
780: and param.master_organization_id = p_master_org

Line 785: from mtl_reservations

781: and reservation_quantity > 0
782: and rownum = 1 ;
783: else
784: select count(1) into X_rsv_exists
785: from mtl_reservations
786: where organization_id = p_org_id
787: and inventory_item_id = p_item_id
788: and reservation_quantity > 0
789: and rownum = 1 ;